Relational database design and SQL best practices for building software applications. Covers schema modeling, normalization, data types, keys, constraints, indexing, query performance and EXPLAIN, transactions, isolation and locking, migrations, and PostgreSQL/MySQL-specific gotchas and antipatterns. Use when designing a database schema, creating or altering tables, choosing data types or keys, adding indexes, writing or optimizing SQL queries, debugging slow queries or deadlocks, planning a migration, or choosing between Postgres and MySQL. Triggers on "design a schema", "create table", "add an index", "normalize", "foreign key", "slow query", "EXPLAIN", "N+1", "migration", "deadlock", "Postgres", "MySQL", "SQL best practices".
2026-06-26