ZomboDB
A Postgres extension that integrates Elasticsearch as a native index type for powerful text-search and analytics directly from SQL.
What is ZomboDB?
ZomboDB is a native PostgreSQL extension that integrates Elasticsearch's full-text search and analytics capabilities directly into the database. It enables developers to perform complex text searches, aggregations, and filtering on relational data using SQL while maintaining transactional correctness and compatibility with PostgreSQL's MVCC model. This eliminates the need to manage separate search and database systems, providing a unified approach to querying.
Database administrators and backend developers working with PostgreSQL who need advanced full-text search, analytics, and scalable text indexing beyond PostgreSQL's built-in capabilities. It is particularly suited for teams managing large datasets with extensive text content who want to leverage Elasticsearch's features without complex data synchronization pipelines.
Developers choose ZomboDB because it seamlessly integrates Elasticsearch as a native PostgreSQL index type, ensuring transactionally accurate search results and full SQL compatibility without requiring separate data management or asynchronous indexing processes. Its unique selling point is the ability to query Elasticsearch directly from PostgreSQL using a combination of ZQL, Elasticsearch QueryDSL, and standard SQL, all while handling indexing and synchronization automatically.
Overview
Making Postgres and Elasticsearch work together like it's 2023
Use Cases
Best For
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
