this post was submitted on 26 Oct 2023
285 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
shertson
285
SQL Dev learning MongoDB (lemmy.world)
submitted 11 months ago* (last edited 11 months 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
[–] [email protected] 61 points 11 months ago (3 children)

SELECT user FROM db WHERE age BETWEEN 25 AND 35;

Fuck your mongo

[–] [email protected] 22 points 11 months ago

Mongo only pawn in scheme of life.

[–] [email protected] 6 points 11 months ago* (last edited 11 months ago) (1 children)

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.

[–] [email protected] 1 points 11 months ago* (last edited 11 months ago)

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