@JPDev to Programmer Humor • 2 months agoJSON Query Languageimagemessage-square48arrow-up1861arrow-down119
arrow-up1842arrow-down1imageJSON Query Language@JPDev to Programmer Humor • 2 months agomessage-square48
minus-square@[email protected]linkfedilink37•2 months agoBoth Oracle and Postgres have pretty good support for json in SQL.
minus-square@[email protected]linkfedilink17•2 months agoand the plane in the picture is perfectly capable of transporting a plane. What’s your point?
minus-square@[email protected]linkfedilink19•2 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-square@[email protected]linkfedilink8•2 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✺linkfedilink5•2 months agoI think plane people call it a fusilage, because they’re weird and like French.
minus-squareEnorillinkfedilink9•2 months agoIt’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 :-)
minus-square@[email protected]linkfedilink-1•2 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-square@[email protected]linkfedilink4•2 months agoTurn it inside out. Why not use a RDBMS with a NoSQL bit added on the side?
minus-square@[email protected]linkfedilink3•2 months agoSpecifically so you get mature transactional guarantees, indices and constraints that let app developers trust your db.
Both Oracle and Postgres have pretty good support for json in SQL.
and the plane in the picture is perfectly capable of transporting a plane. What’s your point?
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.
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 :-)
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.