sql
Posts tagged "sql".
- Two Timestamps Beat a Status Column
A status column answers 'what state is this in now?' and destroys the answer to 'what state was it in last Tuesday?' every time you update it. Replace the one mutable cell with a couple of timestamps and the state becomes something you derive — reversibly, and as of any date you like.
- Keep the Runner Dumb
Most small data pipelines get cluster-scale tooling bolted onto a laptop-scale problem. I built the opposite — a single-file SQL runner that refuses to parse your SQL, holds no state, and won't schedule anything. The whole design is a stack of things it declines to do.