Section
23 pages
Database Architecture
Comment Your Schema
0
Designing Partitioning You Don't Have to Babysit
0
Exposing Data to an Agent: Mcp vs Api
0
Foreign Keys Are Not Optional
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
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
Reading the Schema Is Not Reading the Data
0
Schema Conventions Don't Survive Without Automation
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