Double-entry is 500 years old and still the right data model
The obvious way to store balances — a column you update — is the one that will eventually betray you. Here's why the accountants had it right.
Thoughts
One idea per piece. The trade-off is the whole point.
The obvious way to store balances — a column you update — is the one that will eventually betray you. Here's why the accountants had it right.
You can't deliver a message exactly once across a network. What you can do is process at-least-once and make duplicates harmless — which is the real job.