3 ms·
What would be the best Postgres + CH setup to combine both? somethign using CDC and apply them to CH?
by oulipo 1y ago
What would be the best Postgres + CH setup to combine both? somethign using CDC and apply them to CH?
- saisrirampur 1y agoGreat question, exactly CDC from Postgres to ClickHouse and adapting the application to start using ClickHouse for analytics. Through the PeerDB acquisition, ClickHouse now has native CDC capabilities that work at any scale (few 10s of GB to 10s of TB Postgres databases). You can use ClickPipes if you’re on ClickHouse Cloud, or PeerDB if you’re using ClickHouse OSS. Sharing a few links for reference: https://clickhouse.com/docs/integrations/clickpipes/postgres https://clickhouse.com/docs/integrations/clickpipes/postgres https://github.com/PeerDB-io/peerdb https://github.com/PeerDB-io/peerdb https://clickhouse.com/cloud/clickpipes/postgres-cdc-connector https://clickhouse.com/cloud/clickpipes/postgres-cdc-connect... https://clickhouse.com/blog/clickhouse-acquires-peerdb-to-boost-real-time-analytics-with-postgres-cdc-integration https://clickhouse.com/blog/clickhouse-acquires-peerdb-to-bo... Here is a short demo/talk that we did at our annual conferemce Open House that talks about this reference architecture https://clickhouse.com/videos/postgres-and-clickhouse-the-default-data-stack https://clickhouse.com/videos/postgres-and-clickhouse-the-de...