Comment on How does this pic show that Elon Musk doesnt know SQL?
pixxelkick@lemmy.world 1 week agoOkay but if that happens, musk is right that that’s a bit of a denormalization issue that mayne needs resolving.
SSNs should be stored as strings without any hyphen or additional markup, nothing else.
- Storing as a number can cause issues if you ever wanna support trailing zeros
- any “styling” like hyphens should be handled by a consuming front end system, you want only the important data in the DB to maximize query times
It’s more likely though it’s just a composite key…
spankmonkey@lemmy.world 1 week ago
This is not what he is actively doing though. He isn’t trying to improve databases.
He is tearing down entire departments and agencies and using shit like this to justify it.
pixxelkick@lemmy.world 1 week ago
Sure but my point is, if it was the scenario you described, then Elon would be talking about the right kind of denormalization problem.
Denormalization due to multiple different storing their own copies if the same data, in different formats worse yet, would actually be the kind if problem he’s tweeting about.
As opposed to a composite key on one table which means him being an ultracrepidarian, as usual.
spankmonkey@lemmy.world 1 week ago
Musk canceled the support for the long running Common Educstion Data Standards (CEDS) which is an initiative to promote better database standards and normalization for the states to address this kind of thing.
It does not fucking matter if he is technically correct about one tiny detail because he is only using to to destroy, not to improve efficiency.
pixxelkick@lemmy.world 1 week ago
I mean it matters here, as it’s literally the topic being actively discussed by the person who literally asked, so obviously it matters to them lol