How Does a Database Work?
- When does it move from memory to disk?
- Why can there only be one primary key per table?
- How does rolling back a transaction work?
- How are indexes formatted?
- When and how does a full table scan happen?
Table of Contents
- Part 2 - World’s Simplest SQL Compiler and Virtual Machine
- Part 4 - Our First Tests (and Bugs)
- Part 7 - Introduction to the B-Tree
- Part 9 - Binary Search and Duplicate Keys
- Part 11 - Recursively Searching the B-Tree