Algorithms
Should a survey be "completed" or "expired"? Store the flag and it lies between updates; compute it on read and it is always true. A design for lifecycle derivation, assignee coverage, and the short-circuits that keep it fast.
AI
What if a language model compiles a procedure once and never runs again? A skill compiler with hard structural gates, a zero-model interpreter that walks the graph in plain code, and a trust ladder that must be earned run by run.
Algorithms
Background jobs that run for minutes, pause for human answers, and survive restarts need more than a status column. A design for pausable, resumable, auditable background work: explicit states, a question channel, generation gates, and append-only logs.