Welcome to Programmer Humor!
This is a place where you can post jokes, memes, humor, etc. related to programming!
For sharing awful code theres also Programming Horror.
See the post on BlueSky: https://bsky.app/profile/provisionalidea.bsky.social/post/3lhujtm2qkc2i
According to many comments, the US government DOES use SQL, and Musk is not understanding much what's going on.
That man will be doing to same thing to important shit right now.
When Elon bought Twitter, I realised right away I'd need to close my account.
What made me hurry up exporting my data and closing the account were the reports of Elon Musk personally fucking with the systems, and the subsequent glitches and outages. Had to get it done while the site was still moderately functional.
And they just let this guy get his hands on actually important national computer infrastructure? Fucking hell.
Sounds like he got confused looking at a view of a join.
SELECT holder_name, amount
FROM account JOIN transaction ON transaction.account_id=account.id;
-- WTF!! THERE'S DUPLICATES!!!
Not even that complicated - SSN are not unique, by design. The combination of SSN and name is supposed to be, but for most of the history of the program no one was actually checking for that so it really isn't either. Until something like 2014 the first 5 digits of your SSN were basically a code for where you were born and the last 4 were just assigned in order.
He got community-noted for being wrong. Per usual, it's only a matter of time before he deletes his post.
More likely, he'll delete the community note
More likely, he'll delete the database.
Shit, I'd love for him to delete the twitter databases
If SSN based fraud is the program then let's establish an actual federal identification number. Even the Social Services bureau tried to get everyone to not use it as the end all source of truth. They only created it for social security benefits, literally only that purpose.
They should just publish every SSN at once with names. That'll make them useless as "secret" numbers and useful as identifiers.
In college, early 90s, our student IDs had our photo and SSN on it
I've operated ever since under rhe assumption anyone and everyone has access to it.
Then with all the data breaches over the last 10/15 years? Freeze credit reports with the 3 reporting agencies for free. Check for extra accounts with the free annual credit report pulls.
For all practical purposes, our SSNs are easily obtained by someone who wants it.
I'm not sure what the solution is, but a unique identifier has to be housed somewhere where in can be accessed in a format humans can read, which means it can be accessed and dumped so it's no longer private or secret.
I'm not a fan of biometrics, and I tolerate 2FA. I really think it's more important we change how we think about and use personal, unique, identifiers (like SSNs)
Any lawyer, law firm employee, private investigator, insurance adjuster, or credit industry can get it easily. I operate under the same presumption.
It's hard to figure out what he's talking about , when he says the "whole social security database". Like in which tables are they duplicated? Does it mean the entire row is duplicated or just the SSN, it might make sense to be duplicated depending on the schema. Is it an append only db, so there might be updated columns on the same ssn and you need to filter by the latest update timestamp? Who knows.
But also, saying that there's a "social security database" and then following that up by the govt "doesn't use SQL" so.. the db is actually just a spreadsheet? A .txt file? The SSNs are just written down in someone's notebook? Lol
He seems to be one of those people that think nosql should be used everywhere.
SSNs are reused. Someone dies and their number gets reassigned. The database could easily be keeping track of all previous assignments for any given SSN.
Remember, SSNs are designed for social security and nothing else. They got picked up as a unique ID by private interests as a hack. They were never supposed to be as widespread in use as they are. The federal government using it this way is the specific, designed use case.
Yep, and any attempt to replace them with a purpose designed government ID has gotten conspiracy nuts to shut it down
It’s LotusNotes all the way down
Or mongoDB 🙄
Probably something bespoke/legacy.
Have you met out lord and saviour COBOL?
Of course. Everyone who's ever used a DB knows it's BS. As long as the data is structured - which it a) is because he was able to make assertions about it and b) fucking Excel files are enough - it CAN be imported and SQL'd on. Even Excel has built in support for fuck's sake, not to mention Python and PowerQuery.
The dude is a self-certified moron - he probably struggles with the concept of PKI, too.
He was baffled a building he was opening had a water use plan. You know. That thing everyone who's built a building larger than a shed has to deal with.
https://xcancel.com/elonmusk/status/1889062581848944961
thought the replies would be better. Some people deducted that it uses plain text.
He used to be regarded as tony stark. Nah he is Justin Hammer. Steals ideas implements them shit and has no idea about anything
I get your point but I disagree. I think both Tony Stark and Justin Hammer are more competent than Elon.
Hammer was no where near as good as Tony but he did make some good stuff.
I would say he’s more like Obadiah Stane, an opportunist taking credit for others work.