How Socialpruf built a faster, more reliable data stack by replacing Neon with Postgres managed by ClickHouse

Socialpruf, a Toronto-based platform, utilizes Postgres and ClickHouse Cloud to provide real-time social analytics for brands, talent agencies, and sports media companies. The platform aggregates performance data from social media platforms like Instagram, TikTok, YouTube, and X into dynamic dashboards and reports. Initially using Neon, a Databricks company, Socialpruf faced challenges with connectivity and escalating network transfer costs. Migrating to ClickHouse's managed Postgres service significantly improved query performance and stability, eliminating connectivity issues and reducing operational costs. This migration, aided by ClickHouse's team, allowed Socialpruf to efficiently handle large volumes of data and connections, leveraging PgBouncer for management. Socialpruf's infrastructure, combining OLTP and OLAP, enhances their product's user experience by providing near-instantaneous data processing and visualization, ensuring the company can focus on growth and innovation in the creator economy.