PostgreSQL & SQLAlchemy

PostgreSQL & SQLAlchemy

PostgreSQL is an open-source relational database management system emphasizing extensibility and standards compliance.

We use SQLAlchemy (an object-relational mapper for python) to query data because of its ability to abstract data into objects and classes making it easy to manage relationships and how data is queried.

The following files Specify what the rows in the corresponding tables should be and any other information required for the tables - relationships

users

A class that handles the users table

accounts

A class that handles the accounts table

devices

A class that handles the devices table

calls

A class that handles the calls table

data_alchemy

In this file, we insert data into the database following the SQLAlchemy specifications.