ACID Properties
Question
What does ACID stand for in databases?
Hint
ACID guarantees reliable database transactions.
Explanation
ACID is a set of properties for reliable database transactions: Atomicity — all operations in a transaction succeed or none do (all-or-nothing). Consistency — transactions move the database from one valid state to another. Isolation — concurrent transactions do not interfere with each other. Durability — committed transactions are permanent, surviving crashes. Relational databases (PostgreSQL, MySQL with InnoDB) provide ACID. NoSQL databases often sacrifice ACID for performance/availability (BASE: Basically Available, Soft state, Eventual consistency).
Related Resources
Related Lessons
- ACID
Learn ACID.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.