ANAnhTho_FR·Jan 30, 2024Submission
1 points · Open discussiondittofeed
clickhouse-segments-tutorial
TypeScript2024–2024
dittofeed / clickhouse-segments-tutorial
clickhouse-segments-tutorial
Repository demonstrating how to calculate user segments in Clickhouse.
2Distinct people
2Mentions
0Explicit recommenders
14GitHub stars
What to know before exploring
What it is
Repository demonstrating how to calculate user segments in Clickhouse.
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 1:49:46 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by hour2 dated mentions
Observed mentions: 2024-01-29 19:16:29 UTC to 2024-01-30 09:33:17 UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| Jan 29, 19:00 | 2024-01-29 19:00:00 UTC | 2024-01-29 20:00:00 UTC | 1 | 0 | 1 |
| Jan 29, 20:00 | 2024-01-29 20:00:00 UTC | 2024-01-29 21:00:00 UTC | 0 | 0 | 0 |
| Jan 29, 21:00 | 2024-01-29 21:00:00 UTC | 2024-01-29 22:00:00 UTC | 0 | 0 | 0 |
| Jan 29, 22:00 | 2024-01-29 22:00:00 UTC | 2024-01-29 23:00:00 UTC | 0 | 0 | 0 |
| Jan 29, 23:00 | 2024-01-29 23:00:00 UTC | 2024-01-30 00:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 00:00 | 2024-01-30 00:00:00 UTC | 2024-01-30 01:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 01:00 | 2024-01-30 01:00:00 UTC | 2024-01-30 02:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 02:00 | 2024-01-30 02:00:00 UTC | 2024-01-30 03:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 03:00 | 2024-01-30 03:00:00 UTC | 2024-01-30 04:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 04:00 | 2024-01-30 04:00:00 UTC | 2024-01-30 05:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 05:00 | 2024-01-30 05:00:00 UTC | 2024-01-30 06:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 06:00 | 2024-01-30 06:00:00 UTC | 2024-01-30 07:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 07:00 | 2024-01-30 07:00:00 UTC | 2024-01-30 08:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 08:00 | 2024-01-30 08:00:00 UTC | 2024-01-30 09:00:00 UTC | 0 | 0 | 0 |
| Jan 30, 09:00 | 2024-01-30 09:00:00 UTC | 2024-01-30 10:00:00 UTC | 1 | 1 | 0 |
What Hacker News says
2 sourcesI just wanted to share a piece I recently wrote on Dev.to about some of the work we've been doing at Dittofeed. Dittofeed is an open-source alternative to platforms like customer.io, Klaviyo, and Braze.
If you're interested in how to segment users by processing semi-structured event logs at scale, keep reading!
Article: https://dev.to/dittofeed-max/how-we-stopped-our-clickhouse-d...
Dittofeed's primary repo: https://github.com/dittofeed/dittofeed
This article includes code samples, as well as a link to a git repo you can use to run tests and follow along. These code samples demonstrate a simplified user segmentation setup in ClickHouse.
Accompanying repo for the article: https://github.com/dittofeed/clickhouse-segments-tutorial
User segmentation is key to understanding your business or application’s users’ behaviors. For example, you migh
Read the rest
t want to keep track of which users have gotten stuck in an onboarding flow or which users haven’t logged in within the last 30 days.
Here's a quick rundown of what I covered:
Diving into ClickHouse: Why we (and you) should use ClickHouse for your analytical workloads, and user segmentation in particular.
On User Segmentation: What are user segments, and how do we calculate them. We cover some basic pseudocode.
Tackling Idempotency: To avoid duplicate data messing up our calculations, we've made sure our setup is idempotent.
Scaling with Micro-Batching: Simulate stream processing by incrementally aggregating user events in small batches. This is really the core of the article!
"Event Time" vs. "Processing Time": When did an event happen and what are the different ways we can measure time? How do we accommodate different measures of time in our application?
I'd really love it if you could take a moment to check out the article and maybe even drop a star on the Dittofeed GitHub repo. Your support and feedback would mean a lot!
Catch you all soon!