JPDev@programming.dev to Programmer Humor@programming.dev · 2 months agoJSON Query Languageprogramming.devimagemessage-square47fedilinkarrow-up1832arrow-down119
arrow-up1813arrow-down1imageJSON Query Languageprogramming.devJPDev@programming.dev to Programmer Humor@programming.dev · 2 months agomessage-square47fedilink
minus-squareEpheralinkfedilinkarrow-up2·2 months agoIn a traditional SQL database, yeah. In various document-oriented (NoSQL) databases, though, you can do that.
minus-squaresnowfalldreamlandlinkfedilinkarrow-up5·2 months agoModern relational databases have support for it too including indexes etc. For example postgres.
minus-squaremousetail@programming.devlinkfedilinkarrow-up2·2 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.