This year, to simplify the workflow of the exercises we will be using docker to manage the required database systems.
If you have never used docker you can find an installation guide here: Installing docker
Please also take the time to familiarize yourself with docker if you have no prior experience with it: Getting started
For the spatial databases exercises, you will have to install the following tool on your computer:
You will also have to create a container in docker for MobilityDB which will both be used in the spatial and mobilityDB part of this course. Having Docker installed, run the following command in a terminal:
docker pull —-platform=linux/amd64 mobilitydb/mobilitydb
docker volume create mobilitydb_data
docker run —-name mobilitydb -e POSTGRES_PASSWORD=mysecretpassword -p 25432:5432 -v mobilitydb_data:/var/lib/postgresql -d mobilitydb/mobilitydb
Then you will have to connect on your database server via a client (either GUI or terminal based):
When connecting your username is postgres (default username), the password is set in the docker run command (by default mysecretpassword), the address is localhost and the port 25432.
The two first exercise sessions will both be devided into a lab part and an exercise part. During the lab part, we will show you how to use the different tools and what we can do with them. This part will not be covered during the exam. During the exercise part, you will need to write some spatial databases requests. This part will be covered during the examination. QGIS will only be used for the lab part of the sessions.
…
Please download and install the following before the first exercise session.