Amazon Redshift
Fully managed, petabyte-scale cloud data warehouse for analytics and reporting
Open-Source Projects
Discover top open-source software, updated regularly with real-world adoption signals.
Discover top open-source software, updated regularly with real-world adoption signals.
Postgres-compatible analytical database with built-in data sync connectors
BemiDB combines data ingestion and analytical querying in one Docker image. Sync from Postgres, Amplitude, or Attio, store compressed columnar data in S3, and query 2000x faster than regular Postgres.
BemiDB is an analytical database that bundles data ingestion and query capabilities into a single deployment. It connects to operational databases and SaaS platforms, syncs data to S3-compatible object storage in compressed columnar format, and exposes a Postgres-compatible query interface for analytics.
Engineering teams who need to centralize data from multiple sources without managing separate ETL pipelines and data warehouses. The Postgres wire protocol compatibility means existing BI tools, notebooks, and ORMs work without modification.
BemiDB ships with built-in connectors for Postgres, Amplitude, and Attio. Data is stored using an open table format with 4x compression and separated from compute. The analytical query engine delivers performance improvements over transactional databases for complex queries. All components run as stateless processes in a single Docker image, simplifying deployment and horizontal scaling.
Requires a Postgres database for catalog metadata and S3-compatible object storage (AWS S3, MinIO, etc.). Syncer processes pull data from sources on-demand, while the server process handles query execution. Both run independently and can be scaled separately.
When teams consider BemiDB, these hosted platforms usually appear on the same shortlist.
Looking for a hosted option? These are the services engineering teams benchmark against before choosing open source.
Centralized analytics without ETL complexity
Query data from multiple Postgres databases and SaaS platforms through a single endpoint without building custom pipelines
Historical data archival and analysis
Offload old records from production databases to compressed S3 storage while maintaining query access for compliance and reporting
BI tool integration with analytical performance
Connect existing Postgres-compatible dashboards and notebooks to run complex aggregations without impacting production databases
Cost-optimized data warehousing
Store large datasets in S3 with 4x compression and scale query compute independently based on workload demands
BemiDB currently includes built-in connectors for Postgres databases, Amplitude analytics, and Attio CRM. The Postgres connector supports table-level inclusion and exclusion filters.
BemiDB uses an analytical query engine optimized for columnar data stored in S3, separating storage from compute. This architecture is designed for read-heavy analytical workloads rather than transactional operations.
You need a Postgres database for catalog metadata, S3-compatible object storage (AWS S3, MinIO, etc.), and container runtime for Docker. Syncer and server processes run as separate stateless containers.
Yes. BemiDB exposes a Postgres-compatible wire protocol, so any tool or library that connects to Postgres can query BemiDB without modification.
BemiDB stores data in an open columnar table format in S3 with 4x compression. The catalog Postgres database tracks metadata while actual data resides in object storage.
Project at a glance
ActiveLast synced 4 days ago
