[bazoom42]

A lot of confusion comes from SQL nulls having the same name as nulls in programming languages. They are conceptually completely different things.

Nulls in programming languages are a special “sentinel” value indicating the lack of an object. Nulls in sql means “unknown” or “I am not able to answer that question”.

This is why in most programming languages two nulls are equal, since they are the same sentinel value. Not so in SQL, since one unknown value is not necessaily the same as some other unknown value.

[dspillett]

Worse: with JSON NULL is considered a type not a value of other types, which can make validating nullable values with JSON-Schema a royal pain.

[bazoom42]

JSON does not define a type system, but javascript defines null as the only value of the null type. This works fine in eg typescript since you can use a type union of null and any other type, if you want to indicate a nullable value.

[Izkata]

Don't forget in addition to null, javascript has undefined and undefined.

(the value undefined and the property-does-not-exist undefined)

[VMG]

but don't forget that `typeof null === 'object'` :)

[ElectricalUnion]

They're null pointer objects /s