What's the difference between PyMySQL and mysqlclient-python?

[elad661]

PyMySQL and mysqlclient-python seem to be very similar: Both aim to be a mysql connector to python that aims to maintain compatibility with MySQLdb.

I know there's a difference in the implementation details (PyMySQL being pure python), but it's unclear to me which one I should use, and which implementation is superior.

[methane]

mysqlclient-python is much faster than PyMySQL.
When to use PyMySQL is:

• You can't use libmysqlclient for some reason
• You want to use monkeypatched socket of gevent or eventlet
• You wan't to hack mysql protocol

[radzhome]

PyMySQL also looks faster under PyPy vs mysqlclient - https://gist.github.com/methane/90ec97dda7fa9c7c4ef1

[lufangfan]

it is very nice!