MVCC
Multi-Version Concurrency Control allows concurrent access to a database by keeping multiple versions of each data item. Readers see a consistent snapshot without blocking writers.
MVCC: Multi-Version Concurrency Control
Readers never block writers: each transaction sees a consistent snapshot of versions.
MVCC in Production: Postgres and Isolation Levels
Read committed vs repeatable read, visibility rules, and vacuum.
Advanced MVCC: Distributed Snapshot Isolation
MVCC across shards, and how Spanner-style systems manage snapshots.
MVCC: Review & Mastery Quiz
Scenario questions on snapshots, isolation, and distribution.
Free Books & Guides
Refactoring.Guru — MVCC
The definitive modern guide to the MVCC pattern. Clear explanations, UML diagrams, real-world analogies, and code examples in multiple languages.
SourceMaking — MVCC
A comprehensive companion guide covering the MVCC pattern with detailed rules of thumb, criticisms, and robust code snippets.
GoF Design Patterns — MVCC
The original Gang of Four book describing the pattern. Available in the "Design Patterns: Elements of Reusable Object-Oriented Software" on Wikipedia.
Official Documentation
Video Courses
freeCodeCamp — Design Patterns Course
A comprehensive multi-hour video course covering all major design patterns with implementations in JavaScript and TypeScript.
Design Patterns in Modern JavaScript Playlist
YouTube playlist covering creational, structural, and behavioral patterns with clear code walkthroughs.
Web Dev Simplified — MVCC
Clear, concise video tutorials covering design patterns with practical examples.
Practice & Examples
Awesome Low-Level Design (GitHub)
A curated collection of free LLD resources, pattern implementations, and interview problems across multiple languages.
Design Patterns Implementation (GitHub)
The most popular open-source collection of design pattern implementations with detailed explanations.
Refactoring.Guru Examples in MVCC
Code examples of the MVCC pattern in TypeScript, Python, Java, and more.