Aurora Optimization: How Storage Cleanup, Replica Removal, and Right-Sizing Cut RDS Costs by 84%Reduce Aurora RDS costs by 84% through storage cleanup, replica removal, and instance right-sizing. Real metrics, tested approach, zero downtime.10 min read·shantanubadmanji.hashnode.devAug 13
From $4,200 to $800/month: Our AWS Cost Optimization Journey — 81% Cost Reduction With Zero DowntimeWe were paying $4,200/month for infrastructure we didn't need to use. In three months of careful measurement and disciplined optimization, we cut that bill by 81% with zero downtime and zero incidents. This is how we did it—and the framework you can apply to your infrastructure.11 min read·shantanubadmanji.hashnode.dev2Aug 4
Why I Used PostgreSQL Advisory Locks Instead of RedisWhen the "obvious" distributed locking answer is overkill — and your database is already equipped for the job.11 min read·shantanubadmanji.hashnode.devMay 5
Why DATE(updated_at) Broke Timezones and Killed PostgreSQL Index PerformanceA real-world deep-dive into how a single SQL wrapper caused wrong dates for international users and made indexes completely useless — and the SARGable fix that resolved both.7 min read·shantanubadmanji.hashnode.devApr 20