📝Daily
Day 23
Tony Duong
Apr 15, 2026 ・ 1 min
#engineering#rails#concurrency#mysql#rspec

Today, I:
- wrote Lost Updates in a Rails App: What Broke, How We Fixed It, and How We Tested It about the lost update problem I encountered while fixing a bug in
spacely_webthat had been unsolved for years — covered what a lost update is, why MySQL InnoDB's REPEATABLE READ doesn't save you from read-modify-write on a JSON column, how two parallel jobs each merging a different key intoWorkflowRun#progressend up dropping one key, thewith_lockfix we shipped, and a threaded RSpec setup using twoQueues to reproduce the race and show failing vs passing output