====== MariaDB ======

**WARNING: MariaDB was only experimental. Every service in the v5 is now using PostgreSQL in case an SQL-engine is required**


===== SETUP =====

To get the MariaDB (in the current version) running on a local maschine use the link and select your specs:

https://downloads.mariadb.org/mariadb/repositories/

check installation:

''%%sudo systemctl status mariadb%%''

''%%mysql -V%%''

execute with:

''%%sudo mysql%%''

getting started:

https://mariadb.com/kb/en/mariadb-basics/


===== JSON =====

maria vs mysql vs postgres:

https://news.ycombinator.com/item?id=19160302

tutorial:

https://mariadb.com/resources/blog/json-with-mariadb-10-2/

json functions:

https://mariadb.com/kb/en/json-functions/


===== JSON Limitations =====


  * MariaDB can index JSON data, but since the new column must be a valid SQL type, no list indexing is possible.
  * For PostgreSQL it is possible to see, blog [1]

[1] https://rollout.io/blog/unleash-the-power-of-storing-json-in-postgres/