PostgreSQL PSU Note Lab

PostgreSQL laboratory project for course 240-216 Computer Engineering Laboratory. The project runs PostgreSQL and pgAdmin with Docker Compose and provides a Flask note application using SQLAlchemy.

Features

• PostgreSQL 15 and pgAdmin 4 managed with Docker Compose
• Create, edit, and delete notes
• View, rename, and delete tags
• Many-to-many relationship between notes and tags through SQLAlchemy

Run the database services

docker compose up -d

Open pgAdmin at http://localhost:7080.

Run the application

python -m pip install -r requirements.txt
python psunote/noteapp.py

Open the application at http://127.0.0.1:5000.

Technology

• Python, Flask, Flask-SQLAlchemy, Flask-WTF
• PostgreSQL 15 and pgAdmin 4
• Docker Compose