1

Am using windows 10,

I am running MariaDB 10.1.18 and it says JSON was supported from 10.0.1

but when am trying to do flask db migrations it's throwing error ? json not support.

davidism
  • 121,510
  • 29
  • 395
  • 339
Shiva
  • 467
  • 2
  • 4
  • 12
  • "**it** says JSON was supported from 10.0.1" -- what is "it"? Where did you find this information? What exactly you mean by supporting JSON? What SQL are you trying to execute, which error are you getting? – elenst Mar 12 '17 at 13:39
  • I want to create a column with json datatype in mariadb. for that am using sqlalchemy and flask migrate to create a table. – Shiva Mar 12 '17 at 14:55
  • https://mariadb.com/kb/en/mariadb/data-types/ , i haven't found json data type in the list. i think no support. :( – Shiva Mar 12 '17 at 15:04
  • 1
    MariaDB does not support JSON **type**, it is still in the works. MariaDB 10.2 supports [JSON *functions*](https://mariadb.com/kb/en/mariadb/json-functions). I am not sure what exactly made you think 10.0 supports JSON -- there are other pieces of functionality related to JSON, e.g. [CONNECT JSON table type](https://mariadb.com/kb/en/mariadb/connect-json-table-type) or [EXPLAIN / ANALYZE FORMAT=JSON](https://mariadb.com/kb/en/mariadb/analyze-and-explain-statements), maybe you thought about those. – elenst Mar 12 '17 at 15:58
  • Yup, you are right, thank you, I misunderstand as you said – Shiva Mar 12 '17 at 17:08

1 Answers1

2

MariaDB as of 10.2 does not yet support JSON type, it is still in the works. MariaDB 10.2 supports JSON functions.

There is also other JSON-related functionality, e.g. CONNECT JSON table type, or EXPLAIN / ANALYZE FORMAT=JSON.

elenst
  • 3,839
  • 1
  • 15
  • 22