Migrate saving data to SQLite database

[zackthoutt]

Migrate saving data to SQLite database

[liamhawkins]

Did a quick refactor of the create_db.py code with ba71460 to make it into a class. Still relies on reading in the json file, and is hard-coded for the profiles.json data. Reading more into SQLAlchemy so tables can be made dynamically.

[zackthoutt]

Nice :). Go ahead and read up on SQLAlchemy for this dataset. It looks like we are going to use Django on the full project since we will be managing a lot of tables and data sources. Django has an ORM that abstracts writing SQL, including the creating of tables. It's pretty nice once you get the hang of it. Here is the documentation:

https://docs.djangoproject.com/en/2.0/topics/db/models/

I'd be happy to help everyone learn it as we get started.

[liamhawkins]

I've done a basic django tutorial or two in the past but didn't do nearly enough to get an intuitive sense of how it works. This will give me a great excuse to really dive into it. I'm sure I'll have many questions for you!