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.

Currently building PgLens Finds the Postgres queries costing your database the most time, suggests an index for each, and measures whether it really helped. Self-hosted, and read-only on your database. github.com/Prateek-Arora/pglens

Writing

  1. 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.

  2. 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.