SBShantanu Badmanjiinshantanubadmanji.hashnode.dev·May 5 · 11 min readWhy I Used PostgreSQL Advisory Locks Instead of RedisThe moment you say "race condition across concurrent tasks," every engineer in the room reaches for Redis. It's the default. It's what the internet recommends. It's what that one architecture post wit00
SBShantanu Badmanjiinshantanubadmanji.hashnode.dev·Apr 20 · 7 min readWhy DATE(updated_at) Broke Timezones and Killed PostgreSQL Index PerformanceI recently resolved two separate production bugs that turned out to share the same root cause — a seemingly innocent DATE() call wrapped around a timestamptz column. What made it worse: the pattern ha00
