https://radiolab.org/podcast/null
> JOSEPH TARTARO: I had a wad of envelopes. It was like 15 envelopes. You know, with my name and my address and everything. I was just like, “What the hell?” Because I don’t really get mail. But then I open the first one up and it’s like, “I got a parking ticket.”
> SIMON: What it appeared was happening was that instead of his Null license plate being stored as blank, every blank license plate was being stored as null. And so every ticket written without a plate number, maybe cuz the car didn’t have one or the cop forgot to fill it in was being sent to Joseph.
They even cover /u/patio11's famous "Falsehoods Programmers Believe About Names" essay. https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-...
My biggest frustration about names though, is that even if I “do it right” more or less by allowing a full name to be a single column with loose “validation,” the next thing I’m confronted with is some stupid integration point whose API demands exactly “first name” and “last name” and we’re stuck parsing our nice single name field up into random slices. Mostly because someone wanted to get cute by uselessly greeting you with a “Hi, Bob!” or they think those circles with exactly 2 initials are a good substitute for putting names on the screen.