A simple web app demonstrating the working of a PostgresQL database as part of the Database Management Systems course - UE19CS301 at PES University
Ensure you have Python 3 installed and package manager pip
installed
Run the following command to install the required packages via pip
:
pip install -r requirements.txt
Define the following environment variables to configure the server:
export APP_SETTINGS="config.DevelopmentConfig"
export DATABASE_URL= <your-postgresql-database-url>
To make the Flask backend talk to the database, we need use the Flask CLI to initialise and migrate the database:
Initialise the database after setting the DATABASE_URL
env:
flask db init
Migrate the database after defining your models:
flask db migrate
Finally run this command to upadate the server and save subsequent changes to the database:
flask db upgrade
Finally once all the packages are installed, run the server locally:
flask run
Website hosted on heroku:
https://pokemongo-db.herokuapp.com/