Modules I have found so far:
- MySQLdb https://github.com/farcepest/moist:
- Seems to have been a popular choice, but appears to be unmaintained.
- Doesn't support Python 3 - not useful for us.
- mysql-connector-python https://pypi.org/project/mysql-connector-python/:
- Currently maintained and supports Python 3.
- Good documentation at https://dev.mysql.com/doc/connector-python/en/.
- Have to use an old version to connect to MySQL 5.1 (version on NAS box) :/
- PyMySQL https://pypi.org/project/PyMySQL/:
- Currently maintained and supports Python 3.
- Good documentation at https://pymysql.readthedocs.io/en/latest/index.html.
- Seems to only support MySQL >= 5.5 :/
- CyMySQL https://pypi.org/project/cymysql/:
- Currently maintained (as of Jan 2019), and supports Python 3.
- This is a fork of PyMySQL that uses C code to speed up parts of the library.
- Points to same documentation as PyMySQL https://pymysql.readthedocs.io/en/latest/
- Requires MySQL 5.5 or higher :/
- mysqlclient https://pypi.org/project/mysqlclient/ <-- Trying this first
- A forl pf MySQLdb that adds Python 3 support.
- Currently maintained.
- Documentation available at https://mysqlclient.readthedocs.io/.
- Fortunately, seems to support older versions of MySQL, mentions 4.0 and 4.1.
- This is probably our best bet.
Instructions and tool are at https://github.com/methane/mysql-driver-benchmarks.
Unfortunately it seems being stuck on MySQL 5.1 might be a problem, but there is at least one module that seems to support it. I will look into building a newer database server for the NAS box when I get the cross compiler working. I will post updates here if I discover anything new.