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