Hacker News new | past | comments | ask | show | jobs | submit login

A person with alopecia's hair color isn't "unknown" it's non-existent. They do not have hair.

Would you suggest that a database of appearance information about a person should have a separate subtable for "hair" to properly model this feature?

Either way, in the end, for displaying 99% of the time you're going to be using a VIEW that LEFT JOINs all these cute normalized tables back together again, and then you're going to want to filter those views dynamically on a nice grid that the user is viewing, and the fact that X != X is going to bite you in the ass all over again.

Creating more tables is just moving the problem around, not solving it.




Join us for AI Startup School this June 16-17 in San Francisco!

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

Search: