.png)
Frigade recently launched Trench!
Founded by Eric Brownrout & Christian Mathiesen
Hey everyone! Meet Christian and Eric from Frigade. Trench is open source analytics infrastructure for tracking events, identifying users, and querying data in real time.
It’s built on top of ClickHouse and Kafka for speed and scale, and it can be deployed with a single production-ready Docker image. Trench is a major part of Frigade’s infrastructure and powers their own in-product analytics and user targeting for millions of end users.
The code is MIT-licensed at https://github.com/frigadehq/trench. They just launched, and Trench gained over 1,000 GitHub stars ⭐ in less than a week.
Check out the open source demo to see how to build your own version of a Google Analytics dashboard powered by Trench in less than 15 minutes.
As the founders scaled Frigade to millions of end users, the Postgres table they used for event tracking was quickly ballooning in cost and becoming a performance bottleneck. Many companies run into the same problem (e.g. Stripe, Heroku).
Engineers start by adding a basic events table to their relational database, which works at first, but breaks down as the user base scales. It's usually the biggest table in the database, the slowest one to query, and the longest one to back up. Postgres (or MySQL for that matter) simply isn't a good solution for tracking and querying events in real time at 1M+ end users scale.
The founders knew they wanted to move to technologies like Kafka and ClickHouse that are purpose-built for ingesting and querying thousands of events per second. When they looked for existing solutions, all the existing OSS projects found were either bloated with unnecessary features, UIs and spaghetti code, or simply antiquated. So Trench was built.
With Trench, the founders put together a single Docker image that provides a production-ready tracking event table that scales. When they migrated their tracking table from Postgres to Trench, they saw a 42% reduction in cost to serve on their primary Postgres cluster and eliminated all lag spikes from auto-scaling under high traffic. The founders are happy with how Trench has solved event tracking for them, and now they’re excited to share that with other teams.
What can you build with Trench? There are many use cases:
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.
Built for Delaware C-Corps. Trusted by 1,000+ startups.
Copyright © Fondo (BloomJoy, Inc.)
