Notes on distributed systems, databases, frontend, and AI.
I'm Prateek Arora, a full-stack engineer with five years in fintech and SaaS. I work across the stack, from Java and Node.js services to React front ends. This is where I write up what I learn.
Writing
-
I timed 179 index recommendations on real data. 18% made the query slower.
Planner-validated index advice, built for real and timed on the Join Order Benchmark.
-
A read-only safety belt that breaks your app's writes
Through PgBouncer in transaction mode, a monitoring tool's read-only setting lands on the next client's connection.