@[email protected] to Programmer [email protected] • 5 months agoJSON Query Languageprogramming.devimagemessage-square47fedilinkarrow-up1848arrow-down118
arrow-up1830arrow-down1imageJSON Query Languageprogramming.dev@[email protected] to Programmer [email protected] • 5 months agomessage-square47fedilink
minus-square@jaybonelink36•5 months agoBoth Oracle and Postgres have pretty good support for json in SQL.
minus-square@[email protected]linkfedilink16•5 months agoand the plane in the picture is perfectly capable of transporting a plane. What’s your point?
minus-square@[email protected]linkfedilink18•5 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•5 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✺link5•5 months agoI think plane people call it a fusilage, because they’re weird and like French.
minus-squareEnorillinkfedilink9•5 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@meliaesclink-1•5 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•5 months agoTurn it inside out. Why not use a RDBMS with a NoSQL bit added on the side?
minus-square@[email protected]linkfedilink3•5 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.