The government doesn't use SQL
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.
Sounds like he got confused looking at a view of a join.
https://xcancel.com/elonmusk/status/1889062581848944961
thought the replies would be better. Some people deducted that it uses plain text.
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.
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.
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
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.
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.
Ok genuine question, what is the difference between a SQL database and a simple Excel spreadsheet?
Storage data structures. Database tables are designed for fast read/write. Excel is designed for fast simultaneous parallel computation.
To get a sense of what this looks like, you can read more about their data structures; Databases typically store data in what's called a "B Tree" and spreadsheets typically store as a format that can be easily converted into a "Directed Acyclic Graph" (although Excel lets you turn off the "acyclic" part if you allow circular references).
Although, with Excel specifically, there's probably not much difference since it has some database functionality now.
In the context of this tweet most important differences are:
SQL is a language for querying databases.
Most common used databases are relational databases. With relational databases you can setup, well, relations and constraints.
Imagine you have 2 tables (2 excel sheets) one with people, and one with home ownership. You can set the following constraint: (1) each person shows up only once in the people table. And the following relation: (2) every home owner must refer to an existing person in people table.
When modifying the table contents, the system checks if no constraints or relations are violated.
Excel, just like a badly designed relational databse, would, for example, have no problem with duplicate people, or home ownership referring to non-existant people.
I spent more than I'd like to admit wondering "what the fuck is a wel relation?!"
I get what you say but excel even the 98 version can do duplicate/missing data constraints.
A whole lot. Too much to cover in one post in any kind of detail.
A modern relational database management system (RDBMS) is a highly optimized beast. How it accesses storage is very carefully considered. It has a whole mini language for defining relations between data. There are tools for debugging specific queries to make them faster. They index data with tradeoffs between read and write speeds. There are sophisticated locking mechanisms so multiple users can read and write at the same time. They have transactions where many alterations can be packed up together and written efficiently at once. Those transactional alterations are atomic, meaning there are guarantees that all of them happen or none of them happen. The entire thing is based on set theory, and it has survived attacks by many other pretenders to the throne for decades.
And if you're using Oracle, you can get all that while paying a highly optimized pricing model set up by the best financial advisors Larry Ellison can find to maximize value extraction from your company.
SQL is a language used to manage and interact with most relational databases so it is used often to describe relational databases. There are many tables in a relational database, each is very much like an excel tab. The excel spreadsheet can have many tabs relating to each other. So kinda similar. However a relational database is better defined, more functions and forced relationships, and most important space efficenct. Excel takes probably 100-1000 times more space, and that is best case.
The amount of data, sql is designed to manage large datasets, millions of rows. Excel has its limits.
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.
True. Atleast Hammer knew his weapons and could sell them alone
He is like tony stark in a timeline where Tony stark decided to join the terrorists instead of building the suit to escape. Oh and in this timeline Tony Starks brain has been rotted away by ketamine
Yeah. That is Hammer
The worst kind of stupid doesn't need to learn about databases because it's just common sense.
Whenever Elon speaks of programming, he just spouts the most delusional Point-Haired Boss bullshit imaginable. Truly, he has been promoted to the level of his incompetence.
(It is also highly ironic considering the Dilbert creator's politics.)
Musk seems to think Musk is a tech genius, but really he was just born into money and used it to buy a bunch of companies. In fairness he was able to recognise which companies to buy, doesn't mean he knows anything about databases though.
In fairness he was able to recognise which companies to buy
I think this is just survivorship bias. There are millions of wealthy individuals investing in companies every single day. Occasionally these gambles pay off and make people extremely wealthy.
Most of the time the people who succeed just spend their incredibe wealth and live a quiet happy life.
But there are others who crave attention. These individuals bully their way into prestigious positions and pretend that they're leading the company.
Elon is that kind of person. He started wealthy, bet his money on companies that succeeded. Then took the CEO role so he would get credit for the companys' successes.
If ever people dare stop paying attention to him he'll do something drastic to recapture the spotlight on.
He's the kind of person who will stand on stage and do a nazi salute just because he wants you to look at him.
He also apparently watched a lot of SeaQuest DSV, and is trying to make it a reality. Hyperloop: SeaQuest. Electric cars: SeaQuest. Big car dashboard screens: SeaQuest. Magic Space Science: SeaQuest. CyberTruck....Apple Mouse ADB gen 1-ish wrapped in aluminum foil. I guess what I find most fascinating is that I have similar mental maladies to him, but I learned instead of just being perpetually dumb. It is actually disappointing that he chose to not learn and just ride the walrus instead. No idea why anyone worships him.
OT: You reminded me that i never watched seaquest more than a few episodes and i will have to do that now. does it still hold up for someone who loved TNG and Voyager?
As someone who does systems administration which includes numerous government owned database servers, this is news to me.
dis what you get for working with 19 year old kids with inflated egos whom you only hired to worship you. Also when someone who is not an expert in a field has the confidence to make grand claims about practices in that field, it is a very nice litmus paper telling you that person is generally bullshitting.
REAL GOVERNMENTS USE EXCEL SHEETS /j
Wasn't it the uk or something that messed up a vote due to excel's row limit?
I think it was something to do with COVID stats during the initial outbreak, but yes, yes it was the UK government and their bizarre love affair with stupid tech choices.
The only 'transparency' he's shown is screenshots of basic spreadsheets that don't actually clarify anything. His minions are just sending him spreadsheets extracted from systems they don't understand, and he's just making decisions based on whether the title of the program sounds woke or not.
It's going to be fun when he fucks with some Wall Street Equity fund's money.
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
Sure as hell did when I worked there
if this troglodyte says it doesn't you can be sure that it does.
That sounds surprising modern. That's good! Or at least I would think it is good. So many things run on mainframes still.
51 year old SQL sounding surprisingly modern for government tracks.
Oh, I'm calling it now. This one is going to be used as an attack of trans people. Throw out the archaic and manual process of updating names in federal databases, and keep it simple by making the records immutable. Then hit them with a lovely
"You MUST use your REAL NAME (MAIDEN NAME) on government forms. If the name does not match, you will be denied."
They already stopped providing passports to trans people, even if they're willing to use their old name and gender. And I'm sure that policy will end up hurting women that changed their name after marriage as well, it anyone that changed their name for whatever reason.
There are already attempts to make it so your name has to match your birth certificate in order to vote.
Targets both trans rights and women's rights, simultaneously.
I remember seeing this after he bought Twitter
Storms I hope that’s true.
I kind of doubt it. It's been known that he's a fraud of a coder for a while, that seems like a clear riff.
Enough that I was really disappointed when Some More News talked about Zip2 like he was the sole founder and therefore must have been good at coding at some point.
Btw, the guy he and his brother founded the company with died at 51.
As a megarich techie... With the dirt on Elon's real capabilities.
Interesting.
DROP TABLE Musk
Little Bobby tables, we call him
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...
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.
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.
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
All government data is processed using sed.
Still more efficient than DOGE.
lol. You mean vba macros.
Microsoft Access,
unironically.
I feel personally attacked right now.
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:
It's absolutely the second one. They basically all had brain damage from ww1 (who knew explosions are bad for you) and several of them including Hitler were drugged the fuck up. Julius Streicher was a clown, but not like a funny or sad clown, more like pathetic, like honestly comparable to someone from 8chan. Goebbels was a creepy loser. Hitler was a meth addict with ibs and anger issues who spent his last days just destroying the air quality of the bunker he would die in and kept invading countries despite already being at war. Heidrich died by personally chasing after antifascists who happened to have a grenade. And that's not touching on their archeological or spiritual beliefs which are on par with qanon for believability and sensibility
Yep, the actual competence was basically in the army (inherited from a long military tradition), so it's important that those generals don't cave.
Heidrich died by personally chasing after antifascists who happened to have a grenade.
That's a fucked up way to describe the assassination.
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.
The OG Nazis were actually bozos too, they just had very good propaganda. So good that you're still seeing the effects today.
They were more competent bozos. They ran Germany the way that your stupid friend gets laid more often because they aren’t smart enough to be embarrassed by themselves and they know only one goal.
Whereas these guys run America like an ugly stupid person that insists that no, actually, they have already in fact convinced you to sleep with them despite what your words say and the goal is to confuse you into bed.
Is it also a case of survivorship bias? Like, I am not super versed in Nazi history, but... There are famous "smart" Nazis like Goebbels and Himmler and Speer - are they only well known because a) they slowly emerged as influential and/or b) it became clear years later that they were the ones behind the wheel?
'Cause I do think that trump and musk are dumb as bricks, but I don't think Steve Bannon is, and there are probably others like him..
The nazis weren't as competent and intelligent as you suggest, that work was outsourced to IBM - Yes, that IBM.
You know that Watson product that IBM sells and advertises so often? R one that plays chess and was on jeopardy (Fun!) Turns out that Watson was the name of the dude that signed off on them accelerating the Holocaust for the nazis. Some believe the nazis couldn't have been nearly as efficient at unrepentant large scale murder without IBM joining the fray, yet they skate on by...
OG Nazis were looking for aryans in Tibet.
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.
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.
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.
I think some of the more intelligent US Nazis are letting the bozos do their thing and riding the coat-tails and avoiding direct blame if things turn. I'm looking at a good chunk of the House and Senate.
All 3 of those. Yes.
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.
Not every fascist and Nazi needed to be competent, intelligent, and put-together. Just enough of them. I suppose we'll find out in real-time if they have amassed sufficient numbers this go 'round.
The OG Nazis were actually bozos too.
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.
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.
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.
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).
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.
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.
The SSN is supposed to just be a number that you give your employers and the IRS so that your social security (the USs blanket retirement savings/pension system) contributions get logged correctly to you and then when you retire you can use that number to get the social security benefits that you paid into. The number has ended up being used for all sorts of things because the USA is slightly broken because it is SORT OF a unique ID number for each US citizen, except of course that it wasn't intended to be that, SSNs are only supposed to be used from first social security contribution (first paycheck) to last social security payout (death) so naturally they can just be recycled.
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
SSNs are not reissued after death and never have been. I've been seeing a lot of people comment this, but I'm not sure where they're getting it from. (They're not unique for other reasons, however.)
I'm hardly the king of databases, but always using a surrogate key (either an auto-incremented integet or a random uuid) has done me pretty well over the years. I had to engineer a combination of sequential timestamp with a hash extension as a key for one legacy system (keys had to be unique but mostly sequential), and an append-only log store would have been a better choice than an RDBMS, but sometimes you make it work with what you have.
Natural keys are almost always a bad idea though. SSNs aren't natural, which is one pitfall: implicitly relying on someone else's data practices by assuming their keys are natural. But also, nature is usually both more unique than you want (every snowflake is technically unique) and less than you'd hoped (all living things share quite a lot of DNA). Which means you end up relying on how good your taxonomy is for uniqueness. As opposed to surrogate keys, which you can assure the uniqueness of, by definition, for your needs.
Just curious, but if SSNs were not recycled after death, would there be any reason not to use them as a primary key?
(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
OP is talking about identity theft, not physically losing your card.
“Your tax dollars are being stolen”
Rare moment of clarity from our global barony.
Right for the wrong reasons.
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.
Database schema = "Not fraudulant", what's so hard about that? Login credentials don't even need to be encrypted if you say no fraud before you log in, and cross your fingers. It's basic programming knowledge, come on man. Also throw some salt over shoulder and slaughter a goat for good measure just in case.
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.
This guy Elons
The US government basically ONLY uses SQL…
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
His response to the 2018 Thai Cave rescue is what made me realize how big of a shit stain on society he is.
He's the Steven Segal of futurism
Now i Really want to see The Dipshit run.
😅
A government official known for performing a nazi salute just broadcast an ableist slur.
Cool cool cool
"Political appointee"
alien invader
Civilized people should really coopt the word "removed" to mean Republican. I mean, they have the (R) 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!"
Gotta keep play to the cheap seats, these clowns
btw do you know why it was decided to treat the r-word as an ableist slur? And why didn't they also make "idiot" a slur, since it has basically the same etymology? Is this a lemmy-specific thing? I've never seen anyone use or interpret the r-word as a slur outside of lemmy
In contemporary language, that word (among others) is almost entirely used as an insult by way of equating somebody's intelligence with those who have intellectual disabilities, which creates a negative connotation. Similarly, this is why we don't say things we dislike are "gay" anymore. It's disrespectful to the people who actually fall under the definition, and it proliferates negative associations with traits that people are stuck living with and had no choice in acquiring.
The only reason "idiot" hasn't followed suit is because it's much more culturally ingrained, and there's hasn't been as significant of an attempt to change it as with other words.
I've never seen anyone use or interpret the r-word as a slur outside of lemmy
It's not exclusive to Lemmy, but it is mostly left-leaning spaces or gen Z individuals who see it that way. Center and right-leaning spaces see treating the word as a slur to be censorship (as opposed to being respectful of others) and keep using it or actively push back by saying it more.
Not Lemmy specific. There was US legislation related to the word being deemed offensive fifteen years ago (given the slow nature of Congress, it wasn't a new sentiment then, either): https://en.m.wikipedia.org/wiki/Rosa%27s_Law
Fair enough that plenty of insulting words could be cast as abelist: but my guess is that a word like "idiot" is old enough that most folks called that in a medical context aren't around any more. Maybe I'm wrong though: plenty of folks do push against saying things like "crazy" in an insulting manner.
You must not be close to anyone that has any sort of mental illness. It's a very broad and hurtful term. It has been for a long time.
Edit. Found this online
https://www.spreadtheword.global/resource-archive/r-word-effects
As someone who has literally helped the government use SQL for over a decade, this is huge news.
SQL is not web-scale
Time to watch this gem again: https://youtu.be/b2F-DItXtZs
I cannot wait to cut off the testicles of a 3.000lb raging bull as it tries to kick my head in.
NoSQL is web-scale.
Maury determined that this was a lie.
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!
There's a white paper with the social security logo on it https://www.mysql.com/industry/government/
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 UPDATE without a WHERE clause 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.
Little Johnny Tables, the hero we didn't expect.
Oh I just curled up into a fetal ball at the thought of that...
Jesus Fucking Christ !!!
What does Elmo think the government use ? MongoDB, because its Web Scale 0?
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 now
To nitpick, Census data is heavily queried. They use Oracle now, I believe.
I wouldn't even consider "per minute" frequently queried. Per millisecond for stock market shit
Lol had never seen that before, but Jesus Christ that is a painful depiction of my life.
Musk doesn't understand database design (or the existence of PRIMARY KEY ()), surprise.
That's what he does. Not understand things.
More importantly, not understand things and then comment on them like he is the real shit
Now now, he also has LeAdErShIp skills like taking his incorrect understandings and making the ToUgH dEcIsIoNs and being DeCiSiVe and taking RiSkS that will in no way impact his lifestyle but could destroy the careers and lives of thousands to millions of other people.
SSNs are literally just handed out to hospitals and social security offices in batches and given out in sequential order. They were specifically and intentionally designed to be a terrible system of ID numbers because people actually used to care about their privacy. There are countless people who've gone their whole lives using the wrong social security number and gotten their benefits just fine, because unlike everyone else in this dumpster fire of a country the social security office has never been stupid enough to rely on just a single number.
Maybe Musk needs to learn about data normalization and natural keys.
I'm curious what the actual data looks like. I've spent quite a bit of time auditing large data systems.
I would expect these databases to be largely denormalized with very wide tables, I would expect them to favour natural keys like a SSNs, and built around per department use cases.
I would not expect them to be highly normalized because then when you need something from another department you need them to ensure consistency.
These systems probably have like 50 years of legacy code or more in them too.
I'm curious what the actual data looks like.
I'm sure it will be available for purchase shortly.
Maybe it’s all just one big .xlsm file?
with vlookups across multiple sheets to get around row limitations, that's just common sense in MyExcelDB
I could see it all being a big vendor specific XML file with XSLT for the application layer
Seemingly every interaction this man has with a normal person is him finding newer and more interesting ways of declaring himself an absolute moron.
How the fuck is he the de facto president of the USA?
Well, the president represents the people...
A lot of people decided not to vote this time. A lot of other people belived stupid shit their lighted rectangle told them.
Also that's not how deduplication works.
He means/thinks that SSN is not unique (which is not a problem, just different design).
Of course he's wrong about lots of stuff, just the nerd in me could not not explain it.
I imagine he’s looking at a payments table where there is a non-unique key to relate a citizen to each payment.
Yeah, I was thinking something similar. I'm not a DBA but it's the easiest way (that I can think of) to record all transactions for a certain user.
I've worked on projects for the government as a contractor. There is SQL; SQL as far as the eye can see. I'm sure the NSA has some novel solutions to crunching shittons of big data, but day to day, at least in my experience, it is a lot of relational CRUD and reporting queries.
For the curious, it does clearly exist:
https://docs.aws.amazon.com/govcloud-us/latest/UserGuide/govcloud-rds.html
You guys are idiots, they use dbeaver and pgadmin not sql.. Or maybe its Acess yes they use Acess
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.
Felon Musk is such a fucking moron lol
Is retard a bait/dog whistle word?
Used by the guy who did two Nazi salutes at the inauguration? It absolutely is
He is the embodiment of big-money trolling in politics, right?
What is that a database is not de-duplicated?
