this post was submitted on 26 Oct 2023
286 points (96.4% liked)

SQL - any and all

305 readers
1 users here now

For discussion about SQL and databases. All versions welcome.

founded 1 year ago
MODERATORS
[email protected]
286
SQL Dev learning MongoDB (lemmy.world)
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
50 comments fedilink hide all child comments
 

Jesus died at 33, so that can't get returned in the query response lol

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 3 points 1 year ago (2 children)

As a c# mssql developer I'm not familiar with json or mongodb but I don't get the meme. What's wrong with this syntax? It's readable and relatively concise. Is this a whoosh moment for me? What am I missing?

[–] [email protected] 12 points 1 year ago* (last edited 1 year ago) (1 children)

It's a mess compared to the equivalent SQL.

SELECT *
FROM users
WHERE age >= 25 AND age <= 30

I dislike SQL syntax more than most, and even I concede that SQL wins in this instance.

Edit: Not sure if this appears on all clients but the < in the code block is meant to be a less-than symbol.

[–] [email protected] 4 points 1 year ago

There is no way I would ever get the amount of brackets right on that.

[–] [email protected] 3 points 1 year ago

IMO it's just so clunky with what feels like way too many extraneous symbols. And that's just a very simple query, check out the equivalent of a join: https://stackoverflow.com/a/43653679

Granted, joining is not really what Mongo DB is for (that's the whole point of it being non-relational, after all). But even reaching deep into an object can get you into nesting hell very quickly.