GGautam Patel·Apr 14Why Data Changes Mid-Transaction: Database Isolation Levels ExplainedUnderstand database isolation levels with real examples. Learn dirty, non-repeatable, and phantom reads and how to prevent them.6 min read·iamgautam.hashnode.dev
AAbstract Algorithms·Apr 11Lost Update Explained: When Two Writes Become OneHow concurrent read-modify-write operations silently discard one transaction's changes — and four ways to prevent it from overselling your inventory.38 min read·abstractalgorithms.hashnode.dev
AAbstract Algorithms·Apr 11Non-Repeatable Read Explained: When the Same Query Returns Different ResultsWhy reading the same row twice in one transaction can return different committed values — and which isolation level finally stops it.26 min read·abstractalgorithms.hashnode.dev
AAbstract Algorithms·Apr 11Phantom Read Explained: When New Rows Appear Mid-TransactionHow concurrent inserts and deletes make a range query return different rows within a single transaction — and why only Serializable stops it.32 min read·abstractalgorithms.hashnode.dev
AAbstract Algorithms·Apr 11Write Skew Explained: The Anomaly That Requires Serializable IsolationTwo transactions check a shared condition and write to different rows — individually correct, collectively wrong. Why Repeatable Read fails.23 min read·abstractalgorithms.hashnode.dev
AAbstract Algorithms·Apr 11Read Skew Explained: Inconsistent Snapshots Across Multiple ObjectsHow a transaction can read two objects at different points in time, violating invariants that no single committed state ever broke.34 min read·abstractalgorithms.hashnode.dev
AAbstract Algorithms·Apr 11Dirty Write Explained: When Uncommitted Data Gets OverwrittenHow uncommitted row overwrites corrupt cross-table state — and why row locks are the critical safeguard in every relational database.28 min read·abstractalgorithms.hashnode.dev1
AAbstract Algorithms·Apr 11Dirty Read Explained: How Uncommitted Data Corrupts TransactionsHow a single uncommitted write can corrupt downstream reads, cause phantom transactions, and what isolation levels prevent it.30 min read·abstractalgorithms.hashnode.dev
NNishil Bhave·Apr 3ACID Properties in DBMS with Examples (Complete Guide)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...14 min read·nishilbhave.hashnode.dev
