Hacker GitHub

← All repos

jankovicsandras/plpgsql_bm25

View on GitHub ↗ ★ 132 Jupyter Notebook

BM25 search implemented in PL/pgSQL

14 mentions on Hacker News by 1 person: 1 story, 13 comments · first 2024-09-23 · latest 2026-08-26

Mentions per year 14 mentions · busiest year 2024 (6)
20082026
AllStoriesComments NewestTopOldest
  1. If someone has a Postgres db and want very simple RAG: 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…
    comment by jankovicsandras · 2026-08-26 · in RAG Is Simpler Than You Think
  2. 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…
    comment by jankovicsandras · 2026-08-20 · in PostgreSQL for Everything
  3. You can do 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…
    comment by jankovicsandras · 2026-01-15 · in Ask HN: How are you doing RAG locally?
  4. You can do hybrid search in Postgres. Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain ) The repo includes plpgsql_bm25rrf.sql : PL/pgSQL function for hybrid…
    comment by jankovicsandras · 2025-12-16 · in 7 Years, 2 Rebuilds, 40K+ Stars: Milvus Recap and Roadmap
  5. Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain ) The repo includes plpgsql_bm25rrf.sql : PL/pgSQL function for Hybrid search ( plpgsql_bm25 + pgvector ) with…
    comment by jankovicsandras · 2025-11-03 · in The Case Against PGVector
  6. …Shameless plug: plpgsql_bm25: BM25 search implemented in PL/pgSQL (The Unlicense / PUBLIC DOMAIN) https://github.com/jankovicsandras/plpgsql_bm25 There's an example Postgres_hybrid_search_RRF.ipynb in the repo which shows hybrid search…
    comment by jankovicsandras · 2025-10-21 · in Production RAG: what I learned from processing 5M+ documents
  7. Postgres is a good idea. Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL, there's also an example of Hybrid (BM25+pgvector) search in the repo.
    comment by jankovicsandras · 2025-03-18 · in Ask HN: Alternatives to Vector DB?
  8. This looks cool! Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL, might be useful if one can't use Rust extensions with Postgres, e. g. hosted Postgres without admin rights.
    comment by jankovicsandras · 2025-03-03 · in BM25 in PostgreSQL
  9. Can you please add this shameless plug? https://github.com/jankovicsandras/plpgsql_bm25 Opensource BM25 search in PL/pgSQL (for example where you can't use Rust extensions), and hybrid search with pgvector and Reciprocal Rank Fusion.
    comment by jankovicsandras · 2024-12-07 · in How to use Postgres for everything
  10. Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 https://github.com/jankovicsandras/bm25opt
    comment by jankovicsandras · 2024-11-20 · in Understanding the BM25 full text search algorithm
  11. …or post-filtering, optimized automatically). Shameless plug: BM25 search implemented in PL/pgSQL: https://github.com/jankovicsandras/plpgsql_bm25 faster BM25 search algorithms in Python: https://github.com/jankovicsandras/bm25opt
    comment by jankovicsandras · 2024-10-30 · in Vector databases are the wrong abstraction
  12. …source Okapi BM25 search for Postgresql implemented in PL/pgSQL, so it works without extensions. https://github.com/jankovicsandras/plpgsql_bm25 Might be useful in hosted/cloud Postgres, where you can't use Rust extensions.
    comment by jankovicsandras · 2024-09-30 · in Ask HN: What are you working on (September 2024)?
  13. …might help, like combining vector similarity scores with e.g. BM25 scores. Shameless plug (FOSS): https://github.com/jankovicsandras/plpgsql_bm25 Okapi BM25 search implemented in PL/pgSQL for Postgres.
    comment by jankovicsandras · 2024-09-26 · in Show HN: Velvet – Store OpenAI requests in your own DB