Constraints Are Better Than Hope
How foreign keys, unique constraints, and checks protect data better than comments.
SQL
All posts
Reporting Queries Without Destroying Production
How to handle dashboards, aggregates, indexes, and replicas with production safety in mind.
MySQL vs PostgreSQL Thinking for Backend Developers
Differences worth knowing when designing schema, JSON fields, indexes, and transactions.