Optimizing Web Analytics with ClickHouse

Scott and Wes dive into Cloudflare’s Analytics Engine and Workers with special guest Ben Vinegar, Syntax’s General Manager. Tune in as they explore Clickhouse, data tracking, infrastructure costs, and transitioning from software products to managing a podcast.

• 00:00 Welcome to Syntax!
• 01:17 Who is Ben Vinegar?
• Episode 434 with Ben.
• 02:21 Brought to you by Sentry.io.
• 04:00 Cloudflare analytics engine.
• Counterscale.dev.
• Episode 634 with Armin.
• 09:08 What is clickhouse?
• 11:01 Can Clickhouse be used for things outside of analytics tracking?
• 13:46 What kind of events are you able to track?
• 15:00 How do you assign values to track?
• Counterscale Schema.
• 18:40 Data type limitations.
• 19:55 The troubles with sampling data.
• 23:57 Sample intervals.
• 24:24 Pricing for these services.
• 25:34 How it actually runs.
• 27:31 Infrastructure costs and pricing models.
• 30:19 Running production apps in Cloudflare.
• 31:49 Cloudflare and HonoJS.
• 32:47 One year with Sentry and Ben’s role with Syntax.
• Episode 600 with David.
• 39:33 How does it feel going from a software project to a media project?
• Syntax Team.
• 43:00 How do you sell Syntax to Sentry?
• 48:37 Sick Picks & Shameless Plugs

• Ben: Randy’s YouTube, Boom.

• Ben: Counterscale.dev

Syntax: X Instagram Tiktok LinkedIn Threads

Wes: X Instagram Tiktok LinkedIn Threads

Scott:X Instagram Tiktok LinkedIn Threads

Randy: X Instagram YouTube Threads