3 ms·
Financial transactions are different from database transactions despite using the same word; hackers shocked at the discrepancy. Film at 11.
by gnu8 14y ago
Financial transactions are different from database transactions despite using the same word; hackers shocked at the discrepancy. Film at 11.
- Firehed 14y agoNot really, and as someone who works on just such a system, please let me assure you that you simply cannot design a reasonable system without DB transactions for at least certain processes. I'm more than happy to go into significant detail here, but I think it will just get lost in the shuffle of hacker news comments (at some point I should do a proper article on this stuff). Long story short, you simply cannot make things reliable without having a balance change and its corresponding state update happen atomically. There's other parts you would be well advised to do within that same transaction (ledger entries being the most notable) but you could get by doing that separately if you really hate yourself.
- jacques_chester 14y agoI think his point is that the nomenclature is overloaded. What accountants call a transaction is similar to, and probably inspired, what computer scientists call a transaction. But they are not strictly isomorphic.