4 ms·
ACID and DTCs will get you in legal trouble with financial systems. That is part of the reason financial systems backed by SQL are so complicated and fragile w
by nyrikki 2y ago
ACID and DTCs will get you in legal trouble with financial systems.
That is part of the reason financial systems backed by SQL are so complicated and fragile while old COBOL code keeps going.
RDBMS tutorials always use ATMs as an example, but you can't 'roll back' with ATMs, you have to use compensating actions.
ACID is useful in many contexts, but actually adds complications to financial transactions.
Think of the ledger as being the source of truth, with the DB as simply a materialized view.
It has applications with edge caching in web apps too. Events as the source of record can help get rid of cache invalidation challenges compared to cache aside or write back.
Two sides errors that don't impact the trial balance is something to search for if you want to know why an ACID DB as the source of truth is problematic in accounting.