|
You are here |
www.ahmed-ibrahim.com | ||
| | | | |
johnjr.dev
|
|
| | | | | When we study transactions in relational databases, one of the first things we learn are the guarantees that a transaction must provide. ACID(Atomicity, Consistency, Isolation, Durability) are the properties that we desire. Here, I will discuss the Isolation level in more detail and show that atomicity alone is not enough when handling concurrency. One classic example of the importance of atomicity is moving money between accounts. So, imagine that we have two accounts and we would like to transfer the total amount from one account to another one. In a relational database, what we need to do is three steps: | |
| | | | |
tigerbeetle.com
|
|
| | | | | The financial transactions database to power the next 30 years of Online Transaction Processing. | |
| | | | |
architecturenotes.co
|
|
| | | | | How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases. | |
| | | | |
www.softwareandbooz.com
|
|
| | | The host for PGSQL Phriday #009 is Dian Fay, who has asked us to discuss how we manage database changes. Oh my, Dian picked a topic that's near and dear to me. In fact, one of my (still visib... | ||