PyMySQL
awesome-mysql
Our great sponsors
PyMySQL | awesome-mysql | |
---|---|---|
4 | 1 | |
7,551 | 2,235 | |
0.6% | - | |
7.4 | 1.8 | |
25 days ago | 2 days ago | |
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.
awesome-mysql
-
CSS Deep
shlomi-noach/awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources
What are some alternatives?
mysqlclient - MySQL database connector for Python (with Python 3 support)
asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio.
mysql-python - MySQLdb is a Python DB API-2.0 compliant library to interact with MySQL 3.23-5.1 (unofficial mirror)
psycopg2 - PostgreSQL database adapter for the Python programming language
pymssql - Official home for the pymssql source code.
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
apsw - Another Python SQLite wrapper
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