All 85 Dependencies
Every package ParadeDB depends on, ranked by repo health score.
ParadeDB is an open source Postgres extension that brings Elasticsearch-quality full-text search and analytics directly inside your Postgres database. Instead of running a separate Elasticsearch or OpenSearch cluster alongside Postgres and syncing data between the two with an ETL pipeline, teams create a BM25 index on their existing tables and query it with SQL, keeping search results transactionally consistent with the underlying data. The project came out of Y Combinator's Summer 2023 batch and has since become a widely starred Postgres extension.
Under the hood, ParadeDB adds a custom Postgres index type -- the BM25 index -- built as an LSM tree of segments, where each segment pairs a Tantivy-backed inverted index for full-text search with a columnar store for fast analytical scans. New search operators like `|||` (match disjunction), `&&&` (match conjunction), `###` (phrase), and `##` (proximity) trigger a custom scan node that pushes filters, joins, and aggregates directly into the index instead of applying them in a separate execution phase. Functions like `pdb.score()` and `pdb.snippet()` provide BM25 relevance ranking and result highlighting, while `pdb.agg()` accepts Elasticsearch-compatible JSON aggregation queries executed against the columnar index through an embedded, forked Apache DataFusion engine for OLAP-style processing.
ParadeDB Community, the code in this repository, is licensed under AGPL-3.0 and supports the full BM25 search and analytics feature set on a single Postgres node with read replicas via logical replication. Official client integrations exist for Drizzle, Django, SQLAlchemy, Ruby on Rails, and Entity Framework Core, translating ParadeDB's SQL operators into each framework's native query builder syntax. A closed-source ParadeDB Enterprise tier adds high availability, physical read replica support for the BM25 index, and unlimited cluster size for teams that need it.
Development is unusually rigorous for an open source project of this kind: alongside standard unit and pg_regress tests, ParadeDB runs client-side integration tests with property-based query generation and an Antithesis deterministic-simulation-testing harness to catch rare concurrency bugs, plus a dedicated Stressgres tool for replaying production-like workloads under load.
