Table of Contents

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

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