SQLite Query Optimisation - How the Planner Thinks and Where It Goes Wrong
You write a query against a table with 500,000 rows and an index on the column you're filtering by. The query takes 800ms...
Hi, I'm Gaurav.
Software Engineer at Stripe, working on the Database Engine team. 10 years across startups and MNCs — infra, platform, databases.
I write about software systems, engineering decisions, and whatever else catches my interest. Previously at VMware, Rippling, and Lavelle Networks.
StripeRipplingVMwareLavelle Networks
Recent Posts
All posts →How PostgreSQL Handles Large Values - TOAST and What It Costs You
In the [previous post](https://www. gauravsarma...
SQLite Overflow Pages - When Your Rows Don't Fit
You add a bio column to your users table. A few months later, some users have written essays in there: 50KB, 100KB...
Single-Node Kubernetes GitOps on a Budget
You want GitOps. You don't want to pay $70/month for a managed cluster, operate an etcd quorum, or maintain a fleet of nodes for a side project or small team...
Building Gigaboy, An Autonomous Software Engineering Agent Orchestrator
_2026-03-02_ Your issue tracker has 40 tickets in the backlog. Twelve of them are well-defined, self-contained, and have been sitting there for three sprints because nobody has the bandwidth to pick them up...
Featured Projects
GitHub →crashdsaTypeScript
Aggregates NeetCode 150, Blind 75 and more into ~326 unique problems organized by 20 solution patterns.
localisprod-v2Go
Self-hosted mini-PaaS — deploy Docker containers to SSH nodes with managed Postgres, Redis, Kafka, live logs.
logical-replicationGo
From-scratch Raft-based logical replication with modular sub-managers for WAL, log sync, and leader election.
cronnyGo
Job scheduler with a rich DSL — schedules, triggers, job templates, connector integrations, and complex pipelining.