Log Management System using PostgreSQL🐘

This is the first project for the MSc course Database Management System (M149) of the winter semester. The pronunciation can be found in the M149-Project01.pdf. The second project can be found here.

🛠️ Backend - FastAPI

Inside the backend/ directory:

Activate virtual environment:

$ source venv/Scripts/activate

Install requirements:

$ pip install -r requirements.txt

To start backend server:

$ uvicorn main:app --reload

To connect to your database, create an .env file with the properties of your database, like this:

export DB_HOST=<host> (probably, localhost)
export DB_PORT=<port> (probably, 5432)
export DB_USERNAME=<username>
export DB_PASSWORD=<password>
export DB_NAME=LogDB

🎨 Frontend - React

Chakra UI was used as the component library

In the frontend/ directory:

To run the app in development mode:

$ npm run start

Open http://localhost:3000 to view it in your browser.

🗄️ Database - PostgreSQL

Inside the /database directory:

Almost all the SQL queries are included.

⚠️ Make sure to first execute the stored functions in the database before running the web application

The EntityRelation diagram is provided, accompanied with comments.