News for hackers. Stuff that matters.
Re:Ex Post Office CEO hands back award after IT failures lea... by michael1999 on Tuesday January 09, 2024 @04:25PM (#38932323)
Don't worry about dbms transaction management. This is the wrong level. No bank uses database-level transactions to make sure a balance transfer doesn't erase or double money. They post a durable entry in the transaction log, and then compute balances as roll-ups of the transactions. If some weird data glitch or cosmic ray produces the wrong balances, just re-run the tx rollup!
Re:Ex Post Office CEO hands back award after IT failures lea... by michael1999 on Tuesday January 09, 2024 @04:41PM (#38932533)
This approach still leaks, but the breakage will be things like overdraft limits, and those can be handled as business exceptions. And that's why we have transaction size limits. Risk-management, all the way down.
Re:Ex Post Office CEO hands back award after IT failures lea... by mike_hearn on Wednesday January 10, 2024 @03:24AM (#38937665)
Yes I know, but banking isn't the only place where this sort of stuff can go wrong. See also the payroll discussion above. And Horizon had a similar design I think (message logs that were replayed to catch up with the true state of the ledger).