Database Internals: How Data is Stored in Pages
Doogal Simpson
Command Palette
Search for a command to run...
Archive
146 posts published so far
Single Responsibility Principle for AI Sub-Agents
Doogal Simpson
How Database Reads Work: Pages, Buffer Pools, and Disk
Doogal Simpson
How Database Inserts Work: WAL and Buffer Pools
Doogal Simpson
Database Transaction Isolation Levels Explained
Doogal Simpson
Consistent Hashing Explained: How Netflix Scales
Doogal Simpson
AI Code Refactoring: Why Testing Still Matters
Doogal Simpson
Count-Min Sketch Explained: Trillions of Counters
Doogal Simpson
Apple Secure Enclave: Face ID Security Explained
Doogal Simpson
How Face ID Adapts to Beards and Facial Changes
Doogal Simpson
Optimize Your Codebase for AI Coding Agents
Doogal Simpson
Prompting AI Coding Agents to Write Clean Code
Doogal Simpson
Why COBOL Still Powers Modern Banking Systems
Doogal Simpson
How OLED & LTPO Enable Always-On Displays
Doogal Simpson
Why Mobile CPUs Have Performance & Efficiency Cores
Doogal Simpson
Amdahl's Law: Why More CPU Cores Don't Make Code Faster
Doogal Simpson
Why Quantum Computers Won't Replace Classical Computing
Doogal Simpson
Spotify's Approximate Nearest Neighbor Search
Doogal Simpson
How Face ID Works: Infrared Lasers & Neural Networks
Doogal Simpson
Networking Logic: How Your Data Navigates the Internet
Doogal Simpson
What About Second HTTP? Solving the 100-File Connection Bottleneck
Doogal Simpson
The 600ms Tax: Why Every TCP Connection Starts with a State Negotiation
Doogal Simpson
TCP Exponential Backoff: Why Your Retries are Doubling
Doogal Simpson
TCP: Why the Internet Works Even When It's Broken
Doogal Simpson
Fixing Biased Entropy: The Von Neumann Unbiasing Trick
Doogal Simpson