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