Every published module, all in one place.
View the Database category page
8 modules
Database → Schema Design
Schema fundamentals that prevent the expensive-to-fix mistakes: keys, constraints, normalization, correct types, and indexing discipline.
by @markdowners
Database → Migrations
How to change a live schema safely: backward-compatible rollout steps, no same-migration drops, and lock-aware changes on large tables.
Database → Mysql
PHP + MySQL conventions on top of database-design-basics: prepared statements, utf8mb4, InnoDB, and PHP's shared-nothing request lifecycle.
Database → Postgres
PostgreSQL-specific conventions on top of database-design-basics: naming, precise types (citext/jsonb/timestamptz), and RLS basics.
Database → Caching
Apply a disciplined caching strategy: cache-aside as the default pattern, TTLs on everything, explicit invalidation on writes, stampede protection, versioned cache keys, what to never cache, and measuring hit rates.
Database → Nosql
Model document databases like MongoDB correctly: design for access patterns rather than normalization, choose embed vs. reference deliberately, denormalize with an explicit update plan, avoid unbounded arrays, index for real queries, and validate schema even in a schemaless store.
Database → Orm
Use an ORM (Prisma or equivalent) without its convenience becoming a performance or security liability: N+1 detection and eager loading, transactions for multi-write invariants, parameterized queries only, selecting only needed columns, ORM-managed migrations, and when to drop to raw SQL.
Database → Search
Build full-text search that returns relevant results: analyzer and tokenizer choices, balancing exact vs. fuzzy matching, relevance tuning with field boosts, result pagination, keeping the search index in sync with the source of truth, highlighting, and zero-result handling.