I am planning to use JSON data type in my database and according to the following webpage, the JSON table type should be available from MariaDB 10.0.16 under the CONNECT storage engine
https://mariadb.com/kb/en/mariadb/connect-json-table-type/
I don't see CONNECT storage engine available from XAMPP (tried SHOW ENGINES; from phpmyadmin). How can I upgrade MariaDB or add the CONNECT storage engine to it?
According to the following webpage, I should run the INSTALL SONAME 'ha_connect'; command. But I have to place the required libraries into the standard MariaDB plugin directory first. I can't find such directory from the xampp folder.
https://mariadb.com/kb/en/mariadb/loading-the-connect-storage-engine/
Any suggestions? Thanks very much!!