HiveBrain v1.2.0
Get Started
← Back to all entries
patternModerate

Does MariaDB support native JSON column data type?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
nativecolumnmariadbtypedoesjsondatasupport

Problem

I’m not talking about dynamic columns, I’m asking about native column JSON data type. In simple words, can I run the following code on any MariaDB version?

CREATE TABLE example (names JSON);


As far as I know, it doesn’t but I’m still not sure since there’s a lot of topics talking about JSON support on MariaDB for ages, but none said it’s finally implemented.

-- Update --

Just found three issues still open on MariaDB Jira about JSON data type support, which means it's still not yet implemented, right?

  • https://jira.mariadb.org/browse/MDEV-9056



  • https://jira.mariadb.org/browse/MDEV-9144



  • https://jira.mariadb.org/browse/MDEV-6632

Solution

JSON support will come to MariaDB 10.2. See the official MariaDB blog post from 28.02.2017. There are some example SQL statements and validation.


JSON is fast becoming the standard format for data interchange and for
unstructured data, and MariaDB 10.2 adds a range on JSON supporting
functions, even though a JSON datatype isn't implemented yet. There
are some reasons why there isn't a JSON datatype, but one is that
there are actually not that many advantages to that as JSON is a
text-based format. This blog post aims to describe JSON and the use
cases for it, as well as to describe the MariaDB 10.2 JSON functions
and uses for these, as well as showing some other additions to MariaDB
10.2 that are useful for JSON processing.

Context

StackExchange Database Administrators Q#165522, answer score: 11

Revisions (0)

No revisions yet.