The purpose of this repository is to understand fundamentals of Database Schema design, and understand basic SQL syntax to create tables, query for data, insert data, and create helper functions to allow for easier interaction with your database.
To utilize this repository, you must first install Postico and Postgres so that you can host PostgreSQL on your machine. You also must create a database named "test" before proceeding.
The data file used in this repository was is a csv containing data about the tenure of U.S. Presidents since inception taken from Niclas Darville's d3-charts repository. Thanks for making this data available.
The prezengine.py file in this repository, when run in the command line, will prompt the user whether to query the database by the features of the database or to write new data into the database. This allows a tech-savvy revisionist historian to run wild with all the "what-ifs" of American electoral politics.