How Vibe.co handles billions of ad impressions with ClickHouse Cloud

Vibe.co, now a part of Walmart, harnesses ClickHouse Cloud to deliver real-time campaign reporting for Connected TV advertisers, transitioning from Postgres due to its limitations with handling massive data volumes and complex OLAP workloads. The migration allowed Vibe.co to scale its data from approximately 100 GB to over 2 TB, maintaining performance and flexibility without significant architectural changes, with over 90% of client reports being served in under 100ms. The decision to choose ClickHouse Cloud over self-hosted solutions was driven by operational simplicity, predictable pricing, and strong team support, aligning with Vibe's philosophy of minimizing complexity for enhanced trust and scalability. Rémi Paulin, a Staff Data Engineer at Vibe, emphasizes the importance of simplicity in architecture, reliability, and the flexibility that allows internal teams to innovate without constantly redesigning data pipelines, highlighting the strategic advantage of having a SQL-centric database for both human and AI-driven analytics. This approach not only ensures high performance and trust among clients but also supports future growth and adaptation within the fast-evolving data infrastructure landscape.