cheatsheets Jun 28, 2026 updated Jun 28, 2026
Database Design Checklist
A checklist for choosing and shaping relational or document data models.
- Status
- evergreen
- Visibility
- public
- Role Area
- Database design / Postgres / MongoDB
- Priority
- P0
- Confidence
- operational
- Category
- Databases
- Difficulty
- intermediate
- Published
- Jun 28, 2026
- Updated
- Jun 28, 2026
Access Patterns
- Top reads are known.
- Top writes are known.
- Sort and filter paths are known.
- Growth boundaries are understood.
Consistency
- Transactional invariants are listed.
- Eventual consistency is explicit where used.
- Race conditions have a mitigation plan.
Operations
- Migrations are reviewed.
- Backups and restore are tested.
- Retention and deletion rules exist.
- Indexes match query paths.
Source Links
Related Notes
Runbooks Jun 28, 2026 P0 intermediate
Database Design Mental Models
A durable set of data modeling questions for relational and document databases.
Cheat Sheets Jun 28, 2026 P1 intermediate
MongoDB Data Modeling Checklist
A checklist for deciding when to embed, reference, index, and evolve MongoDB documents.
Cheat Sheets Jun 28, 2026 P0 intermediate
PostgreSQL Production Checklist
A compact checklist for Postgres-backed backend services.
Runbooks Jun 28, 2026 P1 intermediate
MongoDB Data Modeling Notes
A document-database mental model for aggregates, embedding, references, indexes, and operational tradeoffs.
Runbooks Jun 28, 2026 P0 intermediate
PostgreSQL Production Notes
Operational Postgres concepts for backend engineers: schemas, indexes, transactions, migrations, and reliability.
Backlinks
Runbooks Jun 28, 2026 P0 intermediate
Database Design Mental Models
A durable set of data modeling questions for relational and document databases.