Skip to main content

20 docs tagged with "Tier 1 — Foundations"

Runtime, storage and correctness inside one process and one database.

View all tags

Atomicity & Durability

Rule: COMMIT SUCCESSFUL is a promise about your database's local rows, and nothing else.

Caching & Cache Stampede

Rule: the worst thing a cache can do is let every request rebuild it at the same moment. A cache

Consistency Boundaries

Rule: decide which invariants must be true *right now*, and let everything else converge.

Distributed Locks

Rule: a lock inside one process protects nothing once you run two instances. And a distributed

Indexes & Query Plans

Rule: an index that exists is not an index that is used. A query is fast in development

Large File Upload

Rule: user files must never stream through the application server. The client uploads

Storage Engines

Rule: the database does not read rows — it reads fixed-size pages. Almost every "slow query"

Temporal Data

Rule: a system does not act on objective truth — it acts on what it believed at the time.

Transaction Isolation

Rule: a read-modify-write split across two statements is a race condition unless you have