6d ago · 36 min read · TLDR: ACID is four orthogonal guarantees that every SQL transaction must provide. Atomicity says all-or-nothing: PostgreSQL implements it via WAL rollback; MySQL InnoDB via undo logs. Consistency says constraints always hold: the database rejects any...
Join discussion
Apr 5 · 35 min read · TLDR: ACID transactions in distributed databases are not equal. DynamoDB provides multi-item atomicity scoped to 25 items using two-phase commit with a coordinator item, but only within a single region. Cosmos DB wraps partition-scoped operations ins...
Join discussion
Apr 5 · 25 min read · TLDR: Isolation levels control which concurrency anomalies a transaction can see. Read Committed (PostgreSQL and Oracle's default) prevents dirty reads but still silently allows non-repeatable reads, write skew, and lost updates. Repeatable Read adds...
Join discussion
Apr 3 · 13 min read · What Are ACID Properties and Why Do They Matter for Every Database? Every backend developer writes SQL. Fewer can explain what actually happens between BEGIN and COMMIT. That gap isn't academic — it's the difference between a system that survives a c...
Join discussion
Mar 30 · 14 min read · Originally published at Gothar Tech Part of our 2025 software architecture series. ACID Is a Contract, Not a Religion: How Real Systems Keep Money Safe Most engineers learn ACID early. Most engineers also learn later that ACID is not the whole stor...
Join discussionMar 12 · 5 min read · Modern applications — from banking platforms to e-commerce systems — rely on databases to store and manipulate critical data safely. Without strong guarantees, even simple operations could lead to corrupted information, inconsistent records, or perma...
Join discussionFeb 12 · 12 min read · Why Traditional Transaction Management Fails in Modern Systems The classic approach of "just use transactions" breaks down when applications scale beyond single-database deployments. In 2025, most production systems span multiple databases, caching l...
Join discussionNov 17, 2025 · 6 min read · Picking the right database in AWS can feel overwhelming. You’re staring at more than 15 different options, and it’s easy to get lost. Whether you’re building a simple web app or a complex enterprise system, the database you choose really does shape y...
Join discussionAug 18, 2025 · 1 min read · 🤯 ACID vs BASE — що це і як не вилетіти на співбесіді? У цьому відео ти зрозумієш різницю між двома найважливішими підходами до роботи з базами даних. Простими словами, з прикладами з реального життя, кар'єрними порадами та підступними запитаннями, ...
Join discussion
