mariadb
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:
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:
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/
mariadb.txt · Last modified: 2024/04/11 14:23 by 127.0.0.1