Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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



FTS5 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?


I 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-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.


I'd like to see that ! been fiddling with sqlite and fts5 to drop algolia from my application.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: