Pg_bm25: Elastic-Quality Full Text Search Inside Postgres

• paradedb

  16 3,803 9.8 Rust

  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

  13 3,221 9.5 Rust

  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

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• MeiliSearch

  129 43,284 9.8 Rust

  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

  48 9,896 9.1 Rust

  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

Suggest a related project