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.
You must log in or register to comment.
It’s going to be so expensive to fix all the damage this government is doing when America next has sensible government
So many skills lost, so many systems broken
Isn’t it a payments database? One client could have multiple payments. You wouldn’t expect client IDs to be unique
That’s weird, I thought I used SQL databases from government agencies regularly. Guess I was mistaken.
If you and Elon disagree about something, just assume he’s wrong about it. If you both agree on something, THEN you might be mistaken.
Indeed. I’m starting to think I can’t trust what that Musk guy says.
This guy Elons
Removed by mod
Elon’s shock and fury about the database key sounds like he got a report from an out-of-breath 20 year old DOGE kid who thinks they’re hot shit and discovered some massive flaw.
Elon also seems like the kind of person that believes a database schema is all that’s needed to govern a population.
He’s mad because it isn’t blockchain
Goddammit, now you’re giving him ideas.
2027 Bingo Card: US adopts BTC as reserve currency, replaces USD, both crash.
BTC? No way, that’s way too sane. It’s going to be DOGE.
Nah it’ll be Trump Coin. Gotta own the grift from the top down
He already wants to replace everything in the US with Blockchain and Crypto scam shit doesn’t he?
Did you want to trust a central authority for your Social Security? It’ll get censored! /s
I wouldn’t be giving him any ideas unless I founded a company and he bought his way in
I’m sure folks on here know this, but you know, there’s also that 10K a day that don’t so…
What makes this especially funny, to me, is that SSN is the literal text book example (when I was in school anyway) of a “natural” key that you absolutely should never use as a primary key. It is often the representative example of the kinds of data that seems like it’d make a good key but will absolutely fuck you over if you do.
SSN is not unique to a person.
They get reused after death, and a person can have more than one in their lifetime (if your id is stolen and you arduously go about getting a new one).Edit: (See responses) It seems I’m misinformed about SSNs, apologies. I have heard from numerous sources that they are not unique to a person, but the specifics of how it happens are unknown to me.And they’re protected information due to all the financials that rely on them, so you don’t really want to store them at all (unless you’re the SSA, who would have guessed that’d ever come up though!?)
It’s so stupid that it would be hilarious if people weren’t dying.
Small correction to an otherwise great explanation: SSNs are not recycled after death.
**Q20: *Are Social Security numbers reused after a person dies?*****A: No. We do not reassign a Social Security number (SSN) after the number holder’s death. Even though we have issued over 453 million SSNs so far, and we assign about 5 and one-half million new numbers a year, the current numbering system will provide us with enough new numbers for several generations into the future with no changes in the numbering system.
“Several generations” well that is fucking garbage
Nah. It’s worked for 50 years and if we get another 30 then it’s done its job well. Government is supposed to review and adjust things as time goes on and Social Security Numbers weren’t intended to uniquely identify citizens. They probably expected an overhaul to be done by 2020.
They fact that we haven’t reworked portions of it and rely on SSNs to identify citizens shows that we haven’t had a forward-thinking Congress in the last 20 years at minimum.
The entire number is garbage. Change the last digit and you have randomly guessed a perfectly valid SSN.
Less secure than a gift card
Well, it’s an identifier, your problem if that you have been using it as some kind of access key
You can guess a phone number as well by changing the last number, but that information has 0 value unless it is coupled with other informations.
You can reverse engineer a good bit of an SSN if you just have someone’s birth date and where they were born.
I am not sure if you are agreeing with me or not, but DOB and location where you were born are additional informations as I mentioned in my replie before.
Oh yeah I agree that just getting a SSN is not a big issue itself but the fact that you can reverse engineer it from known information makes it not a very good security measure to prove identity.
So they’ve issued almost half the possible numbers, current US population is actively using 1/3rd of them. I think unless there is a major drop in birth rates “several generations” is two. Either my great grandkids will be reusing dead people SSNs or there will be 10 digit numbers which is going to be a problem for any systems that coded it as char(9).
Ongoing trends would indicate a significant drop in birth rate is extremely likely. Major cities will most likely be facing population shrinkage by the end of the century
Thanks for (starting to) explain this concept to people not accustomed to how the US does their shit.
See, where i live, we used to have for example a Tax-Number. That was a thing the taxdepartment used to identify a person. But if you move from city a to city b, that numbers changes. So if you move a lot, you will have numerous of these.
Now, some 15 years back, the Tax-ID was introduced (fellow residents at this point will lnow it might be Germany) and this number is a one-in-a-kind ID that will only be assigned to you. They create it shortly after birth. My sons first registraion ID was this, before anyrhing else. You will also get a uniqie healthcare-ID that also works like that.So…how does that work in the US and why is habing a changing number that is not unique helpful? Or what is Elon not getting? I dont get it either because I dont know how this works for you.
Thanks in advance to shed light on this.
When you die your social is reused and assigned to someone else eventually. This is what makes it not unique. If something were to screw up in the process the new person could have debt from the prior person for example even though it is not their debt. Another concept common is using the last 4. There are so many conflicts when using just last 4 in a database its bad design.
https://youtu.be/Erp8IAUouus explains it pretty well
Came here looking for Grey, was not disappointed.
Thank you!
I don’t know all the ways but my identity was stolen and I never knew until my attorney was looking at something else for me in conjunction with the social security commission where I lived, and it popped up under a different name. They then accessed my records using other information, and it was the same number. It took a long time to get it sorted. A few years.
It’s supposed to be unique and might actually be now, but there are def duplicate ssns out there. Craziest identity situation I was told by a project manager of government system that is all about identities. Same First, Same last,same Date of Birth, same SSN; different people.
Weird story, and I have to assume this is data entry error, identity theft, or something else: I couldn’t sign up for a hospital billing platform because my name and full birthdate (including year) conflicted with someone else in the system. I called the hospital billing department and they were very confused about the whole situation. It didn’t really get resolved, and I basically had to let it go to collections so that I could pay because of the shitty system. I don’t have a very common name, and never have had this problem before.
(if your id is stolen and you arduously go about getting a new one)
I thought I had lost mine once and got a new SSN card, they don’t give you a new number, it’s the same number
You know, the thing that always seemed really scary about the OG Nazis is that they were competent, intelligent, put-together people that were just fucking evil. Then you look at the US Nazis and the fucking bozo density is off the charts, but they seem to be succeeding anyway.
Three possibilities come to mind:
- These bozos are going to find out, hard and soon.
- The OG Nazis were actually bozos too.
- Competence and intelligence doesn’t actually matter in running a fascist regime
The OG Nazis were actually bozos too, they just had very good propaganda. So good that you’re still seeing the effects today.
The high leadership were absolute bozos, except for their propaganda guy (Goebel?). And at the lower levels, they had good engineering (still do). Thankfully the higher ups were more interested in building an über-weapon (because that’s good propaganda) than actually winning the war.
Let’s hope the current crop of nazis se their downfall faster. Actually, fuck hope. Let’s make them.
the OG Nazis were dumb as bricks lmao. Weird nerds with massive egos half of which believed in magic.
Hitler and Himmler believed in “World Ice Theory” which was put forth by some German crackpot who stated the base matter of all reality was ice.
Every German person I’ve ever met talks so confidently about shit that you just kinda assume they know what they’re talking about, until they start talking about a domain you’re an expert in and you realize they’re actually kinda dumb but with good vocabulary.
Oh, Redditors. That explains ich_iels popularity per capita.
OG Nazis were looking for aryans in Tibet.
Hopefully all 3 but as the other poster said, Nazis really were clowns.
Sure, Hitler had some early successes militarily - combined arms blitzkrieg was a new deal and effective - but it’s not like that won the war. Besides which there is just so much dumbass occult bullshit going on in the background with the Nazis like you would not believe.
You don’t need to be smart or super competent to get a bunch of people killed. You just need enough people willing to pull the triggers and for the rest of the people to go along. Going along is easy until it ends with shit like the Holocaust.
Going along is easy until it ends with shit like the Holocaust.
Have you seen the reactions every time someone suggests it’d be nice if Israel stopped shooting people and taking their land? We’re pro-genocide now.
OG Nazis were master manipulators, dressed cool as fuck and their propaganda machine was one of the best ever. Intelligent? There is no hard evidence of that, and their military strategies were poorly thought. They had fucking cool weapons and equipment, so maybe good engineers were involved, but that’s it.
Just look at the military decisions Hitler made, that was luckily an incompetent guy thinking he’s smarter than everyone else. That rings a bell, doesn’t it?
In the long run, making less stupid decisions wouldn’t most likely have changed the outcome, but even more people would likely have died (and unfortunately the people executing the murder of the Jews weren’t as incompetent as their glorious leader).
A lot of behaviour in politics is emotionally driven, and sustained by the lazyness of voters not learning how the system they live in works.
If anything, I think this requires more emotional intelligence and perhaps acting skills.
OG Nazis were bozos. They advanced people based on the shape of their face. How exactly do you think that would turn out in the long run?
Here’s Lazerpig dissecting the myth of Michael Wittmann for example.
All 3 of those. Yes.
Elon is basically what a dumb kid thinks smart people sound like
Replace “dumb kid” with half dozen of my boomer relatives, and you’re spot-on.
and the dumb kids, unfortunately. I did a spot with some non-US teenagers, in a class recently. The topic was “name a person you admire and why”. Guess whose filthy name came up…
Elon starting to comment on technical matters was the moment I learned he was actually completely beyond incompetent, since I have some actual expertise on the subject. Right around the time he bought Twitter and commented publicly on its architecture.
This is further evidence to that point
He’s the Steven Segal of futurism
Now i Really want to see The Dipshit run.
Calling someone a retard for believing something that’s obviously true is straight out of the flat-Earther playbook.
Also everyone who criticized his Nazi salute is ableist. /s
And therefore Lemmy.World would like to give them a chance to speak their mind!:-P
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
Jesus Fucking Christ !!!
What does Elmo think the government use ? MongoDB, because its Web Scale [0]?
Ah, a classic watch. :-)
Elon probably thinks that SQL is MS SQL Sever, MySQL, or some such.
Elon probably thinks
Not really sure he does, I think he’s clearly paying others to do that for him
My bad, I forgot he doesn’t have time to think.
Too busy being one of the best players at Path of Exile 2. Despite that he doesn’t identify the valuable loot. Or how to use the map. Or how levels work. But he’s top 50! All very believable.
He’s clearly not paying enough then
Lol had never seen that before, but Jesus Christ that is a painful depiction of my life.
Lmao we’re gonna get to watch eel-on-musk and all of his dipshit wünderkinds speedrun through all of the pitfalls a junior DBA / data engineer is liable to make, and they’re gonna do it on prod, and prod is the US government.
What could possibly go wrong
He’s going to dedupe the social security databases, thinking that he’s screwing over trans people because he thinks they are the only people who change their names… not realizing that the vast majority of married women have at least two names associated with their SSN.
Either a DELETE FROM or a DROP DATABASE if I had to guess
An
UPDATEwithout aWHEREclause that doesn’t get noticed for a week or two. Your data’s hosed and you can’t really cope with reverting to your last known good backup. Bonus points if you haven’t tested your recovery procedures recently. Then he runs around screeching about how the data is obviously fraudulent and he’s a genius for finding it.
A government official known for performing a nazi salute just broadcast an ableist slur.
Cool cool cool
“Political appointee”
Civilized people should really coopt the word “removed” to mean Republican. I mean, they have the ® next to their names to remind us already.
Then when someone takes offense you can just say
Jesus Titty-Fucking Christ, Carol. Just because someone has a mental disability doesn’t make them a Republican!"
Way to throw disabled people under the bus because you aren’t clever enough to find another way to insult their intelligence.
Also using the phrase “civilized people” makes you sound like you’d fit in with the other Republicans.
Jesus Titty-Fucking Christ, Carol. Just because someone has a mental disability doesn’t make them a Republican.
“Your tax dollars are being stolen”
Rare moment of clarity from our global barony.
Right for the wrong reasons.
Isn’t Oracle a big government supplier with millions if not billions worth of contracts?
Elon is a fraud but for someone who claims he created one of the Web’s first e-commerce sites this level of ignorance is embarrassing
He paid some people to pretend he’s the founder, then used that title to build a reputation of being genius and what not. And he’s been getting rich off of investor capitol ever since.
I don’t know which company he did and didn’t start himself. But I know he definitely didn’t write the code behind ebay or paypal
