Show HN: Trench – Open-source analytics infrastructure

📰 Hacker News · pancomplex

Hey HN! I want to share a new open source project I've been working on called Trench ( https://trench.dev ). It's open source analytics infrastructure for tracking events, page views, and identifying users, and it's built on top of ClickHouse and Kafka. https://github.com/frigadehq/trench I built Trench because the Postgres table we used for tracking events at our startup ( http://frigade.com/ ) was getting expensive and becoming a performance bottleneck as we scaled to millions of end users. Many companies run into the same problem as us (e.g. Stripe, Heroku: https://brandur.org/fragments/events ). They often start by adding a basic events table to their relational database, which works at first, but can become an issue as the application scales. It’s usually the biggest table in the database, the slowest one to query, and the longest one to back up. With Trench, we’ve put together a single Docker image th

Published 25 Oct 2024
Read full article → ← Back to Reads