PyMySQL
mysql-connector-python
Our great sponsors
PyMySQL | mysql-connector-python | |
---|---|---|
4 | 3 | |
7,544 | 848 | |
0.6% | 1.2% | |
7.4 | 8.0 | |
24 days ago | 3 months ago | |
Python | Python | |
MIT License | GNU General Public License v3.0 or later |
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.
mysql-connector-python
What are some alternatives?
mysqlclient - MySQL database connector for Python (with Python 3 support)
semver - Semantic Versioning Specification
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
asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio.
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.
awesome-postgres - A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql
python-mysql-replication - Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL
motor - Motor - the async Python driver for MongoDB and Tornado or asyncio
Astronomia - My own rendition of the classic Asteroids game
mysqldump-analyzer - Tool to analyze and compare the output of mysqldump