gdb-docker
A docker container containing the "Unischema" from the lecture "Grundlagen: Datenbanken" at TUM.
The docker container also starts a pgweb SQL-webinterface on locahost:8081
Run local postgres database through docker
Create and run the docker container
docker run --name gdb-docker -d -p 127.0.0.1:5432:5432 -p 127.0.0.1:8081:8081 ghcr.io/keinenclue/gdb-docker:latest
Stop container
docker stop gdb-docker
Run container again
This only works after the container has already been created
docker start gdb-docker
Delete container
docker rm gdb-docker
View logs
docker logs -f gdb-docker
Use database through the webinterface
- Open localhost:8081 in your browser
- Start coding SQL :)
Use database through DataGrip
- Create new project
- In the UI under Database Explorer: New(+ Symbol) -> Data Source -> PostgreSQL
- Change User to
postgres(no password is needed) - Click OK
- Select the public schema under postgres and click the reload button
- Start coding SQL :)