Is your feature request related to a problem? Please describe.
When deploying on Heroku, PostgreSQL seems to be the best option as it's supported by Heroku
Describe the solution you'd like
The module mysql-connector-python and its usage needs to be replaced by psycopg2 and necessary changes in SQL syntax and Python code need to be implemented in databaseconnect.py to make sure pytest test_databaseconnect.py passes without errors.
Documentation changes for setting up the project.
Describe alternatives you've considered
None
Additional context
ClearDB add-on for MySQL on Heroku (plan isn't feasible)
Is your feature request related to a problem? Please describe. When deploying on Heroku, PostgreSQL seems to be the best option as it's supported by Heroku
Describe the solution you'd like
mysql-connector-pythonand its usage needs to be replaced bypsycopg2and necessary changes in SQL syntax and Python code need to be implemented indatabaseconnect.pyto make surepytest test_databaseconnect.pypasses without errors.Describe alternatives you've considered None
Additional context