Support for MySQL Connector/Python

[geertjanvdk]

This is a feature request/proposal for including MySQL Connector/Python, a pure Python database driver) support in Django. It will make it hopefully much easyier for people to get working with Django and MySQL on all platforms.

Attached you'll find the backend which is a patched agains Django 1.2 rev 12083. For now it works well.
We'll probably put some ideas/workaround found in the original MySQL backend, back in MySQL Connector/Python.

More information and download of MySQL Connector/Python here: ​https://launchpad.net/myconnpy

[geertjanvdk]

Patch of a DB backend supporting MySQL Connector/Python

[russellm]

Database backends should be first be maintained as external projects. Once you have demonstrated a long-term commitment to maintaining the external project, and you can demonstrate a non-trivial demand for your backend, we may consider introducing the backend into core.

[aaugustin]

Change UI/UX from NULL to False.

[aaugustin]

Change Easy pickings from NULL to False.

[aaugustin]

I'm not aware of "non-trivial demand" for this backend over the last three years. If I've missed it, please reopen.

[Daniel.Sears@…]

One reason to consider this is that MySQLdb does not currently support Python 3.

See ​https://python3wos.appspot.com/

[aaugustin]

Hmm. In fact, I'm going to reopen this myself, for the reasons explained here:

​https://groups.google.com/d/msg/django-developers/8r_RVmUe5ys/09lCwJl-L1kJ

[Daniel.Sears@…]

This looks like a moot point now that Oracle is shipping their own Django back-end for MySQL:

​http://dev.mysql.com/doc/connector-python/en/connector-python-django-backend.html

[aaugustin]

I still believe we should switch Django's built-in MySQL backend to MySQL Connector, because it’ll provide a better experience for MySQL users, especially under Python 3.

An external backend is less discoverable than a built-in one, all the more if it isn't even mentioned in the docs (we could fix that in the short term).

[anonymous]

The latest releases of PyMySQL work with Django + Python 3.3. So if the backend changes, it would be nice if PyMySQL can remain compatible.

[timo]

#22370 details a failing test with the connector (unclear to me if the problem is ours or theirs).

[giuliettamasina]

Note that MySQL Connector from Oracle does not work with Django 1.7, due to the various TEST_* settings being deprecated. See ticket #22584 for more info on this.

(I have sent a bug report to Oracle as well.)

It might not even be a good idea to refer to this adapter in the 1.7 documentation, as is currently done here:

​https://docs.djangoproject.com/en/1.7/ref/databases/#mysql-db-api-drivers

Until fixed on Oracle's side, following the documentation's advice for Python 3 will result in non-functioning tests.

[methane]

FYI, MySQL Connector/Python 1.2.2 GA has been released.

[collinanderson]

I think we should close this now that we officially recommend mysqlclient. (mysqlclient works on Python 3.)