JPDev@programming.dev to Programmer Humor@programming.dev · 4 months agoJSON Query Languageprogramming.devimagemessage-square36fedilinkarrow-up1674arrow-down118
arrow-up1656arrow-down1imageJSON Query Languageprogramming.devJPDev@programming.dev to Programmer Humor@programming.dev · 4 months agomessage-square36fedilink
minus-squareEphera@lemmy.mllinkfedilinkarrow-up1·4 months agoIn a traditional SQL database, yeah. In various document-oriented (NoSQL) databases, though, you can do that.
minus-squaresnowfalldreamland@lemmy.mllinkfedilinkarrow-up5·4 months agoModern relational databases have support for it too including indexes etc. For example postgres.
minus-squaremousetail@programming.devlinkfedilinkarrow-up2·4 months agoEvery major SQL database supports json manipulation nowadays. I know MariaDB and MySQL and SQLite at least support it natively.
In a traditional SQL database, yeah. In various document-oriented (NoSQL) databases, though, you can do that.
Modern relational databases have support for it too including indexes etc. For example postgres.
Every major SQL database supports json manipulation nowadays. I know MariaDB and MySQL and SQLite at least support it natively.