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

SQL - any and all

306 readers
1 users here now

For discussion about SQL and databases. All versions welcome.

founded 1 year ago
MODERATORS
shertson
285
SQL Dev learning MongoDB (lemmy.world)
submitted 1 year ago* (last edited 1 year ago) by DeadNinja to c/sql
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
[–] Theharpyeagle 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.