Yeah, I’m glad most stopped.

I like to share excerpts from Lemmy with my incredibly right-wing family (hopefully to chip away at their staunch beliefs) and its SOOO much easier to share articles/comments when I don’t need to re-write them to exclude all Drumpf mentions. (Those mentions of course cause the person I’m trying to influence to immediately shut down and not read the rest of what I said)

True, but not much of a shower thought?

Thanks for genuine response. Lol, most who interpret my question that way you did don’t seem interested in a good faith discussion. But ol’ boy is def tripping if he thinks SQL isn’t used in the government.

Big thing I’m intending to pry at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the First Bro doesn’t understand how SQL works).

Yeah, obviously ol’ boy is tripping if he thinks SQL isn’t used in the government.

Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the First Bro doesn’t understand how SQL works).

Yeah, obviously ol’ boy is tripping if he thinks SQL isn’t used in the government.

Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the First Bro doesn’t understand how SQL works).

had to join to it

I don’t think I get what this means. As you describe it, that reference id sounds comparable to a pointer, and so there should be a quick look up when you need to de-reference it, but that hardly seems like a “dependency knot”?

I feel like this is showing my own ignorance on the back end if databasing. Can you point me to references that explain this better?

Yeah, obviously ol’ boy is tripping if he thinks SQL isn’t used in the government.

Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the First Bro doesn’t understand how SQL works).

Yeah, obviously ol’ boy is tripping if he thinks SQL isn’t used in the government.

Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the First Bro doesn’t understand how SQL works).

Yeah, obviously ol’ boy is tripping if he thinks SQL isn’t used in the government.

Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the First Bro doesn’t understand how SQL works).

Right. Fingers crossed we figure out national IDs before then.

In responding to other comments, I’ve found similar things.

All the same, thanks for the resources!

Was trying to find something from the SSA itself on the topic, but didn’t turn anything useful up on the quick.

Here is a link for the lazy on the topic: https://www.nbcnews.com/technolog/odds-someone-else-has-your-ssn-one-7-6C10406347

Said this elsewhere, but wanted to be sure you had the chance to see the linked material. The Social Security FAQ page (Q 20, specifically) says that they do not do re-use of old SSNs when people die.

I don’t want to come off as a bot spamming this in a bunch of different comment threads, but The Social Security FAQ page (Q 20, specifically) says that they do not do re-use of old SSNs when people die.

The Social Security FAQ page (Q 20, specifically) says that they do not do re-use of old SSNs when people die.

Naw, I definitely meant to be asking about duplication of data in databases (vs if the government actually uses SQL).

Sorry to have communicated that so poorly. Everyone seems to be taking the angle you’re arguing though. Guess I’ll need to work on that.

Ugh, YES, I am so frustrated at the counter arguments for this that I constantly hear spouted by my (ultra-conservative) family.

I hope that notion re-enters the public consciousness as a part of this (not holding my breath tho)

Hmmm, well I can’t speak to how the actual databases are put together, so maybe they would have that as two separate unique primary keys with a duplicated SSN.

But it really seems like bad design if they out it together that way…

Yeah, obviously ol’ boy is tripping if he thinks SQL isn’t used in the government.

Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the First Bro doesn’t understand how SQL works).

Yeah, obviously ol’ boy is tripping if he thinks SQL isn’t used in the government.

Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the Vice Bro doesn’t understand how SQL works).

I’m not aware of any instance where two people share an SSN though. The Social Security Administration even goes as far as to say they don’t recycle the SSNs of dead people (its linked a couple times in other comments and Voyager doesn’t let me save drafts of comments, I’ll make an edit to this comment with that link for you).

Can you point me to somewhere showing multiple people can share an SSN?

Edit: as promised: The Social Security FAQ page