ACID
ACID means atomicity, consistency, isolation, and durability.
What it is
ACID means atomicity, consistency, isolation, and durability.
When to use it
Reason about database guarantees and remaining application duties.
Syntax
Atomicity: all or none
Consistency: constraints/invariants
Isolation: concurrency behavior
Durability: committed data survives under configured guaranteesExample
// Ask before a transfer:
// Are both balance changes atomic?
// Do checks/constraints enforce valid balances?
// Can concurrent withdrawals violate the rule?
// What storage/backup settings protect committed data?Common mistakes
ACID does not guarantee correct business rules, backups, or exactly-once external effects.