Writing
Technical writing on
backend engineering.
Long-form articles on Node.js, AWS infrastructure, DevOps and system design - distilled from real production experience building and scaling systems in India.
Scaling PostgreSQL in Production: Indexing, RPC Functions, Views, and Query Optimization
A practical look at how composite indexes, database views, Supabase RPC functions, pagination, and query optimization techniques improved the performance and maintainability of a multi-tenant PostgreSQL system handling over 120,000 daily database requests.
Building an Atomic Delivery Dispatcher with PostgreSQL Row-Level Locking
How to design a high-reliability delivery batching and dispatch engine in TypeScript. Learn how to prevent rider capacity overload using PostgreSQL row-level locks, enforce strict order states, and store delivery tracking proofs using JSONB.
Designing a Multi-Tenant Subsidy Engine with Concurrency-Safe Budget Tracking
How to architect a B2B meal allowance and subsidy calculation system in Node.js and PostgreSQL. We walk through schema mapping, resolving discount conflicts using the Maximum Rule, and preventing budget depletion race conditions.
How I Cut AWS Costs by 60% by Fixing Infrastructure Inefficiencies
How fixing excessive logging, removing unoptimised log storage and moving static assets from Node.js to NGINX reduced a production SaaS AWS bill by 60% - without redesigning the architecture.
Scaling a Food-Tech SaaS from 1K to 20K Users
Lessons from scaling an institutional food-services platform - PostgreSQL indexing, API pagination, connection pooling and handling peak-load lunch rushes across 20,000+ users.
Node.js Performance Optimization: From Slow APIs to Scalable Systems
Practical Node.js performance techniques from production: event loop non-blocking patterns, PM2 clustering, Redis caching, database query optimization and gzip compression - with real benchmark results.
Zero-Downtime Deployments with PM2 and NGINX
Step-by-step guide to zero-downtime Node.js deployments: PM2 cluster mode, graceful SIGINT shutdown handlers, NGINX reverse proxy config and CI/CD webhook automation.