What python 3 library should I use for MySQL?

Question

As far as I know MySQLdb still isn't ported to Python 3.

There seems to be another library called PyMySQL on pypy but the installation for python 3 looks strange (run a .sh script?). Also there is a library called PyMySQL3 but I can't find info about what it's about.

What's the preferred way to use MySQL with Python 3 these days?

Is there an elegant solution that could be installed with pip or with a python setup.py install command?

Answer 1

I've used the basic mysql-connector from MySQL for a few Python 3 projects, along with SQLAlchemy.

I also tried PyMySQL, but if I remember correctly I had a more difficult time configuring it.