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

Programmer Humor

20866 readers
1815 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] 100 points 2 weeks ago (15 children)

Jesus Fucking Christ !!!

What does Elmo think the government use ? MongoDB, because its Web Scale [0]?

[0] https://www.youtube.com/watch?v=b2F-DItXtZs

[–] pixxelkick 27 points 2 weeks ago (9 children)

They probably do use lots of NoSQL DBs too, which perform better for non relational "data lake" style architectures where you just wanna dump mountains of data as fast as possible into storage, to be perused later.

When you have cases where you have very very high volume of data in, but very low need to query it (but some potential need, just very low), nosql DBs excel

Stuff like census data where you just gotta legally store it for historical reasons, and very rarely some person will wanna query it for a study or something.

Keep in mind when I talk about low need to query, the opposite high need us on the scale of like, "this db gets queried multiple times per minute'

Stuff like... logins to a website, data that gets queried many times per minute or even second, then sometimes nosql DBs fall off.

Depends what is queried.

Super basic "lookup by ID" Stuff that operates as just a big ole KeyValuePair mapping ID -> Value? And thats all you gotta query?

NoSql is still the right tool for the job.

The moment any kind of JOIN enters the discussion though, chances are you actually wanna use sql now

[–] [email protected] 28 points 2 weeks ago (3 children)

So you're saying Relational DataBase Management Systems do really well as soon as Relations are involved?

[–] pixxelkick 1 points 2 weeks ago

Eyup, it's intuitive overall but there's just weirdly some people out there that are all or nothing, and don't understand "right tool for the job" lol

load more comments (2 replies)
load more comments (7 replies)
load more comments (12 replies)