A PostgreSQL Database stored on Heroku servers
Repositories for Tempoture
Frontend-Repository
·
Backend-Repository
·
Database-Repository
Above is a physical representation of the database that is used for the Tempoture project. The SQL to make this database can be found here. This database is used to store user data, Spotify music data, and local weather data.
- Vertabelo - An application used for designing database schema.
- PGAdmin - A software used for database maintenance and running queries.
- Psycopg2 - A software used with python to establish connections with databases.
- PostgreSQL - An open source object-relational database system that uses and extends the SQL language.
- Python3 - The programming language of choice for the project.
- SQLAlchemy - The software used in conjunction with Psycopg2 to query the database.
Before installing the following softwares, have the latest version of Python installed. Also note that these install commands are specific for the Ubuntu bash terminal.
$sudo apt update - Ensures Ubuntu is up to date.
$sudo apt install python3-pip - Install package management system.
$pip install Flask - Install for Flask.
$sudo apt update - Ensures Ubuntu is up to date.
$sudo apt install python3-pip - Install package management system.
$pip install psycopg2 - Install for psycopg2.
$sudo apt update - Ensures Ubuntu is up to date.
$sudo apt-get install postgresql postgresql-contrib
$sudo apt update - Ensures Ubuntu is up to date.
$pip install SQLAlchemy - Install for SQL alchemy.
Distributed under the GPL License. See LICENSE for more information.