Our take
- Activity
- 88
- Community
- 88
- Issues
- 79
- Pull requests
- 78
+70 stars in the last 17 days
- Releases more often than 91% of the projects we track
- Merges more pull requests than 84% of the projects we track
- More contributors than 77% of the projects we track
Overview
ParadeDB extends PostgreSQL with indexing and query capabilities for full-text search, vector retrieval, and analytics. It aims to keep application data and search in one database, using SQL and PostgreSQL transactions rather than requiring a separate search engine.
It is a fit for teams building search or retrieval features on PostgreSQL and wanting filters, facets, joins, and aggregations alongside those queries. The project is implemented in Rust and integrates the pgrx, Tantivy, and Apache DataFusion libraries.
Key Features
- Full-text search with BM25 scoring, top-K queries, highlighting, and configurable tokenizers.
- Vector search and hybrid search combining text and vector retrieval.
- Filtering and joins against PostgreSQL data.
- Aggregations, including facets and metrics.
- Columnar storage for analytical query workloads.
- PostgreSQL extension architecture with SQL and ACID transactions.
Use Cases
- Application teams can add ranked full-text search to PostgreSQL-backed products without maintaining a separate search database.
- Developers building semantic retrieval can query vectors alongside existing relational data.
- Analytics teams can use search filters, facets, and aggregations over data already stored in PostgreSQL.
- Teams combining keyword and semantic retrieval can use hybrid search while keeping application queries in SQL.
Getting Started
Run the local Docker installation and open a psql session:
curl -fsSL https://paradedb.com/install.sh | sh
See the README and documentation for configuration and deployment details.
Alternatives
- pg_textsearch: pg_textsearch adds BM25-ranked full-text search to PostgreSQL, while ParadeDB combines search with vector retrieval and analytics.
| Project | Language | License | Stars | Status |
|---|---|---|---|---|
| paradedb | Rust | AGPL-3.0 | 9.3k | Not checked yet |
| pg_textsearch | C | PostgreSQL | 4k | Active |
Considerations
- ParadeDB is a PostgreSQL extension, so using it requires a PostgreSQL environment and compatibility with the extension's deployment requirements.
- The community edition uses the AGPL-3.0 license. The README notes that ParadeDB Enterprise is commercially licensed.
- The repository reports 239 open issues. Review current issues and project documentation when assessing suitability for a production workload.
Found this useful?
Share it with someone who would like paradedb.