JPDev@programming.dev to Programmer Humor@programming.dev · 3 months agoJSON Query Languageprogramming.devimagemessage-square45fedilinkarrow-up1813arrow-down118
arrow-up1795arrow-down1imageJSON Query Languageprogramming.devJPDev@programming.dev to Programmer Humor@programming.dev · 3 months agomessage-square45fedilink
minus-squarexmunk@sh.itjust.workslinkfedilinkarrow-up17·3 months agoJSON 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.
minus-squarelengau@midwest.sociallinkfedilinkarrow-up9·3 months agoCarrying 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.
minus-square✺roguetrick✺@lemmy.worldlinkfedilinkarrow-up6arrow-down1·3 months agoI think plane people call it a fusilage, because they’re weird and like French.
minus-squaremeliaesc@lemmy.worldlinkfedilinkarrow-up2arrow-down3·3 months agoWhy not use nosql if your important data is stored in JSON? You can still do all your fancy little joins and whatnot.
minus-squarefrezik@midwest.sociallinkfedilinkarrow-up4·3 months agoTurn it inside out. Why not use a RDBMS with a NoSQL bit added on the side?
minus-squarexmunk@sh.itjust.workslinkfedilinkarrow-up3·3 months agoSpecifically so you get mature transactional guarantees, indices and constraints that let app developers trust your db.
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.
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.
I think plane people call it a fusilage, because they’re weird and like French.
Why not use nosql if your important data is stored in JSON? You can still do all your fancy little joins and whatnot.
Turn it inside out. Why not use a RDBMS with a NoSQL bit added on the side?
Specifically so you get mature transactional guarantees, indices and constraints that let app developers trust your db.