Show HN: Code First CDC from Postgres to ClickHouse with MooseStack
3 days ago
- #Debezium
- #CDC
- #ClickHouse
- Easy-to-run demo of a CDC pipeline using Debezium (Kafka Connect), PostgreSQL, Redpanda, and ClickHouse.
- Docker + Docker Compose and Node.js 20+ with pnpm are required.
- Moose CLI is used to start the dev server, which manages ClickHouse, Redpanda, and CDC services.
- Setup script `setup-cdc.sh` initializes PostgreSQL schema, seeds data, and configures Debezium connector.
- Commands available for seeding and clearing data in tables.
- Drizzle Studio GUI allows viewing and editing PostgreSQL data to trigger CDC events.
- Project structure includes numbered folders for CDC flow: sources → transforms → destinations.
- Commands for app development, data management, and Kafka topic interaction.
- Debezium connector configuration details and troubleshooting tips provided.
- References to Debezium, Moose, Drizzle ORM, Redpanda, and ClickHouse documentation.