Create Database for storing city data

[mrao2]

Overview

Definition of Ready (What are prerequisites to finish this task):

• NoSQL vs SQL is chosen
• Local vs Cloud is chosen
• Data source is found and properly formatted.

Definition of Done (What does it look like for this task to be done):

• a queryable database is up and running.
• has useable data stored

Action Items

• choose if sql or nosql
• setup a local instance of db
• format data and upload to db [Format Budget Data #2]
• Create local json file of budget data for development/testing
• Set up AWS Postgres RDS instance
• Upload data to RDS instance
• Create psql script for uploading in future

[shawon-crosen]

Because of the structure of the data, and the size, we are going to do a nosql style db like MongoDB or Firebase instead of a traditional relational database.