{"repo":"LukasNiessen/acid-and-base-explained","free":true,"listed":false,"github":"https://github.com/LukasNiessen/acid-and-base-explained","clone":"git clone https://github.com/LukasNiessen/acid-and-base-explained.git","description":"ACID and BASE transactions explained","language":null,"stars":15,"topics":["acid","base","database","transaction"],"license":null,"category":"databases-storage","readme_excerpt":"ELI5: What exactly are ACID and BASE Transactions? In this article, I will cover ACID and BASE transactions. First I give an easy ELI5 explanation and then a deeper dive. At the end, I show code examples. What is ACID, what is BASE? When we say a database supports ACID or BASE , we mean it supports ACID transactions or BASE transactions . ACID An ACID transaction is simply writing to the DB, but with these guarantees; 1. Write it all or nothing ; writing A but not B cannot happen. 2. If someone else writes at the same time, make sure it still works properly. 3. Make sure the write stays. Concretely, ACID stands for: A = Atomicity = all or nothing (point 1) C = Consistency I = Isolation = parallel writes work fine (point 2) D = Durability = write should stay (point 3) BASE A BASE transaction is again simply writing to the DB, but with weaker guarantees. BASE lacks a clear definition. However, it stands for: BA = Basically available S = Soft state E = Eventual consistency. What these terms usually mean is: - Basically available just means the system prioritizes availability (see CAP theorem later). - Soft state means the system's state might not be immediately consistent and may change over time without explicit updates. (Particularly across multiple nodes, that is, when we have partitioning or multiple DBs) - Eventual consistency means the system becomes consistent over time, that is, at least if we stop writing. Eventual consistency is the only clearly defined part of BASE. N","default_branch":null,"files":null,"tree":[],"storefront":"/r/LukasNiessen","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/LukasNiessen/acid-and-base-explained/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}