Back to blog
Engineering

Engineering

Deep dives into the technical architecture, code, and engineering decisions behind Userloom.

engineering
Self-Hosted ClickHouse Cluster Architecture
Read Article
engineeringUnder the Hood · Article 37 min read

How I Built a Self-Hosted ClickHouse Cluster from Scratch

A practical guide to deploying a production-ready ClickHouse cluster using Terraform and Ansible on Hetzner. Covers cluster architecture, sharding vs replication, Keeper quorum, and why I skipped Kubernetes.

Seerat AwanSeerat Awan•Jan 10, 2026
Read article

More in Engineering

engineering
Userloom Event Ingestion Pipeline
Read Article
engineeringUnder the Hood · Article 2

Core Infra and the Ingest Pipeline

A deep dive into why we chose Cloudflare Workers over AWS Lambda for event ingestion, the tradeoffs of managed vs. self-hosted ClickHouse, and how events flow from SDK to database.

Seerat AwanSeerat Awan•Jan 5, 2026
engineering
Designing the Userloom API Schema
Read Article
engineeringUnder the Hood · Article 1

Why I'm Obsessing Over Signal Capture

Analytics isn't the product. It's the foundation. A deep dive into the API design decisions behind Userloom's event ingestion schema, and why getting behavioral signals right matters more than anything else.

Seerat AwanSeerat Awan•Jan 1, 2026
Limited beta spots available

Stop losing users to silence.

Join the beta, help us build, and lock in a lifetime discount when we launch.

Join founders on the waitlist · Lifetime discount at launch · Shape the product with us