add SQL Database

[MareoRaft]

Let's make an SQL DB (maybe SQLite) and populate the stats into it, then use SQLAlchemy or pyodbc to pull the data from the database and hand it over.

[MareoRaft]

Let's start w/ a simple script on my local laptop.

[MareoRaft]

Found a good tutorial: https://riptutorial.com/sqlalchemy

And their suggested "hello world" code works:

from sqlalchemy import create_engine
from sqlalchemy import Column, Integer, Text, MetaData, Table
from sqlalchemy import select

# globals
engine = create_engine('sqlite://')

# main
metadata = MetaData()
mytable = Table('mytable', metadata,
  Column('id', Integer, primary_key=True),
  Column('message', Text),
)
mytable.create(bind=engine)

insert_row = mytable.insert().values(message='hi, world')
engine.execute(insert_row)

statement = select([mytable.c.message])
message, = engine.execute(statement).fetchone()

print(message)

[MareoRaft]

Type pandas to sqlite into google and see the result!

[MareoRaft]

You can go DIRECTLY from a DataFrame to SQL using SQLAlchemy OR sqlite3 and the following method:
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_sql.html

[MareoRaft]

and THE OTHER DIRECTION with:
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_sql.html