InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises. Learn more →
Top 23 Python MySQL Projects
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.Project mention: Recommend Django Great Projects | news.ycombinator.com | 2022-12-03
In-Database Machine LearningProject mention: Making Something Waspy: A Review Of Wasp | dev.to | 2023-01-10
I picked a few of them on the hacktoberswag.com website. Precisely three: pusher.js, refine.dev, and MindsDB. You are probably asking Oh, you did not pick Wasp? The thing was, Wasp wasn’t listed on that web page and I didn’t know if any tool by that name existed.
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.Project mention: 5 Useful Database Command Line Tools | dev.to | 2022-04-25
Pure Python MySQL Client
Pymysql is the one i have seen being used most commonly. https://github.com/PyMySQL/PyMySQL
Something like this at least is the most direct answer to your question, as opposed to "you're doing it wrong" which unfortunately seems to be more upvoted. An example of something like this might be https://github.com/donnemartin/dev-setup
Familiar asyncio ORM for python, built with relations in mindProject mention: Example typescript project repos? | reddit.com/r/typescript | 2022-10-27
If I was answering this question but for python, I'd recommend something like prefect, boto3, or tortoise-orm -- not extremely complex and with a pretty comprehensible featureset.
pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).Project mention: I agree that Arrow Tables are great, but we decided to keep the library focused on the Pandas interface. [wont implement] | reddit.com/r/programmingcirclejerk | 2022-09-21
Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
Async database support for Python. 🗄Project mention: Getting Started with Fast-Api 🏎️ and Docker🐳 | dev.to | 2023-02-02
In the code ,we are using SQLAlchemy as our ORM(Object Relational Mapper) and Databases as our query builder.
Pony Object Relational MapperProject mention: This Week in Python | dev.to | 2022-05-20
pony – Pony Object Relational Mapper
Expressive analytics in Python at any scale.Project mention: Why use Python over SQL? | reddit.com/r/datascience | 2022-12-25
By the way I was introduced to Ibis https://github.com/ibis-project/ibis recently, I have mix feelings about it.
MySQL database connector for Python (with Python 3 support)
This tool generates gopher link for exploiting SSRF and gaining RCE in various servers
Pure Python Implementation of MySQL replication protocol build on top of PyMYSQLProject mention: How to Use BinLogs to Make an Aurora MySQL Event Stream | dev.to | 2022-10-03
The BinLogStreamReader has several inputs that we need to retrieve. First we'll retrieve the cluster's secret with the database host/username/password and then we'll fetch the serverId we stored in S3.
Efficiently diff data in or across relational databasesProject mention: Ask HN: How do you test SQL? | news.ycombinator.com | 2023-01-31
I did data engineering for 6 years and am building a company to automate SQL validation for dbt users.
First, by “testing SQL pipelines”, I assume you mean testing changes to SQL code as part of the development workflow? (vs. monitoring pipelines in production for failures / anomalies).
1 – assertions. dbt comes with a solid built-in testing framework  for expressing assertions such as “this column should have values in the list [A,B,C]” as well checking referential integrity, uniqueness, nulls, etc. There are more advanced packages on top of dbt tests . The problem with assertion testing in general though is that for a moderately complex data pipeline, it’s infeasible to achieve test coverage that would cover most possible failure scenarios.
2 – data diff: for every change to SQL, know exactly how the code change affects the output data by comparing the data in dev/staging (built off the dev branch code) with the data in production (built off the main branch). We built an open-source tool for that: https://github.com/datafold/data-diff, and we are adding an integration with dbt soon which will make diffing as part of dbt development workflow one command away 
We make money by selling a Cloud solution for teams that integrates data diff into Github/Gitlab CI and automatically diffs every pull request to tell you the how a change to SQL affects the target table you changed, downstream tables and dependent BI tools (video demo: )
I’ve also written about why reliable change management is so important for data engineering and what are key best practices to implement 
aiomysql is a library for accessing a MySQL database from the asyncio
Fake Protocol Server
450+ AWS, Hadoop, Cloud, Kafka, Docker, Elasticsearch, RabbitMQ, Redis, HBase, Solr, Cassandra, ZooKeeper, HDFS, Yarn, Hive, Presto, Drill, Impala, Consul, Spark, Jenkins, Travis CI, Git, MySQL, Linux, DNS, Whois, SSL Certs, Yum Security Updates, Kubernetes, Cloudera etc...
Learning Shell，Python，Golang，System，Network (by anzhihe)Project mention: Learning awk and sed? start here | reddit.com/r/linux4noobs | 2022-05-22
Entity Relation Diagrams generation toolProject mention: Tools that help to explore and navigate database tables | reddit.com/r/dataengineering | 2022-11-21
sometging like this, maybe https://github.com/Alexis-benoist/eralchemy
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of useProject mention: Alternatives to SQLAlchemy for your project - Prisma case | dev.to | 2022-08-08
Anyway, prisma is a relatively new project, and it is very pleasant to use. I encourage you to give it a try and support the python client (at least a star on GitHub). For me who doesn't like SQL, being able to retrieve models from the database and make queries with prisma is a breath of fresh air. 🤣
Management commands to help backup and restore your project database and media filesProject mention: Project for power companies - I might have bit more than I can chew | reddit.com/r/django | 2022-08-04
And finally backups, this part is really important. When I was a beginner, I used to make silly mistakes which would lead me having to reset the entire database and rebuild. With backups you can simply restore back to a working point in time whenever something goes wrong. The django-dbbackup package can do this for you, however, you may run into a few issues which can be fixed. Or you could simply use PostgreSQL database dumps.
A database migrations tool for TortoiseORM, ready to production.
:dolphin: :horse: Extensions to Django for use with MySQL/MariaDB
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Python MySQL related posts
Ask HN: How do you test SQL?
18 projects | news.ycombinator.com | 31 Jan 2023
Data-diff v0.3: DuckDB, efficient in-database diffing and more
1 project | news.ycombinator.com | 15 Dec 2022
data-diff VS cuallee - a user suggested alternative
2 projects | 30 Nov 2022
Compare identical tables across databases to identify data differences (Oracle 19c)
1 project | reddit.com/r/SQL | 26 Oct 2022
A Deep Dive into Connecting FastAPI with SingleStore.
3 projects | dev.to | 18 Oct 2022
Hacktoberfest Accepted Project with Vanilla Python 🚀 🌕
1 project | reddit.com/r/coding | 13 Oct 2022
Hacktoberfest Accepted Project with Vanilla Python 🚀 🌕
1 project | reddit.com/r/Python | 13 Oct 2022
A note from our sponsor - InfluxDB
www.influxdata.com | 3 Feb 2023
What are some of the best open-source MySQL projects in Python? This list will help you:
|7||AWS Data Wrangler||3,305|