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

6 points

THIS IS WHY YOU NEVER WRITE YOUR ENTIRE QUERY IN A SINGLE LINE

permalink
report
reply
1 point
*
Deleted by creator
permalink
report
parent
reply
3 points

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?

permalink
report
reply
13 points
*

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.

permalink
report
parent
reply
5 points

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

permalink
report
parent
reply
4 points

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.

permalink
report
parent
reply
3 points

I’m unfamiliar with the last comic where Jesus Christ is said. Does it mean he is happy with the result or can’t bear to look at the result?

permalink
report
reply
25 points

The OG comic was a guy talking to a baby, saying “Hey little guy, how’s it going?” and the baby replies with gibberish. The third panel indicates a pause, and then the guy responds in the fourth panel with “yea” (which is supposed to be “yeah” and not the archaic affirmation that rhymes with “nay”). It’s like he doesn’t even know what he expected when he asked the question, and is just accepting the awkwardness and confusion.

The “Jesus Christ” variant seems to imply the stunning horror of whatever the guy sees in the second panel.

permalink
report
parent
reply
6 points

He is horrified

permalink
report
parent
reply
5 points
8 points

I’m going to laugh at this all day

permalink
report
reply
62 points

SELECT user FROM db WHERE age BETWEEN 25 AND 35;

Fuck your mongo

permalink
report
reply
9 points

AGGRESSIVE LANGUAGE

permalink
report
parent
reply
12 points

I DO NOT SEE ANYTHING WRONG WITH THE PREVIOUS COMMENT, JUST A NORMAL HUMAN TALKING LIKE ME.

permalink
report
parent
reply
6 points
*

We just got a ticket in, our users need several new fields in the user table

Relational virgin:

NNNNNOOOOOO I’ll need this sprint to modify the user table and write the etl script

NoSQL Chad:

private String newField1;

private boolean newField2;

private Object newField3;

//And now, I close the ticket and go get lunch beers.

permalink
report
parent
reply
1 point
*

You do know that a large majority of SQL flavours support JSON columns?

permalink
report
parent
reply
22 points

Mongo only pawn in scheme of life.

permalink
report
parent
reply

SQL - any and all

!sql@lemmy.world

Create post

For discussion about SQL and databases. All versions welcome.

  • MSSQL
  • PostgreSQL
  • MariaDB
  • SQLite
  • etc…

Community stats

  • 1

    Monthly active users

  • 13

    Posts

  • 55

    Comments

Community moderators