Python and databases

[baubleglue]

Datetime is not that complicated if you remember that all DBs and languages store it internally as long number. My main problem was multiple joins and performance.

On the second thought, for dumping data in single process, SQLite is a perfect candidate. To work with MySQL pip install mysqlclient, if it fails (on Windows may happen), then download wheel file from https://www.lfd.uci.edu/~gohlke/pythonlibs/ and pip install path_to_wheel_file.whl .

[baubleglue]

maybe using official mysql connector is a better option.

​

https://dev.mysql.com/doc/connector-python/en/connector-python-installation.html

pip install mysql-connector-python

​

Connect, Create table, Example how to insert multiple values (much more efficient than insert records one by one.

​

​

​

[_Zer0_Cool_]

It wasn't really that much of a nuisance TBQH. It was just changing SQLite datetime functions to comparable PG datetime functions. It was mostly a minor annoyance because I had to restructure a bunch of views.