# Postgres Meets Analytics: CDC From Neon to ClickHouse Via PeerDB

DevFeed: [Postgres Meets Analytics: CDC From Neon to ClickHouse Via PeerDB](<https://devfeed.tech/articles/postgres-meets-analytics-cdc-from-neon-to-clickhouse-via-peerdb-5735.md>)

Original publisher: [Read original article](<https://neon.com/blog/postgres-meets-analytics-cdc-from-neon-to-clickhouse-via-peerdb>)

Author: Sai Srirampur

Published: 2024-10-02T16:39:48Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [data](<https://devfeed.tech/topics/data.md>), [autoscaling](<https://devfeed.tech/topics/autoscaling.md>), [web applications](<https://devfeed.tech/topics/web-applications.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [autoscaling](<https://devfeed.tech/tags/autoscaling.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [code](<https://devfeed.tech/tags/code.md>), [community](<https://devfeed.tech/tags/community.md>), [data](<https://devfeed.tech/tags/data.md>), [databases](<https://devfeed.tech/tags/databases.md>), [latency](<https://devfeed.tech/tags/latency.md>), [low-latency](<https://devfeed.tech/tags/low-latency.md>), [olap](<https://devfeed.tech/tags/olap.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [replication](<https://devfeed.tech/tags/replication.md>), [warehouse](<https://devfeed.tech/tags/warehouse.md>), [web-applications](<https://devfeed.tech/tags/web-applications.md>)

## AI overview

This article explains how Neon serverless Postgres and ClickHouse can be combined for transactional workloads and real-time analytics. It presents PeerDB's Change Data Capture and replication capabilities as the bridge for synchronizing Neon data to ClickHouse for customer-facing analytics and data warehousing.

## Source excerpt

If you're building a data-driven application that handles large amounts of data, you may need to balance two different types of databases: a purpose-built operational DB for your transactions, and an analytical database for large-scale data analysis. A purpose-built analytical da...