News for hackers. Stuff that matters.
Re:Unnatural Keys – Nature doesn’t come with identifiers by c00lio on Sunday May 28, 2023 @06:34AM (#36102847)
But then you'd miss on crystal structure to distinguish your diamonds from your coal.
Re:Unnatural Keys – Nature doesn’t come with identifiers by OJFord on Sunday May 28, 2023 @11:38AM (#36104988)
Which single element are they then?

Surely such a system would have a products table with something like nominal element fk, purity, mass columns anyway. (And stock table with fk to products.)

Then nothing wrong with 'natural' key on the elements, but sure, products are the thing you've (personally) made up, so of course there's no 'someone else's' key to use.

Re:Unnatural Keys – Nature doesn’t come with identifiers by TRiG_Ireland on Sunday May 28, 2023 @04:10PM (#36107308)
Diamonds and coal are both pure carbon (mostly carbon-12). So is graphite, and buckminsterfullerene, and a number of other things. Crystal structure matters a lot.
Re:Unnatural Keys – Nature doesn’t come with identifiers by OJFord on Sunday May 28, 2023 @04:48PM (#36107649)
They're not pure carbon was my point. I wasn't saying crystal structure not important, I missed that but it'd be in my 'product derived from element x' table.