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
