Supabase Partnership: Native Postgres Replication to ClickHouse, clickhouse_fdw and more
Over the past few years, a common reference architecture is emerging: customers are using Postgres and ClickHouse together to address most of their data challenges.
On the one hand, you have Postgres, the most popular open source transactional database, which is well-suited to store and query application data, supporting mission-critical transactional and web-app use cases. On the other hand, you have ClickHouse, the most popular open source analytical database, which is well-suited for supporting all analytics and reporting use cases, powering both customer-facing and internal applications. Both of them share the same ethos of open source. These reasons make Postgres and ClickHouse a compelling duo for solving a wide range of data challenges for customers thereby making them the “default data stack”.
At ClickHouse, we have been committed to making it easy for customers to implement this architecture—using Postgres and ClickHouse together. One of our recent steps in this direction is the acquisition of PeerDB, a leading Postgres CDC provider. This enables seamless replication of transactional data from Postgres to ClickHouse, powering real-time analytics and data warehousing use cases.
