User Tools

Site Tools


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:

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

JSON

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