SocialprufがNeonをClickHouse管理のPostgresに置き換えて、より高速で信頼性の高いデータスタックを構築した方法

Socialpruf leverages a fully managed solution using Postgres and ClickHouse on ClickHouse Cloud to offer real-time social analytics for brands, talent agencies, and sports media companies. Originally operating on Databricks' Neon, Socialpruf faced challenges with network transfer costs and connection stability, prompting a transition to ClickHouse Cloud that enhanced Postgres query performance by up to five times while eliminating connection issues. The platform aggregates performance data from social media platforms like Instagram, TikTok, YouTube, and X, providing real-time dashboards and campaign trackers. The transition to ClickHouse allowed Socialpruf to handle millions of rows in milliseconds, significantly improving the user experience and maintaining the product's value proposition. The switch to ClickHouse's managed Postgres services also addressed stability and cost concerns, offering a seamless analytics experience by integrating both OLTP and OLAP functions on a single platform. The migration process, supported by the ClickHouse team, utilized PeerDB for reliable data transfer. Socialpruf now manages thousands of concurrent database connections using PgBouncer, facilitating efficient real-time analytics while maintaining a robust transactional foundation.