5 ms·
JSON support is also provided by the CONNECT storage engine, which I think is much simpler. https://mariadb.com/kb/en/mariadb/connect-json-table-type/ https://
by mathnode 11y ago
JSON support is also provided by the CONNECT storage engine, which I think is much simpler.
https://mariadb.com/kb/en/mariadb/connect-json-table-type/ https://mariadb.com/kb/en/mariadb/connect-json-table-type/
e.g:
SQL > CREATE TABLE junk.j1 (a int default null)
ENGINE=CONNECT DEFAULT CHARSET=utf8
table_type=JSON
File_name='j1.json';
SQL > insert into junk.j1 (values) (1);
$ ls $(mysql -NBe "select @@datadir")/junk
db.opt j1.frm j1.json
$ cat $(mysql -NBe "select @@datadir")/junk/j1.json
[
{
"a": 1
}
]
I use this for generating config files, and getting data into pydata tools; no need for a database driver, which is interesting.