Show HN: Code First CDC from Postgres to ClickHouse with MooseStack

Re:Show HN: Code First CDC from Postgres to ClickHouse with ... by okane on Thursday October 16, 2025 @05:22PM (#45610825)

We wrote a guide + demo showing a code‑first path from Postgres to ClickHouse using Debezium and Redpanda, with MooseStack as the dx/glue layer.

This post targets teams who want code ownership: typed streams, stateless streaming transforms, and OLAP tables defined in code, with a local dev server to spin up ClickHouse + Redpanda + Debezium + Postgres in one command.

Blog is linked in the repo.

Right now the demo solely focuses on the local dev experience, looking for community input regarding best practices for running Debezium in production.

[ Parent | on HN ]

Re:Show HN: Code First CDC from Postgres to ClickHouse with ... by oatsandsugar on Thursday October 16, 2025 @05:39PM (#45611017)

I think my favorite part was the ability to use the same Drizzle TS data models created for Postgres for creating tables in ClickHouse

[ Parent | on HN ]