News for hackers. Stuff that matters.
Re:SQL: Incorrect by Construction by bena on Tuesday May 12, 2026 @05:13PM (#48114694)
You don't update balances, you enter transactions. Then you derive balances from transactions.

You can even insert them in an unvalidated state, then validate them later. That way if you have two transactions that come one after another, it doesn't matter because you can process them sequentially anyway.

Re:SQL: Incorrect by Construction by JohnyTex on Friday May 15, 2026 @09:22AM (#48148263)
How would you ensure Alice doesn't overdraft her account?