Back to blog
Seerat Awan

Seerat Awan

Founder & Builder in Chief

Building the product growth platform for teams who act on behavior. Capture signals, trigger emails, launch surveys, and turn more users into engaged customers.

“Patterns repeat.” - Ibn Khaldun

Articles by Builder in Chief

5 posts
engineering
ClickHouse Migration System
Read Article
engineeringUnder the Hood · Article 4

How to Built a Custom ClickHouse Migration System in TypeScript

ClickHouse has no built-in migration tool. Here's how we built a simple TypeScript-based system that handles replicated tables, distributed tables, rollbacks, and cluster-aware schema changes.

Builder in ChiefBuilder in ChiefJan 12, 2026
engineering
Self-Hosted ClickHouse Cluster Architecture
Read Article
engineeringUnder the Hood · Article 3

How to 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.

Builder in ChiefBuilder in ChiefJan 10, 2026
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.

Builder in ChiefBuilder in ChiefJan 5, 2026
engineering
Designing the Userloom API Schema
Read Article
engineeringUnder the Hood · Article 1

Why We're 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.

Builder in ChiefBuilder in ChiefJan 1, 2026
product
Userloom - Capture. Act. Retain.
Read Article
product

Introducing Userloom: Stop Losing Users to Silence

We're building a platform that captures every signal (website, mobile, API, webhooks, forms) and helps you send the right email or survey at the right moment. Here's our vision.

Builder in ChiefBuilder in ChiefDec 18, 2025
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