The Data Stack Show The PRQL: Data Migration Made Easy: Postgres, ClickHouse, and the Future of Analytics with Aaron Katz and Sai Krishna Srirampur
May 19, 2025
Discover the innovations of ClickHouse in data migration and analytics. The discussion highlights the challenges and advantages of transitioning from Postgres to ClickHouse Cloud. Explore the evolving landscape of database technologies as the speakers analyze the integration of systems like Postgres and ClickHouse. They address the necessity for specialized databases in managing diverse business applications effectively.
AI Snips
Chapters
Transcript
Episode notes
ClickHouse's Startup Journey
- Aaron Katz shared ClickHouse's journey from an open source database to a well-capitalized startup with over 1,000 customers.
- Their managed ClickHouse Cloud offers low latency analytics and includes customers like Roblox and Sony.
PeerDB's Postgres Data Streaming
- Sai Krishna described founding PeerDB, a data replication tool focused on moving data from Postgres to warehouses including ClickHouse.
- After acquisition by ClickHouse, PeerDB's integration enables one-click streaming of Postgres data into ClickHouse Cloud.
Database Convergence Trend
- Aaron Katz noted that transactional, analytical, relational, and vector databases are converging towards simpler infrastructure.
- Customers want one or two databases to satisfy diverse needs rather than many specialized ones.