Prateek Arora

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