ZomboDB: Seamless Integration of Postgres and Elasticsearch
ZomboDB is a native Postgres extension that leverages Elasticsearch as an indexing engine to deliver powerful text search and analytics capabilities. Written in Rust, it ensures transactionally-safe query results while allowing users to utilize standard SQL for managing and querying data, significantly simplifying the integration between Postgres and Elasticsearch.
Features
Native Postgres extension with full compatibility for SQL commands
MVCC-correct text search and aggregation results
Automatic Elasticsearch mapping generation with customizable options
Supports complex queries using ZQL, raw QueryDSL JSON, and SQL combinations
Seamless communication with both self-managed and cloud Elasticsearch instances
No need for asynchronous indexing pipelines or complex data access paths