searchengine

Postgres as a search engine
https://anyblockers.com/posts/postgres-as-a-search-engine
https://news.ycombinator.com/item?id=41343814

Build a retrieval system with semantic, full-text, & fuzzy search in Postgres to be used as a backbone in RAG pipelines.

We’ll combine 3 techniques:

* full-text search with tsvector
* semantic search with pgvector
* fuzzy matching with pg_trgm

* bonus: BM25

https://en.wikipedia.org/wiki/Okapi_BM25
https://blog.paradedb.com/pages/elasticsearch_vs_postgres
https://news.ycombinator.com/item?id=41173288

#RDBMS #postgres #PostgreSQL #databases #search #SearchEngine #LLM #RAG #BM25

Hey #Musicians, if you're on #Bandwagon, the time has come.

I'm prepping the #SearchEngine and giving you a preview of how it'll work. Just jump over to bandwagon.fm and hit "Discover" to check it out.

I'm really pleased with this first step, but it will still be a just dumb, empty shell until we can get all your music is tagged, and optimize the tags/categories together.

You can read my full post at https://bandwagon.fm/2025-01-22-Search-Engine for all the details.

I can't wait to hear what you think.