Notes
Most recent first. They're written when I've finally understood something, so they arrive irregularly. Older ones may be wrong; I fix them when I notice.
- Backfilling a Kafka topic without double-counting Increments aren't idempotent. Fix the write first, then replay with a separate group.
- A migration checklist for Postgres partitioning Moving a live multi-terabyte table to range partitions without downtime, in nine steps and one list of things I forgot.
- Why I stopped using Airflow sensors What they cost, what they hide, and the four things that replaced them.
-
dbt incremental models and the late-arriving row
The standard
is_incremental()filter silently drops rows. Two fixes, one of them proper. - What a Go service owes its readiness probe Readiness is not liveness, and the shutdown order matters more than the code.
- Reading EXPLAIN (ANALYZE, BUFFERS) without panicking The order I read a plan in, and the one number that's usually the whole story.
- The cheapest data quality check is a row count Before any tool with a YAML file: count source, count destination, compare, keep the history.