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