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
286
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
 

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 1 year ago (3 children)

SELECT user FROM db WHERE age BETWEEN 25 AND 35;

Fuck your mongo

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

Mongo only pawn in scheme of life.

[–] [email protected] 6 points 1 year ago* (last edited 1 year 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.

[–] r_se_random 1 points 1 year ago* (last edited 1 year ago)

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