Trench – Open-source analytics infrastructure

In plain words

Trench is an open-source analytics infrastructure built on ClickHouse and Kafka for tracking events, page views, and identifying users. It's designed for developers building applications that need to handle event tracking at scale. The tool addresses the performance and cost problems that arise when event data outgrows traditional relational databases like Postgres, offering a more efficient alternative for companies processing millions of events.

written from the facts on this page · September 2026

From the sources

Trench — Open-Source Analytics Infrastructure. A single production-ready Docker image built on ClickHouse, Kafka, and Node.js for tracking events. Easily build product analytics dashboards, LLM RAGs, observability platforms, or any other analytics product. - FrigadeHQ/trench

Our team built Trench to scale up the real-time event tracking pipeline at Frigade . ⭐ Features 🤝 Compliant with the Segment API (Track, Group, Identify) 🐳 Deploy quickly with a single production-ready Docker image 💻 Process thousands of events per second on a single node ⚡ Query data in real-time 🔗 Connect data to other destinations with webhooks 👥 Open-source and MIT Licensed 🖥️ Demo Live demo: https://demo.trench.dev Watch the following demo to see how you can build a basic version of Google Analytics using Trench andfrom github.com

In the maker’s words, at launch

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…

• 
  Trench2024 · trench.dev · ▲281

  Open source analytics infrastructure

• 
  66Analytics2020 · 66analytics.com · ▲260

  Self-hosted analytics with session replays, heatmaps & more.

• 
  Open AnalyticsAug 2026 · getopen.so · ▲253

  Open Analytics is a privacy-first Google Analytics alternative: realtime visitors, funnels and revenue attribution from one lightweight, cookieless script. GDPR-friendly with no consent banner. Open source and self-hostable.

• 
  Serverless Analytics Built from Scratch2018 · statsbotco.github.io · ▲114
• 
  Distributed Tracing Using OpenTelemetry and ClickHouse2021 · github.com · ▲105

  Open source APM: OpenTelemetry traces, metrics, and logs - uptrace/uptrace

• 
  DataPulse Open Beta2023 · datapulse.app · ▲142

  Simple, real-time, fun & lightweight web analytics solution

• 
  /dev/null▲472

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲340

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 27d ago · corespeed.io

• 
  buzzabout▲1,267

  Audience insights from 1B+ online discussions in 2 mins

  AI · 2024 · buzzabout.ai

• 
  bolt.new▲1,230

  Build and scale high-performing websites & apps using your words. Join millions and start building today.

  AI · 2024 · bolt.new

• 
  Feta▲1,217

  Run smarter stand-ups, build better products

  AI · 2024 · feta.io

• 
  Trag▲955

  AI code review companion

  AI · 2024 · usetrag.com

• 
  Softr for Notion▲923

  Turn Notion databases into portals & apps with no code

  Dev tools · 2024 · softr.io

• 
  General Collaboration▲910

  One inbox for all your work discussions

  Work · 2024 · generalcollaboration.com