Code-first CDC from Postgres to ClickHouse is getting a real-world nudge from Show HN: Code First CDC from Postgres to ClickHouse with MooseStack, using Debezium and Redpanda to wire up the stack. The local-dev demo spins up ClickHouse, Redpanda, Debezium, and Postgres in one command.
Production questions are front and center: the author is seeking input on best practices for running Debezium in production beyond the cozy local-dev setup.
One cool bit: the same Drizzle TS data models created for Postgres can be used to create tables in ClickHouse.
Beyond the MooseStack demo, a separate piece highlights ClickHouse with HDFS for patent analytics, showing end-to-end OLTP-to-OLAP pipelines.
Bottom line: code-first CDC is finding a foothold in real deployments, and the community is shaping best practices as they go.