We Can Do Better Than SQL

Re:We Can Do Better Than SQL by jade12 on Thursday May 09, 2019 @04:12PM (#19871919)

Doesn't every major RDBMS support JSON out of the box these days?

[ Parent | on HN ]

Re:We Can Do Better Than SQL by zaarn on Thursday May 09, 2019 @04:34PM (#19872151)

(Last I checked atleast) JSON isn't as well supported on MySQl or MSSQL compared to PG.

In PG, a JSON column is so well integrated that you can do all sorts of crazy stuff (indices over JSON queries is my favorite). You could build an entire RDBMS on top of PG's JSON column.

[ Parent | on HN ]

Re:We Can Do Better Than SQL by atwebb on Thursday May 09, 2019 @04:52PM (#19872313)

MSSQL indexes and provides dot notation/object query from 2016 forward, schemas are supported as well.

[ Parent | on HN ]