PyMySQL
mysqlclient
Our great sponsors
PyMySQL | mysqlclient | |
---|---|---|
4 | 4 | |
7,555 | 2,410 | |
0.7% | 1.2% | |
7.4 | 7.7 | |
about 1 month ago | 26 days ago | |
Python | Python | |
MIT License | GNU General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
PyMySQL
-
What is the defacto python driver for Mysql?
Pymysql is the one i have seen being used most commonly. https://github.com/PyMySQL/PyMySQL
-
There are many options for connecting MySQL from Python, but let's use PyMySQL or mysql-connector-python for now.
PyMySQL
-
Python 3.10.1
However, please note you don't need to use MySQLdb as your connector- I was very happy with pure-Python MySQL client library pyMySQL: https://pypi.org/project/PyMySQL/#installation https://github.com/PyMySQL/PyMySQL/ So far, I have been happy with its maintenance and compatibility of newer MySQL and MariaDB features (e.g. newer authentication methods). It is MIT-licensed.
-
Python3 Mysql Connector Issue. Help!!!
My preferred connector is pymysql, which I know supports it https://github.com/PyMySQL/PyMySQL/issues/651 but either use anyone that works for you or disable this feature on MySQL server, as suggested on that ticket.
mysqlclient
-
Can't install mysqclient in python 3.12
for your reference: https://github.com/PyMySQL/mysqlclient/issues/672
- mysqlclient in docker
- What is the defacto python driver for Mysql?
What are some alternatives?
mysql-python - MySQLdb is a Python DB API-2.0 compliant library to interact with MySQL 3.23-5.1 (unofficial mirror)
awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources
oursql - oursql is a set of MySQL bindings for python with a focus on wrapping the MYSQL_STMT API to provide real parameterization and real server-side cursors.
asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio.
awesome-postgres - A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql
mysql-connector-python - MySQL Connector/Python is implementing the MySQL Client/Server protocol completely in Python. No MySQL libraries are needed, and no compilation is necessary to run this Python DB API v2.0 compliant driver. Documentation & Download: http://dev.mysql.com/doc/connector-python/en
PySQL - Python wrapper for making MySQL queries easier