A PostgreSQL extension that brings Elastic-quality full-text search and analytics directly inside Postgres.
ParadeDB is a PostgreSQL extension that provides Elastic-quality full-text search and analytics capabilities directly within the database. It eliminates the need for separate search infrastructure by integrating battle-tested Rust libraries into Postgres, offering a unified solution for data storage and retrieval.
Developers and teams using PostgreSQL who need advanced full-text search and analytical capabilities without maintaining a separate system like Elasticsearch. This includes backend engineers, data engineers, and full-stack developers building applications with complex search and data analysis requirements.
Developers choose ParadeDB because it integrates high-performance search and analytics directly into PostgreSQL, leveraging Rust libraries like Tantivy and Apache DataFusion for optimized performance. This eliminates the complexity and overhead of managing separate search infrastructure while maintaining compatibility with existing PostgreSQL workflows and tools.
Simple, Elastic-quality search for Postgres
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Implements BM25 scoring, highlighting, and configurable tokenizers using Tantivy, providing search capabilities comparable to Elasticsearch directly in Postgres.
Supports columnar storage, bucket metrics, and faceted aggregations via Apache DataFusion, enabling complex data analysis without external systems.
Works as a native extension, allowing filtering and JOINs within search queries while maintaining compatibility with existing PostgreSQL workflows and ORMs like Django and SQLAlchemy.
Leverages battle-tested Rust libraries like Tantivy and DataFusion for optimized search and OLAP processing, as highlighted in the architecture docs.
Vector search and hybrid search are listed as 'coming soon' in the README, making it unsuitable for applications requiring these capabilities immediately.
Compared to established solutions like Elasticsearch, ParadeDB has a smaller community and fewer integrations, which could affect tooling and support availability.
The AGPL v3.0 license may pose challenges for proprietary or closed-source applications, as it requires sharing modifications, and enterprise licensing is separate.
pg_analytics is an open-source alternative to the following products: