Two-Phase Commit Sink
A completed checkpoint records progress; a destination commit exposes output. The sink must recover safely when failure separates those two actions.
-
-
Optimistic Concurrency Control
Optimistic concurrency control lets writers prepare changes without holding locks throughout the work, then validates and commits atomically. Conflicts can require a retry.
-
Building Incremental and Idempotent Pipelines
Define incremental bounds and retry identity, preserve newer updates and deletes, and coordinate publication, progress, and backfills.
-
Relational Database Internals
Explore how indexes, statistics, WAL, snapshots, and locks shape query behavior through SQLite examples and PostgreSQL concurrency mechanisms.