Pg_bm25: Elastic-Quality Full Text Search Inside Postgres

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • paradedb

    Postgres for Search and Analytics

    Looking at benchmarks, they are incorrect, leading to a false statement that native full-text search indexes Postgres has (usually GIN indexes on tsvector columns) are slow.

    https://github.com/paradedb/paradedb/blob/bb4f2890942b85be3e... – the here tsvector is build. But this is not an index. You need CREATE INDEX ... USING gin(search_vector);

    This mistake could be avoided if bencharks included query plans collected with EXPLAIN (ANALYZE, BUFFERS).

  • pgrx

    Build Postgres Extensions with Rust!

    pgrx is one of the greatest enabling innovations in the PG ecosystem in a long time.

    Awesome to see so many high quality extensions come out of it.

    https://github.com/pgcentralfoundation/pgrx

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • MeiliSearch

    A lightning-fast search API that fits effortlessly into your apps, websites, and workflow

    Meilisearch seems like it is the best open source option.

    https://www.meilisearch.com/

  • tantivy

    Tantivy is a full-text search engine library inspired by Apache Lucene and written in Rust

    The issue for geo search is here: https://github.com/quickwit-oss/tantivy/issues/44

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts