You either have actual NULLs in your tables or you have implied NULLs that don't... | Hacker News

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

		6nf on May 9, 2019 \| parent \| context \| favorite \| on: We Can Do Better Than SQL You either have actual NULLs in your tables or you have implied NULLs that don't exist in the actual tables but still come up when you do LEFT JOINs etc. I don't think NULLs are actually a problem in SQL. It's not like we're talking about pointers, it won't cause your server to crash if you use them wrong. NULLs in SQL are fine.

ben509 on May 9, 2019 [–]

They're far worse than null pointers. They can cause subtle bugs that lead to queries that appear to work but result in missing or incorrect data.

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact