Under the Hood
A complete guide broken into 3 articles. Start from the beginning or jump to any section.
Start ReadingAll Articles
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 Awan•Jan 1, 2026Core 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 Awan•Jan 5, 2026How 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 Awan•Jan 10, 2026Stop 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