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.
He did the exact same thing after taking over Twitter, talking about “poorly batched RPCs” in the timeline which makes zero sense because that’s obviously not how HTTP works.
The sad thing is Elon regularly shows how much of a very judgmental, “I’m so smart” idiot* he is, but somehow I keep meeting people who think he’s a genius. I guess the assumption that money=smart still holds true in the US, despite being disproven time and time again.
*Do we not have a single word for this concept? I come across this kind of person so frequently there really should be one.
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
deleted by creator
You guys are idiots, they use dbeaver and pgadmin not sql… Or maybe its Acess yes they use Acess
DROP TABLE Musk
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
They probably do use lots of NoSQL DBs too, which perform better for non relational “data lake” style architectures where you just wanna dump mountains of data as fast as possible into storage, to be perused later.
When you have cases where you have very very high volume of data in, but very low need to query it (but some potential need, just very low), nosql DBs excel
Stuff like census data where you just gotta legally store it for historical reasons, and very rarely some person will wanna query it for a study or something.
Keep in mind when I talk about low need to query, the opposite high need us on the scale of like, "this db gets queried multiple times per minute’
Stuff like… logins to a website, data that gets queried many times per minute or even second, then sometimes nosql DBs fall off.
Depends what is queried.
Super basic “lookup by ID” Stuff that operates as just a big ole KeyValuePair mapping ID -> Value? And thats all you gotta query?
NoSql is still the right tool for the job.
The moment any kind of
JOIN
enters the discussion though, chances are you actually wanna use sql nowSo you’re saying Relational DataBase Management Systems do really well as soon as Relations are involved?
Eyup, it’s intuitive overall but there’s just weirdly some people out there that are all or nothing, and don’t understand “right tool for the job” lol
And Structured Query Language is a handy language for querying structured data?
What’s funny is that Relational Databases in fact sucks when somewhat complex Relations are involved. Moment you step out the of the realm of Tabular data you’ll have very miserable time. Like good luck modeling and querying simple nested product catalog.
Graph databases are better choice for truly relational data
I wouldn’t even consider “per minute” frequently queried. Per millisecond for stock market shit
To nitpick, Census data is heavily queried. They use Oracle now, I believe.
Just so you know census data is very heavily queried. Everything from civil engineering to economics wants to look at that dataset every day.
Like I said, in the scale compared to actual high frequency data though, that’s still be infrequent.
High frequency DBs are on the scale of many queried per second
Even with tonnes of data scientists and engineers querying the data, that’s still in the scale of queries per minute, which is low frequency in the data world.
I wouldn’t put it past them to experience numbers in the per second realm, especially as new data posts and everyone is rushing to grab it.
Lol had never seen that before, but Jesus Christ that is a painful depiction of my life.
Everything uses SQL. The world fucking runs on SQL
(yes I know SQL isn’t something that you can “run” something on yadda yadda…)
As much as I hate to say Elon might be right… The problem is that critical parts of the US government run on systems older than his goon squad. There’s actual COBOL in use, right now today, by the US government.
https://www.gao.gov/blog/outdated-and-old-it-systems-slow-government-and-put-taxpayers-risk
If Elon could fix the actual problem without being a dick about it all, no one would have a problem with any of this.
You’d be shocked to hear that much the same is true of many or even MOST of the world’s largest companies.
Not shocked at all.
Source: Check list of ransomware attacks daily.
Tell that to the person who implemented Tetris in Postgresql.
Eh ECS is basically all about making
SELECT ... FROM bar, baz WHERE bar.id == baz.id
, joins on primary keys, as fast as possible and use it as often as possible. Games are real-time databases with gaudy user interfaces so it stands to reason that posgresql is a game with a bland user interface.That is bananas! The implementation details are worth a read. Plus, all the links to other bananas projects are great.
Maury determined that this was a lie.
There’s a white paper with the social security logo on it https://www.mysql.com/industry/government/
See, they want you to believe that SQL stands for Structured Query Language. But I know from our lord and savior Elon that it actually means Socialist Queer Liberals!
Is retard a bait/dog whistle word?
Used by the guy who did two Nazi salutes at the inauguration? It absolutely is
When Elon was in his early teens, that word was a common pejorative.
If you look at Elon and interpret his behavior as if he was 13, it all makes a lot more sense.
So his emotional growth was literally, uh… well… you know…
Held back by his environment.
I bet he thinks SQL = MS SQL Server. And nothing else in the front end.
He sure is loose with that r-word…
I’m sure he has an alternative, like tattooing it on the forearms of ‘undesirables’.
Too expensive. Just put this sticker of a lolipop on your shirt.
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.
I’d bet that the government is probably the largest user of SQL. Unless there are really old systems that predate SQL. I’d imagine they have shitloads of COBOL for example.
This sounds just like a former manager that thought nosql was the end all and that SQL had no place.
If course they developed their app that required frequent data migrations because they were in fact very dependent on all the records matching the latest schema.