Postgres as a Search Engine

Re:Postgres as a Search Engine by feverzsj on Sunday August 25, 2024 @02:38AM (#41344981)

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

[ Parent | on HN ]

Re:Postgres as a Search Engine by bityard on Sunday August 25, 2024 @05:00AM (#41345726)

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?

[ Parent | on HN ]

Re:Postgres as a Search Engine by elesbao on Sunday August 25, 2024 @08:36AM (#41346870)

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

[ Parent | on HN ]

Re:Postgres as a Search Engine by otoolep on Sunday August 25, 2024 @09:20AM (#41347105)

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.

[ Parent | on HN ]