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

  • Curdie@lemmy.world
    link
    fedilink
    arrow-up
    4
    arrow-down
    1
    ·
    1 year ago

    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?

    • Pyro@lemmy.world
      link
      fedilink
      English
      arrow-up
      12
      ·
      edit-2
      1 year ago

      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.

    • TheHarpyEagle@lemmy.world
      link
      fedilink
      arrow-up
      3
      ·
      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.