News for hackers. Stuff that matters.
Re:What does First Normal Form mean? by wwweston on Friday June 18, 2021 @12:18PM (#27551923)
Yeah, I think the early proponents of relational models had a lot to do with setting the culture here.

I suspect that some of this has to do with an insight I recently discovered: a "natural" key is in some sense a key that's so foreign it's in a "database" you don't control. And if you establish a culture that converges on natural keys, you may end up with more easily cross-operable databases/collections as an asset.

And this is why I think it's probably dead. If the boring practicality of generated identifiers didn't do it, laws like the CCPA which are going to, because they recognized the potential of broad cross-operable data to be a liability and a hazard vs an asset.

Re:What does First Normal Form mean? by whatshisface on Friday June 18, 2021 @12:22PM (#27551968)
Those "natural" databases as a rule are going to be full of duplicates and sometimes even inconsistencies, hence the need for IDs that only exist for the purpose of expressing relationships within your own database. Basically, pointers.
Re:What does First Normal Form mean? by CRConrad on Monday June 28, 2021 @03:25AM (#27658994)