SQLite

It's not just numbers pretending to be text. SQLite also accepts a column declared with a type it's never heard of, like DATETIME, JSON, or a typo such as BLOBB, no questions asked. Evan Hahn's fix is one word: STRICT.

In the thread, an engineer traced a real data-corruption bug back to exactly this looseness: a UUID silently turned into the wrong number, caught only after rebuilding the table under STRICT.

The SQLite log kept only ~500K rows, yet its autoincrement counter had passed 5.5 billion: a frantic insert-and-prune churn, 70.7% of it raw TRACE noise. The cause was a one-line default capturing every diagnostic at Level::TRACE. A maintainer who'd hit an identical bug years before pushed back on the slop jokes, then someone found Claude Code doing the same thing.