PyMySQL
motor
Our great sponsors
PyMySQL | motor | |
---|---|---|
4 | 3 | |
7,551 | 2,320 | |
0.7% | 1.2% | |
7.4 | 8.4 | |
30 days ago | 8 days ago | |
Python | Python | |
MIT License | Apache License 2.0 |
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.
motor
-
Mongox: Familiar Python MongoDB ODM
Mongox is a an async MongoDB ODM (Object Document Mapper)built on top of Motor and Pydantic. Mongox has a simple syntax, is easy to pick-up for people who have experience working with Python ORMs and is fully type-annotated.
-
AuthenticationX is here 🚀✨
MongoDB async backend included thanks to mongodb/motor
-
using mongodb to store user data
Instead I would recommend looking into motor. It's an asynchronous wrapper for pymongo. Has the same API as pymongo just async. (It's officially supported by mongodb itself.)
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)
awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources
redis-py - Redis Python client
pydantic - Data validation using Python type hints
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.
kafka-python - Python client for Apache Kafka
awesome-postgres - A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql
mongox - Familiar async Python MongoDB ODM