News for hackers. Stuff that matters.
Re:Null Values in SQL Queries by dragonwriter on Tuesday February 04, 2020 @04:18AM (#22233719)
> SQL suffers this exact same problem. I wonder what SQL would look like without Null.

As a base table value, it's easy to mechanically avoid NULL in SQL. Every nullable column is, in the most general case, simply a column that doesn't belong in the table but in a different table whose primary key is alsona foreign key referencing the original table’s primary key.

Re:Null Values in SQL Queries by davedx on Tuesday February 04, 2020 @04:36AM (#22233819)
Your solution works, but I would hardly describe having a new table for every nullable column is "easy". It also would not be nice for maintenance -- often I want to add a new column as null initially, then soon after write a migration to convert it to non-null once it's populated. Having to create / remove a new table every time would be a pain.