Django documention - MySQL database connector - PyMySQL for python 3 support

[kinganu]

Just wanted to notify to add documentation for MySQL python 3 support there is a common package used called PyMySQL to connect with database. Ive used successfully with flask applications, trying with django now.

pip install pymysql

more info here : ​http://stackoverflow.com/questions/34777755/how-to-config-django-using-pymysql-as-driver

[Tim Graham]

We're recommending the ​mysqlclient MySQLdb fork. Is there a reason to prefer PyMySQL instead?

[pojda]

Jumping into something old here, but I have to add some info: the mysqlclient lib you recommend is a pain to install on Mac or Windows, while PyMysql works out of the box.

I had to use the same workaround mentioned on that stackoverflow post - which I don't like because I'm modifying Django's source and may cause trouble when upgrading.

Cheers!

[Sergey Fedoseev]

Replying to pojda:

I had to use the same workaround mentioned on that stackoverflow post - which I don't like because I'm modifying Django's source and may cause trouble when upgrading.

It looks like this workaround can be added to settings.py as well: ​https://stackoverflow.com/questions/34777755/how-to-config-django-using-pymysql-as-driver#comment92469445_34778155

[andreymal]

Replying to Tim Graham:

Is there a reason to prefer PyMySQL instead?

There is a very important reason: mysqlclient is GPL-licensed. This makes it impossible to create proprietary projects using MySQL. (I know it's not AGPL and I'm not obliged to publish my backend code for everyone, but GPL may still have other legal problems.)

In fact, I would really like the PyMySQL support to be full and official.