News for hackers. Stuff that matters.
Re:PostgreSQL for Everything by cauchyk on Wednesday August 19, 2026 @12:05PM (#49363406)
as someone who loves postgres, this take is getting pretty old. yes we can do quite a bit with extensions but extensions often need to interface with external systems and even then managed providers don't consistently support all extensions. some gaps: bm25 indexes, olap support, also extensions also run into licensing restrictions.
Re:PostgreSQL for Everything by jankovicsandras on Thursday August 20, 2026 @03:00AM (#49371344)
You can do BM25 and hybrid search in Postgres.

Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain )

The repo includes also plpgsql_bm25rrf.sql : PL/pgSQL function for hybrid search ( plpgsql_bm25 + pgvector ) with Reciprocal Rank Fusion; and Jupyter notebook examples.