Frigade has open-sourced its internal analytics system, Trench, designed for tracking events, page views, and user identification, utilizing ClickHouse and Kafka for its backend. Initially, Frigade used a basic Postgres table for event tracking, but as their user base grew, this setup became inefficient and costly, prompting the development of Trench to handle high-volume event tracking and real-time querying. Trench is a production-ready solution that supports Segment API calls, quick deployment with a single Docker image, high throughput, real-time querying, and data connections through throttled webhooks, all while being open-source and MIT licensed for unrestricted use. This scalable system is suitable for both startups and large-scale operations, offering a streamlined approach to managing millions of events efficiently.