833

JSON Query Language (programming.dev)

submitted 1 month ago by JPDev@programming.dev to c/programmer_humor@programming.dev

48 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[-] jaybone@lemmy.world 37 points 1 month ago

Both Oracle and Postgres have pretty good support for json in SQL.

[-] where_am_i@sh.itjust.works 17 points 1 month ago

and the plane in the picture is perfectly capable of transporting a plane. What's your point?

[-] xmunk@sh.itjust.works 19 points 1 month ago

JSON in the DB isn't an antipattern. It is frequently used in absolutely terrible designs but it is not itself a bad thing.

I'm a data architect and I approve this message.

[-] meliaesc@lemmy.world -1 points 1 month ago

Why not use nosql if your important data is stored in JSON? You can still do all your fancy little joins and whatnot.

[-] frezik@midwest.social 4 points 1 month ago

Turn it inside out. Why not use a RDBMS with a NoSQL bit added on the side?

[-] xmunk@sh.itjust.works 3 points 1 month ago

Specifically so you get mature transactional guarantees, indices and constraints that let app developers trust your db.

load more comments (4 replies)

this post was submitted on 27 Jul 2024

833 points (97.8% liked)

Programmer Humor

19171 readers

1620 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 1 year ago

MODERATORS