4 ms·
SQLite ver: 1. Full-text search with FTS5 2. Semantic search with sqlite-vec 3. Fuzzy matching with FTS5 trigram tokenizer 4. Bonus: FTS5 bm25() function
by feverzsj 2y ago
SQLite ver:
1. Full-text search with FTS5
2. Semantic search with sqlite-vec
3. Fuzzy matching with FTS5 trigram tokenizer
4. Bonus: FTS5 bm25() function
- bityard 2y agoFTS5 is amazing. Is there anything that's as small and easy to use as FTS5 for indexing text files or JSON documents on the file system?
- elesbao 2y agoI'd like to see that ! been fiddling with sqlite and fts5 to drop algolia from my application.
- otoolep 2y agoI wrote about this too[1], and since rqlite[2] puts a HTTP API in front of SQLite, you've got a SQLite-backed search engine available over the network. [1] https://www.philipotoole.com/building-a-highly-available-search-engine-using-sqlite/ https://www.philipotoole.com/building-a-highly-available-sea... [2] https://rqlite.io 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.
- deleted 2y ago[deleted]