JPDev@programming.dev to Programmer Humor@programming.dev · 4 months agoJSON Query Languageprogramming.devexternal-linkmessage-square48fedilinkarrow-up1821arrow-down118
arrow-up1803arrow-down1external-linkJSON Query Languageprogramming.devJPDev@programming.dev to Programmer Humor@programming.dev · 4 months agomessage-square48fedilink
minus-squareEphera@lemmy.mllinkfedilinkarrow-up0·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.