Databases: MariaDB and PostgreSQL

Our MariaDB 10.5 server is mariadb.labranet.jamk.fi

Students can create their own user for the server by going to https://mariadb.labranet.jamk.fi (only available from LabraNet workstations or over VPN), authenticating with their LabraNet login, and pushing a button. The page then tells you your new mysql password, and you can also reset your password from there if you’ve forgotten it.

The server is accessible from student.labranet.jamk.fi, and from LabraNet workstations and over VPN. We’re open to suggestions for graphical tools to recommend, but HeidiSQL and DBeaver look pretty good and are available on LabraNet workstations.

The server supports TLS (for authenticating the server only), but does not force it.

Our PostgreSQL 12.4 server is postgres.labranet.jamk.fi

Same operating principles as the mariadb server above.