1. Full-text search with FTS5
2. Semantic search with sqlite-vec
3. Fuzzy matching with FTS5 trigram tokenizer
4. Bonus: FTS5 bm25() function
Is there anything that's as small and easy to use as FTS5 for indexing text files or JSON documents on the file system?
[1] https://www.philipotoole.com/building-a-highly-available-sea...
[2] https://rqlite.io
Disclaimer: I'm the creator of rqlite, and it's not the only piece of software to make SQLite available over the network.
1. Full-text search with FTS5
2. Semantic search with sqlite-vec
3. Fuzzy matching with FTS5 trigram tokenizer
4. Bonus: FTS5 bm25() function