infra · sql
Staging environments on a budget (without lying to students)
We cannot give every learner a dedicated cluster, so we isolate by schema prefixes and time-boxed roles. The trick is naming: prefixes include cohort week so accidental cross-talk is obvious in logs.
We also ship synthetic spikes—short bursts of duplicate events—so monitoring exercises feel real without touching PII. Students still file incident notes with timestamps and owner tags.
When budgets tighten further, we swap compute for rigor: smaller data, stricter acceptance tests, and more peer review minutes. The emotional goal is realism, not vanity scale.
We keep appendices short on the blog; if you need primary sources or query snippets referenced in class, ask via the contact desk with the module name in the subject line.