Expert Opinion Aug 18, 2026
I moved logic out of the database and took on a harder problem on purposeMoving business logic out of database triggers and into application events does not simplify the system. It trades atomicity for visibility, and it buys a new class of bug. I retired eleven triggers on a live product, left ten running on purpose, and got the sequencing wrong.
Read article