
Prevent lost updates with a conditional UPDATE
Protect concurrent profile edits with a version-checked SQL update, distinguish zero rows from errors, and test conflict resolution and unversioned writers.
The journal / Ideas in progress
Engineering & everyday learningSoftware, systems, and the things I’m learning along the way. From first principles to AI in production.
Find something to readA little theory. A lot of practice.

Protect concurrent profile edits with a version-checked SQL update, distinguish zero rows from errors, and test conflict resolution and unversioned writers.

Trace LB and LBU on byte 0xE2, verify all extension cases, and connect assembly signedness to parser and language type choices.

Validate units, reporting scope, batch completeness and execution identity before computing a job-duration metric, while preserving legitimate empty results.

Prevent evaluation leakage by grouping related questions and document revisions, using time-aware boundaries, and keeping prompt development away from the final holdout.

Compare lookup errors under recording and speaker splits, then construct connected blocks that keep both speakers and devices separate.

Select the newest available producer for each operand, trace two writes to the same register, and distinguish forwarding from waiting for an unavailable result.

Keep inventory movements separate from closing balances, check missing warehouse coverage, and reconcile state with changes under an explicit reporting boundary.

Trace two increments that lose an update, define the critical section, and distinguish a teaching interleaving from undefined C++ data races.

Run two closure-backed counters, rebuild one listener owner, and distinguish live bindings, precomputed strings, object mutation and loop environments.

Compare a fixed invoice workflow with a repository investigation to decide where dynamic agent behavior earns its execution cost and complexity.

Sort fixed-width decimal identifiers from the least significant digit upward, trace all passes, and prove why each pass must preserve earlier digit order.

Use workflow artifacts to transfer tested outputs and dependency caches to avoid repeated downloads, with separate identity and retention rules.