Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

So using null to mean the opposite of what it normally means? I would recommend against anyone using that workaround.


That depends on whether you see null as a marker of not having data or a marker of not knowing if there is data.


Both of those are data unknown, and both would normally be null. You don't distinguish between known unknowns and unknown unknowns at the database level.

When you say "The user submitted an empty form field as their answer", you do have data. It's weird to use null for that.

Since you can leave a key absent in DynamoDB, it basically has two ways to say "data unknown" and no way to say "knowingly left blank".

You can repurpose null as you suggested, and it will work fine in isolation, but it will massively violate the principle of least surprise and could lead to painful bugs.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: