Section
10 pages
Schema Design
Posts on table and column design in MySQL and PostgreSQL: primary keys, foreign keys, TEXT and JSON columns, god tables, collation, and naming conventions.
Clustered vs Non Clustered Index: The Table Is the Index in Mysql
0
God Tables: 150 Columns and the Quiet Cost of 'Just Add a Column'
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
What Ai Gets Wrong About Your Database
0
Where Business Logic Lives Database vs. Application
0