The Bare `id` Primary Key: When Every Table Joins to Every Other Table
Section
50 pages
Posts
Polymorphic References Are Not Foreign Keys
ORMs Are a Coupling, Not an Abstraction
Schema Conventions Don't Survive Without Automation
Where Business Logic Lives - Database vs. Application
Database Deadlocks, Part 2: Diagnosis, Retries, and Prevention
Database Deadlocks, Part 1: The Patterns
Uniqueness and Selectivity: The Two Numbers That Drive Query Plans
Comment Your Schema
Foreign Keys Are Not Optional
