848
JSON Query Language (programming.dev)
you are viewing a single comment's thread
view the rest of the comments
[-] jaybone@lemmy.world 37 points 10 months ago

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

[-] where_am_i@sh.itjust.works 17 points 10 months ago

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

[-] xmunk@sh.itjust.works 19 points 10 months 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.

[-] lengau@midwest.social 8 points 10 months ago

Carrying the body of a smaller plane in a larger plane isn't an antipattern either. Airbus does this between body assembly and attaching the wings.

[-] roguetrick@lemmy.world 5 points 10 months ago

I think plane people call it a fusilage, because they're weird and like French.

[-] Enoril@jlai.lu 9 points 10 months ago

It’s "fuselage".

It’s called like that because of it came from the word "forme fuselé" (Tapered shape) and it’s a french word mainly because we created it in 1908.

You’re welcome :-)

[-] meliaesc@lemmy.world -1 points 10 months 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 10 months ago

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

[-] xmunk@sh.itjust.works 3 points 10 months ago

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

this post was submitted on 27 Jul 2024
848 points (97.9% liked)

Programmer Humor

24240 readers
2339 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 2 years ago
MODERATORS