Show HN: Code First CDC from Postgres to ClickHouse with MooseStack
1–7 of 7 posts
Re: Show HN: Code First CDC from Postgres to ClickHouse with MooseStack
#2We 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.
Re: Show HN: Code First CDC from Postgres to ClickHouse with MooseStack
#3We 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 sole…
I think my favorite part was the ability to use the same Drizzle TS data models created for Postgres for creating tables in ClickHouse
Re: Show HN: Code First CDC from Postgres to ClickHouse with MooseStack
#4Super cool everything is better in code! :-)
Re: Show HN: Code First CDC from Postgres to ClickHouse with MooseStack
#5Very nice. Is this only possible with postgres or might be possible with sqlite or some sqlite variant?
Re: Show HN: Code First CDC from Postgres to ClickHouse with MooseStack
#6Very nice. Is this only possible with postgres or might be possible with sqlite or some sqlite variant?
Co-author here, we used Debezium here because it supports many different databases. Unfortunately, no sqlite support—my understanding is as an embedded db it lacks some of the prerequisites that Debezium relies on.
Have you run CDC from sqlite? would love to hear how you did it and to try build a demo with MooseStack
Re: Show HN: Code First CDC from Postgres to ClickHouse with MooseStack
#7Very nice. Is this only possible with postgres or might be possible with sqlite or some sqlite variant?
Co-author here, we used Debezium here because it supports many different databases. Unfortunately, no sqlite support—my understanding is as an embedded db it lacks some of the prerequisites that Debezium relies on. Have you run CDC from sqlite? would love to hear how you did it and to try build a demo with MooseStack
Hello, thank you for your answer. No I never ran CDC from sqlite, I am actually just investing sqlite, thus my question.