Advanced (Postgres?)
Transactions
Transactions group db commands to be atomic, all or nothing, and permanently recorded to disk(not dirty/in memory)
Useful for something like bank transfers where you want to ensure an amount is deducted and added or nothing
BEGIN;
UPDATE accounts SET balance = balance - 100.00
WHERE name = 'Alice';
-- etc etc
COMMIT;
Last updated