Database Transactions
Created on 2022-01-20T17:29:16-06:00
TBD if this should become a hub or not
Transactional databases allow queing a set of changes across depots which must all be applied at once or none of them.
The protocol for getting multiple independent depots to stage and commit a transaction is called Two-Phase commit.
Internally you can rely on locks to secure reads/writes during this process or you can use live version pointers (at the risk of still being allowed to read data during a change period.)