I’m actually in the same boat right now (primary DB -> Clickhouse). We’re curren... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		kossae on Feb 8, 2024 \| parent \| context \| favorite \| on: Transforming Postgres into a Fast OLAP Database I’m actually in the same boat right now (primary DB -> Clickhouse). We’re currently trialing Airbyte but it appears they’re removing normalization support for Clickhouse this year. Did you land on a custom solution, or some other ETL/ELT tool?

benjaminwootton on Feb 8, 2024 [–]

Have you tried the PostgreSQL table engine?

Or Debezium to Kafka for a more hand coded solution?

higeorge13 on Feb 11, 2024 | [–]

The materialized postgres is still experimental and has some backlog until being production ready.

Debezium -> kafka -> kafka engine -> MVs -> Replacing merge trees works like a charm for me.

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact