CDC on AWS with PostgreSQL, Debezium, Kafka and ClickHouse

Intro Your analytics team wants fresh numbers, and your PostgreSQL database is not built for them. You can run heavy queries on production and slow down the app. Or you can copy the data once a night and work with yesterday’s numbers. Or maybe you want to squeeze the data in real time (incrementaly) from production system and in parallel build new one. Let’s say if client reached all the limits of vertical scaling. ...

November 14, 2026 · 11 min · 2214 words · Me

DuckDB Inside Postgres: The Unlikely Duo Supercharging Analytics

DuckDB Inside Postgres: The Unlikely Duo Supercharging Analytics If you work in data engineering, you know that the field moves at a dizzying pace. New tools and technologies seem to pop up daily, each promising to revolutionize how we store, process, and analyze data. Amidst this constant change, two names have remained stalwarts: Postgres, the tried-and-true relational database, and DuckDB, the talented new kid on the block for analytics workloads. ...

October 30, 2024 · 9 min · 1837 words · Me