Create Database for storing city data - Githubissues

OpenSTL / peoples-budgeting

1 stars 0 forks source link

Create Database for storing city data #1

Open mrao2 opened 3 years ago

mrao2 commented 3 years ago

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

[x] choose if sql or nosql
[x] setup a local instance of db
[x] format data and upload to db [#2]
[x] 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 commented 3 years ago

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.