this post was submitted on 11 Feb 2025
1264 points (98.6% liked)

Programmer Humor

20460 readers
1193 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.

(page 6) 50 comments
sorted by: hot top controversial new old
[–] Midnitte@beehaw.org 51 points 1 day ago

Musk doesn't understand database design (or the existence of PRIMARY KEY ()), surprise.

[–] RangerJosey@lemmy.ml 43 points 1 day ago (2 children)

That's what he does. Not understand things.

load more comments (2 replies)
[–] wise_pancake@lemmy.ca 36 points 1 day ago* (last edited 1 day ago) (1 children)

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.

load more comments (1 replies)
[–] yozul@beehaw.org 34 points 1 day ago

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.

[–] magic_lobster_party@fedia.io 29 points 1 day ago (14 children)

Maybe it’s all just one big .xlsm file?

load more comments (14 replies)
load more comments
view more: ‹ prev next ›