KillingTimeItself
@KillingTimeItself@lemmy.dbzer0.com
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 days ago:
yeah, that sounds about right, ok i think we’ve figured this one out now. lol
- Comment on How does this pic show that Elon Musk doesnt know SQL? 4 days ago:
… That’s what I said, you’d just update the row, i.e. replace the existing data, i.e. overwrite what’s already there
u were talking about not keeping historical data, which is one of the proposed reasons you would have “duplicate” entries, i was just clarifying that.
… I don’t think you understand how modern databases are designed
it’s my understanding that when it comes to storing data that it shouldn’t be possible to have two independent stores of the exact same thing, in two separate places, you could have duplicate data entries, but that’s irrelevant to the discussion of de-duplication aside from data consolidation. Which i don’t imagine is an intended usecase for a DB. Considering that you literally already have one identical entry. Of course you could simply make it non identical, that goes without saying.
Also, we’re talking about the DB used for the social security database, not fucking tigerbeetle.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 4 days ago:
On June 25, 2011, the Social Security Administration changed the SSN assignment process to “SSN randomization”,[36] which did the following:
The Social Security Administration does not reuse Social Security numbers. It has issued over 450 million since the start of the program, about 5.5 million per year. It says it has enough to last several generations without reuse and without changing the number of digits. www.ssa.gov/history/hfaq.html
evidently they must be doing something else on the backend for this to be working, assuming there are quite literally 100M numbers, which is going to be static due to math, obviously, but they clearly can’t be reassigning numbers to 3 people on average at any given time, without some sort of external mechanism.
There are approximately 420 million numbers available for assignment.
www.ssa.gov/employer/randomization.html
that certainly doesnt seem like it would support several generations, possibly at our current birth rate i suppose.
DDG AI bullshit tells me that there are a billion codes. marketplace.org/…/will-we-ever-run-out-of-social-… this article says it’s 1 billion
www.ssn-verify.com/how-many-ssns
this website also lists it as approximately 1 billion.
- Comment on Anon sets up a prank at school 4 days ago:
based IT admin
- Comment on Erasure 4 days ago:
evidently they still did, cognitive dissonance is a hell of a thing.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 4 days ago:
Also, elons remark is stupid as is. Im sure the row has a unique id, even if its just a rowid column.
even then, i wonder if there’s some sort of “row has function” that takes a hash of all the data in a single entry, and generates a universally unique hash of that entry, as a form of “global id”
- Comment on How does this pic show that Elon Musk doesnt know SQL? 4 days ago:
Well, there’s not always a benefit to keeping historical data. Sometimes you only want the most up-to-date information in a particular table or database, so you’d just update the row (replace). It depends on the use case of a given table.
in this case you would just overwrite the existing row, you wouldn’t use de-duplication because it would do the opposite of what you wanted in that case. Maybe even use historical backups or CoW to retain that kind of data.
Elon believes that each row in a table should be unique based on the SSN only, so a given SSN should appear only once with the person’s name and details on it. Yes, it’s an extremely dumb idea, but he’s a famously stupid person.
and naturally, he doesn’t know what the term “de-duplication” means. Definitionally, the actual identity of the person MUST be unique, otherwise you’re going to somehow return two rows, when you call one, which is functionally impossible given how a DB is designed.
- Comment on where?? 4 days ago:
i hate when people use vague blocks of time to refer to something that we know with 100% certainty.
“YOU WILL NOT BE AWAKE SOMEWHERE WITH THE PERIOD OF APPROXIMATELY 12 HOURS FROM NOW, DO NOT MISS YOUR CHANCE TO DO SOMETHING TODAY”
are we talking like, once every decade, once every two decades, once a century? I gotta have a reference frame here.
- Comment on Anon visits a bookstore 5 days ago:
i prefer my smut in the form of silly little games developed by silly little people on the internet who write silly little stories in their silly little games about silly little sexual adventures.
- Comment on Anon discovers a new diet 5 days ago:
My husband says if you push past that and eat (he bulked once) that your appetite adjusts and you get bigger and hungrier. But bodies generally want to sort of stay the size they are, so don’t signal “eat, dammit!” if you have funded it enough to maintain.
100% this, the body moves to maintain whatever you feed it, which to be fair, is probably externally influenced by the amount of work you output. One of the solutions to eating too much, is literally to just eat less. Of course, fat bulking is really weird, and getting rid of it is even weirder, that’s human biology for you.
- Comment on Anon is a veteran 5 days ago:
its a 4chan post, so it’s probably fake and gay
- Comment on Anon is a veteran 5 days ago:
yeah, you could jerk off to normal porn, thank god.
- Comment on Anon is a veteran 5 days ago:
Its just a regular job where you are trained to kill other people.
listen bro, animals kill animals all the time, animals fight over territory, the military is just a mechanized extension of that, idk what you want me to tell you, but this is literally just the natural consequence of the industrial revolution.
At least now we aren’t killing millions of people, only hundreds of thousands.
- Comment on Anon is a veteran 5 days ago:
im going to guess it probably wasnt a terrorist group
- Comment on Anon is a veteran 5 days ago:
you forgot the secret third option of DIY housing.
- Comment on Anon describes the micro-celeb pipeline 5 days ago:
i don’t think you could pay me to do it, i mean, realistically there is always a price, but that asexuality goes hard.
- Comment on Anon watches her boyfriend play videogames 5 days ago:
the problem that i have, is that i’d have to be good at it, and enjoy it to be capable of playing it for an extended period of time, i would probably fail darksouls instantly, because i suck at competitive combat, shits too stressful for me, but if you sat me in front of minecraft or factorio i could cook like a motherfucker. There are different types of challenges, some people like combat, some people like analytical, and some people (me) really fucking enjoy implementation challenges.
You definitely need a better litmus test i think.
- Comment on Anon watches her boyfriend play videogames 5 days ago:
some of us just need the fight our demons, it’s better that we fight virtual demons that don’t actually exist, instead of fighting real demons. It’s a healthy outlet.
something something, bashing my head against a concrete wall because neuron activation, something something.
- Comment on Anon sets up a prank at school 5 days ago:
probably just school management doing something correctly for once, and the IT guy being based.
- Comment on Erasure 5 days ago:
this isn’t cancel culture though, this is culling culture.
- Comment on Erasure 5 days ago:
maybe if you explain to him the cause of the great depression being isolationist economic policy hitting everyone really hard, meanwhile japan with its keynesian policy managed to do pretty well, even in the face of global economic downturn.
Some people find facts more reasonable, ironically, even if they will cognitively dissonant themselves from them.
- Comment on Erasure 5 days ago:
im pretty sure that’s the exact implication being made lol
- Comment on Erasure 5 days ago:
wait until everything gets a lot more expensive, and then ask him what happened lmao
- Comment on THE EARTH IS SPHERICAL, DIPSHITS 5 days ago:
TFE was a breaking point for the cult of the insane, it did some good, but they’re all clearly insane.
I hold fast with my position in extremist satire that anyone who thinks this way should simply be terminated for the good of our species, call it eugenics if you want, i call it culling the catastrophe. (again, this is satire)
- Comment on How does this pic show that Elon Musk doesnt know SQL? 5 days ago:
Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database
formally, changing the identity of someone would have a very explicit reason to keep a “duplicate” ssn entry, if purely for historical reasons for example. I’m sure there are a myriad of technical reasons to be doing this.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 5 days ago:
it seems that nobody really cares about the word retard anymore, it’s quite funny how it went from super common language, to being less common, to people just saying it again now.
I’m curious how many people actually consider the word a slur, and how many people even care these days.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 5 days ago:
it’s probably using some sort of proprietary home grown database, because it’s probably old enough that no database could support what they needed, could be wrong on that one, but it was my best guess.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 5 days ago:
i’ve heard conflicting reports on this, i have no idea to what degree this is true, but i would be cautious about making this statement unless you demonstrate it somehow.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 5 days ago:
TL;DR de-deuplication in that form is used to refer a technique where you reference two different pieces of data in the file system, with one single piece of data on the drive, the intention being to optimize file storage size, and minimize fragmentation.
You can imagine this would be very useful when taking backups for instance, we call this a “Copy on Write” approach, since generally it works by copying the existing file to a second reference point, where you can then add an edit on top of the original file, while retaining 100% of the original file size, and both copies of the file (its more complicated than this obviously, but you get the idea)
now just to be clear, if you did implement this into a DB, which you could do fairly trivially, this would change nothing about the DB operates, it wouldn’t remove “duplicates” it would only coalesce duplicate data into one single tree to optimize disk usage. I have no clue what elon thinks it does.
The problem here, as a non programmer, is that i don’t understand why you would ever de-duplicate a database. Maybe there’s a reason to do it, but i genuinely cannot think of a single instance where you would want to delete one entry, and replace it with a reference to another, or what elon is implying here (remove “duplicate” entries, however that’s supposed to work)
Elon doesn’t know what “de-duplication” is, and i don’t know why you would ever want that in a DB, seems like a really good way to explode everything,
- Comment on Thank god "shit" is censored 1 week ago:
yeah naw ur right, anon could never feel emotion.