Programmer Humor

20487 readers

783 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

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 2 years ago

MODERATORS

[email protected]

1262

The government doesn't use SQL (programming.dev)

submitted 2 days ago by [email protected] to c/[email protected]

432 comments fedilink hide all child comments

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] 1 points 1 day ago

Many things. I mean, you could hack a lot of stuff into Excel but generally

SQL has foreign keys and integrity checks. You can make it so like if you delete a user it automatically cascades to delete other rows like their addresses.

You can prevent someone from entering the wrong type of data in particular columns. This one's an integer and that one's text.

It's designed to work on larger scales. Excel stops at 1 million rows per spreadsheet, unless my search just gave me AI slop.

You can do queries, for selecting as well as updating and deleting. You can join tables.

It's much easier for other applications (such as a website) to talk to a SQL database

You can do transactions.

There's a lot. That's just off the top of my head.