Badmanji Builds

Badmanji Builds

#backend

Articles tagged with #backend

Why I Used PostgreSQL Advisory Locks Instead of Redis
When the "obvious" distributed locking answer is overkill — and your database is already equipped for the job.
May 5, 202611 min read19
Why DATE(updated_at) Broke Timezones and Killed PostgreSQL Index Performance
A 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.
Apr 20, 20267 min read81