Section
51 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
NULL in SQL: Three-Valued Logic and the Silent Bug Factory
Joins That Lie: The Cardinality Problem
Uniqueness and Selectivity: The Two Numbers That Drive Query Plans
Comment Your Schema
1
2
3
4
5
6