← Back to context

Comment by irrational

7 years ago

Wait, what major relational databases don't support JSON? Oracle and Sql Server definitely do. Does MySQL not support JSON?

6 comments

irrational

Reply
ken  7 years ago

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.

  • matharmin  7 years ago

    While it is technically an optional extension in sqlite, it is part of the main source distribution, and very easy to enable.

  • nbevans  7 years ago

    And why wouldn't you count SQLite extensions? Its JSON1 extension is practically ubiquitous.

marcolussetti  7 years ago

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.

  • GordonS  7 years ago

    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.