When working on relational databases there are some guarantees called ACID, but these guarantees are not as safe as we usually think.
Let's start with a simple situation, imagine that you have a system that holds a balance of each user in some SQL database.
user A | user B |
---|---|
id: 1 | id: 2 |
balance: 100 | balance: 50 |