3 ms·
Congrats on launching – we just spent quite a bit of time replicating/transforming our primary database into clickhouse for OLAP use cases, and it would have be
by yunyu 3y ago
Congrats on launching – we just spent quite a bit of time replicating/transforming our primary database into clickhouse for OLAP use cases, and it would have been way easier if there were a postgres-native solution. Hoping the managed hosting providers catch on
- kossae 3y agoI’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 3y agoHave you tried the PostgreSQL table engine? Or Debezium to Kafka for a more hand coded solution?
- higeorge13 3y agoThe 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.