ParadeDB is Postgres for Search

ParadeDB is a Postgres-based ElasticSearch alternative, engineered for lightning-fast full text, similarity, and hybrid search.

"...Say goodbye to gluing ElasticSearch and other services on top of Postgres. ParadeDB offers the most comprehensive, Postgres-native search features of any Postgres database..."

They released a Rust-based Postgres new extension for fast search that significantly improves Postgres’ full text search capabilities. They claim that:

• Query times over 1M rows are 20x faster compared to tsquery and ts_rank, Postgres’ built-in full text search and sort functions

• Support for fuzzy search, aggregations, highlighting, and relevance tuning

• Relevance scoring uses BM25, the same algorithm used by ElasticSearch

Sample code:

SELECT * 
FROM my_table 
WHERE my_table @@@ 'description:keyboard^2 OR electronics:::fuzzy_fields=description&distance=2'

Currently, the DB is still in the "waiting List' mode.