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
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

Cheat Sheets Jun 28, 2026 intermediate

MongoDB Data Modeling Checklist

A checklist for deciding when to embed, reference, index, and evolve MongoDB documents.

Docs Jun 28, 2026 intermediate

MongoDB Data Modeling Notes

A document-database mental model for aggregates, embedding, references, indexes, and operational tradeoffs.

Docs Jun 28, 2026 intermediate

PostgreSQL Production Notes

Operational Postgres concepts for backend engineers: schemas, indexes, transactions, migrations, and reliability.

Backlinks