Python + PostgreSQL + pgAdmin

Table of Contents

• Table of Contents
• Folder structure
• Run Docker containers
• Database credentials
• Know issues and how to solve them
• License and Credits

Folder Structure

.
├─ .devcontainer/
│  ├─ devcontainer.json       # VS Code Dev Container config
│  └─ servers.json            # Pre-configured connection to PostgreSQL

├─ Data/                      # CSV and Excel sample datasets
│  ├─ apartments_data_prepared.csv
│  ├─ Northwind_Database.xlsx
│  └─ *.csv (Northwind tables)
├─ SQL/
│  └─ *.sql                    # SQL queries
├─ docker-compose.yml          # Defines PostgreSQL & pgAdmin services
├─ Dockerfile                  # Custom image setup
├─ init-db.sql                 # Initial db objects
├─ requirements.txt            # Python dependencies
├─ *.ipynb                     # Jupyter notebooks
├─ .gitignore                  # Git ignore rules
└─ README.md                   # Documentation (this file)

Run Docker containers (starts automatically)

VS Code -> left Menu -> search file 'docker-compose.yml' -> right click -> Compose Up

Database credentials

Host: db
Port: 5432
Maintenance database: postgres
Username: pgadmin
Password: geheim

Known issues and how to solve them

1.) The pgadmin4 webpage cannot be opened
- Check if both containers are running, if not, restart the containers.
- Wait until the forwarded ports are visible in the Terminal.
- Open pgadmin4 on port 5050.

License and credits

This project is intended for educational/demo purposes.
Sample data includes public datasets such as Northwind.
Please verify licenses if using in other contexts.