Understanding Databases for System Design: ACID & Isolation Levels
A deep dive into transaction isolation levels, concurrency anomalies (dirty reads, non-repeatable reads, phantom reads, write skew), and how PostgreSQL and MySQL implement them.
System Design - Understanding Databases - Part 5
Navigating the Database Maze: Choosing Between Relational and NoSQL Databases
System Design - Understanding Databases - Part 4
Mastering Database Scaling: A Practical Guide to Partitioning and Sharding
System Design - Understanding Databases - Part 3
Scaling Databases: Mastering Vertical and Horizontal Techniques for Growth
System Design - Understanding Databases - Part 2
This article explains the isolation property of ACID properties by demonstrating each isolation level practically.
System Design - Understanding Databases - Part 1
Mastering Databases: The Backbone of System Design