/plushcap/analysis/clickhouse/clickhouse-supabase-partnership-native-postgres-replication-clickhouse-fdw

Supabase Partnership: Native Postgres Replication to ClickHouse, clickhouse_fdw and more

What's this blog post about?

The text discusses a common reference architecture where customers use Postgres and ClickHouse together to address most of their data challenges. Postgres is an open source transactional database, while ClickHouse is an open source analytical database. Both are well-suited for different types of applications. The author mentions the acquisition of PeerDB by ClickHouse, which enables seamless replication of transactional data from Postgres to ClickHouse. Furthermore, a partnership with Supabase, a leading managed service provider for Postgres, is announced. This partnership aims to enable customers to integrate Supabase and ClickHouse more easily, helping them build out their data stack and drastically reduce time-to-market for different applications. The text also discusses the integration of PeerDB into ClickPipes, a native ingestion service of ClickHouse, which will power the Postgres CDC connector in ClickPipes. Lastly, it mentions the support for IPV6 in PeerDB Cloud and clickhouse_fdw extension provided by Supabase to start querying data in ClickHouse from within Postgres.

Company
ClickHouse

Date published
Oct. 30, 2024

Author(s)
Sai Srirampur

Word count
1186

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.