Section

30 pages

Postgresql

Comment Your Schema 0 Covering Index Traps: When Adding One Column Breaks Your Query 0 Database Deadlocks, Part 1: The Patterns 0 Database Deadlocks, Part 2: Diagnosis, Retries, and Prevention 0 Designing Partitioning You Don't Have to Babysit 0 Foreign Keys Are Not Optional 0 God Tables: 150 Columns and the Quiet Cost of 'Just Add a Column' 0 Hidden Database Costs of an Ai Rollout: Storage, Cpu, Memory, and Cache 0 It's Almost Always the Queries, Part I: Why Metal Doesn't Help 0 It's Almost Always the Queries, Part Ii: Troubleshooting Steps 0 It's Almost Always the Queries, Part Iii: When the Cpu Is Pegged 0 It's Almost Always the Queries, Part Iv: When the Sort Spills 0 It's Almost Always the Queries, Part V: Disk Has Two Alarms, Not One 0 Joins That Lie: The Cardinality Problem 0 Legacy Schemas Are Sediment, Not Design 0 Letting Ai Manage Your Indexes: The System and Guardrails the Sme Has to Build 0 Non Sargable Predicates: How a Function in Where Kills Your Index 0 Null in Sql: Three Valued Logic and the Silent Bug Factory 0 Orms Are a Coupling, Not an Abstraction 0 Polymorphic References Are Not Foreign Keys 0 Random Uuids as Primary Keys: The B Tree Penalty 0 Reading the Schema Is Not Reading the Data 0 Schema Conventions Don't Survive Without Automation 0 Testing Your Database, Part 1: Why Ai Made It Mandatory 0 Testing Your Database, Part 2: What to Test, and How 0 Text and Json Columns: Where the Schema Goes to Hide 0 The Bare `Id` Primary Key: When Every Table Joins to Every Other Table 0 Uniqueness and Selectivity: The Two Numbers That Drive Query Plans 0 What Ai Gets Wrong About Your Database 0 Where Business Logic Lives Database vs. Application 0