
Use half-open intervals for incremental extracts
Assign boundary events exactly once with SQLite predicates, compare 23- and 25-hour local days, and separate late-arrival completeness from interval correctness.
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.

Assign boundary events exactly once with SQLite predicates, compare 23- and 25-hour local days, and separate late-arrival completeness from interval correctness.

Follow named-volume data through container recreation, distinguish mounts from backups and plan explicit data removal.

Trace independent DNS cache deadlines, remaining TTL and cached NXDOMAIN answers, then separate ordinary expiry from serve-stale policies and application connections.

Predict a sticky label’s position, find hidden scroll ancestors, and preserve fragment and keyboard visibility in a working reading panel.

Move from frontend into AI with a small document assistant, clear system boundaries and evidence for each learning step.

Turn meeting notes into evidence-linked draft tasks, distinguishing active commitments, missing information, valid structure and reviewed creation.

Work through cosine similarity with small vectors, distinguish ranking from probability, and choose retrieval thresholds using labeled examples.

Explain the condition-variable predicate loop with two consumers, a stolen item and an atomic unlock-and-wait boundary.

Read versioned preferences without startup rewrites, expose failed saves, preserve observed unknown records and test what storage events do across real tabs.

Compute a tenant-scoped email key, test concurrent uniqueness and compare retired-key reservation with an active-only index and its restoration conflict.

Expand a GitHub Actions matrix into actual jobs, apply include and exclude deliberately, and keep unsupported combinations out of the claim.

Follow one shared module through live bindings, measured HTTP loading, initialization failures and URL identity using a complete native-button example.