Transaction Isolation Levels
In the database world when the same data is accessed by different users concurrently, ACID properties ensure that we can isolate access to the data. ACID stands for atomicity, consistency, isolation and durability Atomicity guarantees that all operations either complete or fail so that there would be no partially completed operations Consistency ensures that each transaction leaves database content in a usable state so that the next transaction gets to a version of data it can work with. Isolation provides a way for multiple transactions to execute concurrently without being aware of other concurrent transactions, and the last property is Durability, which ensures that the result of successful transactions are persisted even with system failures Atomicity, consistency and durability are taken care of by a database "transparently", but isolation is something we can control with SQL. Let's find out what it means exactly. When two users work with the same d