BemiDB

BemiDB is a Postgres read replica optimized for analytics. It consists of a single binary that seamlessly connects to a Postgres database, replicates the data in a compressed columnar format, and allows you to run complex queries using its Postgres-compatible analytical query engine.

Highlights

• Performance: runs analytical queries up to 2000x faster than Postgres.
• Single Binary: consists of a single binary that can be run on any machine.
• Postgres Replication: automatically syncs data from Postgres databases.
• Compressed Data: uses an open columnar format for tables with 4x compression.
• Scalable Storage: storage is separated from compute and can natively work on S3.
• Query Engine: embeds a query engine optimized for analytical workloads.
• Postgres-Compatible: integrates with any services and tools in the Postgres ecosystem.
• Open-Source: released under an OSI-approved license.

Use cases

• Run complex analytical queries like it's your Postgres database. Without worrying about performance impact and indexing.
• Simplify your data stack down to a single binary. No complex setup, no data movement, no CDC, no ETL, no DW.
• Integrate with Postgres-compatible tools and services. Query and visualize data with BI tools, notebooks, and ORMs.
• Have all data automatically synced into your data lakehouse. Using Iceberg tables with Parquet data on object storage.