Software Engineer
mediumacid-properties-databases
What are ACID properties in databases?
Answer
ACID ensures reliable transactions:
- **Atomicity:** all-or-nothing.
- **Consistency:** constraints/invariants remain valid.
- **Isolation:** concurrent transactions don’t interfere (depends on isolation level).
- **Durability:** committed data survives crashes.
**Interview tip:** Connect ACID to real problems like double-charging in payments, and mention trade-offs like performance vs stronger isolation.
Related Topics
DatabasesSQLTransactions