this post was submitted on 11 Feb 2025
1005 points (98.8% liked)

Programmer Humor

20039 readers
3016 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
 

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 are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 32 points 3 hours ago (3 children)

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

[–] [email protected] 14 points 2 hours ago (1 children)

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.

[–] captainlezbian 3 points 1 hour ago

Yep, and any attempt to replace them with a purpose designed government ID has gotten conspiracy nuts to shut it down

[–] some_designer_dude 6 points 2 hours ago

It’s LotusNotes all the way down

[–] [email protected] 7 points 3 hours ago

Or mongoDB 🙄

Probably something bespoke/legacy.