839
JSON Query Language (programming.dev)
you are viewing a single comment's thread
view the rest of the comments
[-] xmunk@sh.itjust.works 19 points 3 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 3 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 3 months ago

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

[-] Enoril@jlai.lu 8 points 3 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 3 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 3 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 3 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
839 points (97.8% liked)

Programmer Humor

19452 readers
67 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