Simon Willison has good posts on implementing full text search on top of sqlite[1]

[1]: https://simonwillison.net/2019/Jan/7/exploring-search-releva...