Goal -> Simulate MetaGame in Excel or similar
-> Works under version control
-> Then be able to export this to data that can be used and tweaked at runtime/semi-dynamically
Issues -> using CSV files can be managed under version control, but no direct facility to simulate
-> Excel is windows platform only, files don't work so great under version control
-> LibreOffice works only across platforms, but is a bit harder to use. Similar version control issues.
-> using sqlite3 is good for having a DB with schema. Scriptable and can export/import to text files. Can't simulate directly.
-> Can hook up sqlite3 to an ODBC driver and access it in LibreOffice in Base and then import to Calc. Lots of software
to install and setup/configure and fiddly. Changing values in the DB requires a re-import of data from Base to Calc.
- Can change data in DB, then in Calc, in Data menu choose 'Refresh Range' and it updates
- Perhaps can script this?
## http://sqlitebrowser.org
brew cask install db-browser-for-sqlite
wget http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.9993.dmg
wget http://www.odbcmanager.net/downloads/ODBC_Manager_Installer.dmg
## http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads
wget http://opldownload.s3.amazonaws.com/uda/components/7.0/universal-apple-macosx10.7-32/mxkozzzz.dmg
#/usr/local/lib/libsqlite3odbc.dylib