System

Systems programming and infrastructure — databases, service migration, and operational patterns.

Tap compare testing for service migration

Master shadow testing for large-scale system migrations. Learn to safely rewrite services by comparing outputs between old and new implementations.

Pick random values from an array in SQL(ite)

Emulate Python's random.choice in SQLite using JSON arrays and the random() function. Populate tables with realistic test data efficiently.