...

• Since SQLite is an embedded system, it does not provide direct network access to its data so only the machine with which it is running on has easy read/write access. SQLite may be good for testing purposes, however. 

• Compared to using plain CSVs, a database provides greater structure, easy-viewing, and concurrency. 

• MySQL is a client/server database, so a server is provided and the database can handle multiple users.

Implementation

All of our primarily models in the optimization suite will have to be connected toe the database.

Given the current implementation of 2 copies of the optimization algorithms running, there will be 2 instances of the database. This will be subject to change depending on the implementation the strategy team decides on.

...