Frustratingly simple data movement for Postgres
We are building a fast, simple and the most cost effective way to stream data from Postgres to Data Warehouses, Queues and Storage engines. If you are running Postgres at the heart of your data-stack and move data at scale from Postgres to any of the above targets, PeerDB can help.
Backed by
Combinator
CREATE PEER postgres_peer
FROM postgres (...);
postgres connection validated and created peer
CREATE PEER snowflake_peer
FROM snowflake (...);
snowflake connection validated and created peer
CREATE MIRROR real_time_cdc
FROM postgres_peer
TO snowflake_peer
WITH TABLE MAPPING (transactions:transactions, users:users);
transactions and users table replicated in realtime from postgres to snowflake.
Total time: 2 sec
FROM postgres (...);
postgres connection validated and created peer
CREATE PEER snowflake_peer
FROM snowflake (...);
snowflake connection validated and created peer
CREATE MIRROR real_time_cdc
FROM postgres_peer
TO snowflake_peer
WITH TABLE MAPPING (transactions:transactions, users:users);
transactions and users table replicated in realtime from postgres to snowflake.
Total time: 2 sec
Benchmarks
PeerDB · 4.5 min
AirByte · 34 min
Fivetran · Not supported
PeerDB · 30 sec
AirByte · +1 hrs
Fivetran · 5 min
PeerDB · 4 min
AirByte · 28 min
Fivetran · Not supported
PeerDB · 33 sec
AirByte · +1 hrs
Fivetran · 5 min
Real-time CDC
from PostgreSQL
Data-freshness guarantees of less than 30s on target. Supports native features such as rich data types incl. PostGIS, JSONB, streaming partitioned tables, TOAST Columns and so on.
Real-time Streaming
of Query Results
Streaming ~100 million rows in 4.5 minutes.
Integrations
Get data in and out of Postgres from multiple connectors
Offerings
check
Real-time CDC – Postgres to Kafka, Azure Event Hubs, Postgres, Snowflake and BigQuery
check
Blazing fast initial load.
check
Streaming Query – Postgres to Snowflake, BigQuery, S3 and Postgres; SQL Server to Postgres
check
Query Layer – Snowflake, BigQuery and PostgreSQL.
check
Docker container to setup and install PeerDB
Everything in "PeerDB Open Source" plus...
check
Fully managed and hosted on AWS and GCP.
check
1-click provisioning
check
Advance metrics and monitoring dashboards
check
In-place online upgrades
check
Scale up and down
check
Out of the box Auth
check
IP Whitelisting and VPC Peering
Everything in "PeerDB Open Source", plus...
check
Advance metrics and monitoring
check
Kubernetes Helm Chart
check
White-glove Implementation Support
check
24x7 support with enterprise-grade SLAs