7 ms·
yeah i have this setup. pain point is syncing between them, still haven't figured out a good pattern. just running a cron overnight which feels dumb but works
by dmarwicke 9mo ago
yeah i have this setup. pain point is syncing between them, still haven't figured out a good pattern. just running a cron overnight which feels dumb but works
- saisrirampur 9mo agoYou should try PeerDB, it was acquired by ClickHouse for exactly this use-case - Fast, simple Postgres replication to ClickHouse. https://github.com/PeerDB-io/peerdb https://github.com/PeerDB-io/peerdb In ClickHouse Cloud, you have ClickPipes which is a simpler/managed manifesation of PeerDB https://clickhouse.com/cloud/clickpipes/postgres-cdc-connector https://clickhouse.com/cloud/clickpipes/postgres-cdc-connect...