4 ms·
I've had cognitive dissonance for years, because in every basic database programming class, they tell you about transactions, and use the example of transferrin
by perl4ever 7y ago
I've had cognitive dissonance for years, because in every basic database programming class, they tell you about transactions, and use the example of transferring money from one account to another, where you don't want the system to be in an inconsistent state. Yet nothing in the real world works like that! I've particularly noticed how money being transferred between two different financial firms can either disappear for a few days, or be in both places at once. Not sure if it's happening more or I'm noticing it more.
- manigandham 7y agoYes, banking is always mis-used as an example for transactions and ACID but in reality it's eventually consistent, often spanning hours, days, and sometimes weeks. The real-world needs to account for laws, geographies, timezones, physical movement of goods and cash, risk management, etc. that is not modeled in a simplistic database class. I do wish they would pick a different domain to avoid this confusion.