Carpooling Management System

This is a Web-Application built using Django framework and MySQL Database with HTML/CSS + Bootstrap front end for the CS254 DataBase Systems Lab Course (Mini-Project).

Team members:

1. Mudit Singhal
2. Swapnil Guduru
3. Ashutosh Anand

ER Diagram

Steps to host :

Make a New Folder named DBMS_Project Then run the following commands to your terminal

git clone https://github.com/muditsinghal/DBMS-Project.git
cd DBMS-Project
python -m venv venv
venv\Scripts\activate
pip install -r requirements.txt

This will set up your intial project folder. Then in your MySQL shell, Create a database name as cabify and then grant all the permission to username dbadmin having password 123. ( If you want a different username\password for your program, do make changes in DATABASES section of Carpooling\Carpooling\settings.py )

Now make migrations and start the server

python manage.py makemigrations
python manage.py migrate
python manage.py runserver

This will start a local-server at 127.0.0.1:8000 hosting the project.

Scaling

For the learning purpose of scaling we created images of the server and database and ran 3 containers of the django-server along side 1 MySQL server, all running inside a docker network. We further added an NGinx reverse proxy manager for the purpose of loadbalancing (used default round robin type ) the tree django-server containers.