Hacker News new | ask | show | jobs
by steego 932 days ago
While I’m sure NULLs nary be found in the ivory tower, you should know they are pervasive in the rest of the kingdom amongst us common folk.
1 comments

The comment you're replying to acknowledges this and suggests we plan accordingly.
Even from a “planning” perspective, that comment is about as unconstructive as they come.

How does it suggest we actually go about modeling missing values in the database?

I can think of a dozen ways to go about it and each one has its own tradeoffs and consequences.

When it comes down to it, is actually it worth it? Just so you don’t have to consider NULL scenarios for columns that are marked as nullable?

It seems like a silly overcorrection to me.