It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping on each other’s toes, all the time. When we’re talking about relational data stores, one aspect that makes them what they are is the need to comply with the ACID properties. These are:
Atomicity: A transaction fails or completes as a unit Consistency: Once a transaction completes, the database is in a valid, consistent, state Isolation: Each transaction occurs on its own and shouldn’t interfere with the others Durability: Basically, writes are writes and will survive a