News for hackers. Stuff that matters.

A comment on We Can Do Better Than SQL. Parent comment

Re:We Can Do Better Than SQL by irrational on Thursday May 09, 2019 @04:33PM (#19872142)
Wait, what major relational databases don't support JSON? Oracle and Sql Server definitely do. Does MySQL not support JSON?
[ Parent | on HN ]
Re:We Can Do Better Than SQL by ken on Thursday May 09, 2019 @04:35PM (#19872157)
SQLite (the most popular RDBMS today) doesn't, unless you count extensions. And of course, none of them use the same syntax or functions or data types.
[ Parent | on HN ]
Re:We Can Do Better Than SQL by matharmin on Thursday May 09, 2019 @04:49PM (#19872284)
While it is technically an optional extension in sqlite, it is part of the main source distribution, and very easy to enable.
[ Parent | on HN ]
Re:We Can Do Better Than SQL by nbevans on Friday May 10, 2019 @03:27AM (#19875809)
And why wouldn't you count SQLite extensions? Its JSON1 extension is practically ubiquitous.
[ Parent | on HN ]
Re:We Can Do Better Than SQL by marcolussetti on Thursday May 09, 2019 @05:41PM (#19872711)
If I recall correctly, Oracle's support for JSON is not at the same level as PostgreSQL. By that I mean seamlessly store JSON as a data type like any other. In Oracle JSON is stored as VARCHAR/CLOB and then you implement tests to validate whereas in PostgreSQL and MSSQL is its own data type.
[ Parent | on HN ]
Re:We Can Do Better Than SQL by GordonS on Friday May 10, 2019 @02:38AM (#19875566)
Similar story with SQL Server. I believe JSON support is a bit better in SQL Server 2019, but still far lacking behind that of Postgres.
[ Parent | on HN ]
Re:We Can Do Better Than SQL by lefred on Thursday May 09, 2019 @06:20PM (#19873000)
Hi, MySQL supports JSON (it has a native JSON datatype) but it also support NoSQL (CRUD operations). For more details, check https://www.slideshare.net/lefred.descamps/pyconx-python-mys... or https://www.slideshare.net/lefred.descamps/oracle-code-roma-...
[ Parent | on HN ]