Connecting to MySQL

[Dean Stackhouse]

Hey,

Just wondering what the best way to connect and query an external MySQL database is.

I have found a few different options, some of which look very outdated.

Thanks.

[j.crater]

MySQL Connector seems like a good choice to me, but there are others too. The only one I found to be considered outdated is MySQLdb, but even this one has some forks which get some attention.

I would assume you are tied to MySQL, but if you have a chance I suggest considering Postgres too.

[nilamo]

SQLAlchemy's MySQL support lists several drivers that work, including which haven't had any development in a while, and which ones only work on python 2.x vs 3.x.

[snippsat]

SQLAlchemy's MySQL support lists several drivers that work, including which haven't had any development in a while, and which ones only work on python 2.x vs 3.x.

I see PyMysql on list,but not link to GitHub it's a pure-Python MySQL client library.
If use Framework there are usually own connection made for this eg Flask-MySQLdb’s,  Flask-MySQL

[Dean Stackhouse]

Thank-you everyone. I have gone with PyMySQL as it's compatible with the ARM processor in my Pi3 and seems to be maintained unlike some of the other options.