[simonw]

I've been having a lot of fun with the SQLite FTS library. The best public-facing demo I have is probably the search feature on https://datasette.io - e.g. https://datasette.io/-/beta?q=fts- that's powered by my https://github.com/dogsheep/dogsheep-beta tool.