35

I'd like to use the mysql-connector library for python 3. I could use pymysql instead, but mysql-connector already has a connection pool implementation, while pymysql doesn't seem to have one. So this would be less code for me to write.

However, when I do

$ pip3 search mysql-connector

I find that these 3 libraries are available:

mysql-connector-repackaged     - MySQL driver written in Python
mysql-connector-python-rf      - MySQL driver written in Python
mysql-connector-python         - MySQL driver written in Python

This is very confusing. Anybody knows which one I should use and why?

Thanks for your help.

Improve this question
1

4 Answers 4

Reset to default
21

The main differences between them are:

  • mysql-connector-repackaged: is old, do not use it

  • mysql-connector-python 2.0.4: is the original uploaded by MySQL. But it has the problem that does not works with Django >= 1.8. MySQL did not upload yet their stable version 2.1.3 to this repo.

  • mysql-connector-python-rf 2.1.3: is the solution to all your problems if you use Django >= 1.8

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Thanks for your reply. Do you have a source about this?
My own experience @JohnSmithOptional !
Would recommend using mysql-connector-python now, it's on version 8.0.29 as of today.
10

I was just asking myself similar question and I think I found the "fresh" answer. Here is info from two weeks ago: https://github.com/pypa/warehouse/issues/5537

It seems that currently a long-inactive person is owner of the mysql-connector name, hence MySQL developers release under name mysql-connector-python.

Improve this answer

2 Comments

That seems to finally answer the question indeed. Thanks!
Now mysql-connector description says Deprecated, go for official version pypi.org/project/mysql-connector-python.
5

If I were to base my assessment on the goodness of a package by how many people have downloaded it, I would suggest you choose mysql-connector-python-rf 2.1.3.

mysql-connector-python-rf worked for me with pip whereas mysql-connector-python gave me issues.

Improve this answer

3 Comments

The stats must be wrong. Even very obscure libraries have more hits than 5 downloads a month. I guess the stats are wrong because mysql-connector-python is externally hosted (you have to install it using --allow-external).
the 5 downloads in the past month is seemingly because everyone downloads it straight from dev.mysql.com instead of from pypi
Just want to callout that mysql-connector-python has been more active than the old rf package in the last 6-9ish months. It's on version 8.0.11 now (and I believe it's now the more preferred) but :shrugs:.
1

I'd recommend using mysql-connector-python nowadays, it's the official release from Oracle and still gets updated.

mysql-connector-repackaged     - last updated: Mar 11, 2012 (version 0.3.1)
mysql-connector-python-rf      - last updated: Feb 4, 2017 (version 2.2.2)
mysql-connector-python         - last updated: Dec 7, 2021 (version 8.0.28)
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.