Skip to main content

Database

This section contains various topics on the RSD database.

Database structure​

database diagram

The SQL scripts used to create tables, relations, RLS and RPC's are in the database folder of our repo.

Connecting to the database​

In some cases, it can be useful to connect to the database directly, so you can query it. To do so, first connect to the VM on which your RSD instance lives and go to the directory containing the docker-compose.yml file. Then run the command

docker compose exec database bash

to enter the database Docker container. Then run

psql --dbname=rsd-db --username=rsd

where you should replace the values if you set them differently in your .env. You can now run arbitrary SQL queries as root user.

Database migration scripts​

We publish database migration script during the release. The migration script can be used to upgrade the database structure from the previous version to released version. We use the published database migration script to update out production RSD instance.

All migration scripts are stored in our production repository.