Top 23 Python MySQL Projects
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Its a bad idea use Redash as ETL and Data warehouse? Im not a data engineer just looking for a low/mid scale solution for experiment.
-
Project mention: What packages are missing from openSUSE? (and I will package it! ) | reddit.com/r/openSUSE | 2021-05-14
lazygit and mycli.
-
Scout APM
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
-
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.
-
dev-setup
macOS development environment setup: Easy-to-understand instructions with automated setup scripts for developer tools like Vim, Sublime Text, Bash, iTerm, Python data analysis, Spark, Hadoop MapReduce, AWS, Heroku, JavaScript web development, Android development, common data stores, and dev-based OS X defaults.
donnemartin - dev setup
-
-
-
Thanks, it's great to see Django adding slowly but surely in all sorts of places.
By the way, have you looked at tortoise orm, which is a fully async python ORM with very Django-like syntax? [1]
-
SonarLint
Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.
-
AWS Data Wrangler
Pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).
Project mention: Automate some wrangling and data visualization in Python | reddit.com/r/aws | 2022-01-03 -
-
python-mysql-replication
Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL
Project mention: How is everyone ingesting backend relational data? | reddit.com/r/dataengineering | 2021-07-28From backend relational tables to data warehouses my team has mostly relied on change data capture replication. We use MySQL upstream, and historically used AWS DMS or Attunity Replicate to replicate directly to SQL server. Recently we made the switch to Snowflake, and used mostly AWS DMS to replicate CDC data to S3 (lists individual inserts, updates, deletes), and then from there use snowpipes to copy to snowflake and then a job to merge that data into the target table to get the latest state. In addition we've used this library in production https://github.com/noplay/python-mysql-replication, and still use it today for one high volume, critical data source. Generally we see data go end to end in a matter of minutes, but occasionally there are spikes in latency.
-
Project mention: Is the Web Application Hacker's Handbook still relevant? | reddit.com/r/Pentesting | 2021-05-06
-
Project mention: python asyncio, how to prevent the other functions "block" themselves when connecting to db? | reddit.com/r/learnpython | 2021-11-23
No, as I said, async db connection is the key. You can do that with SQLAlchemy using the databases library, but since you are not using SQLAlchemy it makes more sense to use the underlying db driver, aiomysql, directly.
-
nagios-plugins
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...
Did you check this issue for possible fixes of your first problem? https://github.com/HariSekhon/Nagios-Plugins/issues/328
-
Project mention: Is connecting Django to MS SQL too much of a bad idea? | reddit.com/r/django | 2021-11-04
Now that the driver is supported by MS themselves ( which is here ) - it's easy street. Heck, even when it wasn't "officially supported", it still worked.
-
We have successfully setup out FastAPI + ormar + alembic project. With pydantic support, ormar can generate pydantic models from ormar models. The generated pydantic models can be used by FastAPI during request/response data validation. ormar + alembic is a great duo to writing database code. Another great combination is tortoise ORM + aerich, which I'm planning to write soon.
-
Project mention: Does anyone use ci/cd for deploying database changes? | reddit.com/r/Database | 2021-08-18
There's actually a Django package called django-migration-linter that can help with this by spotting migrations that could break under that condition: https://github.com/3YOURMIND/django-migration-linter
-
Project mention: Condenser: A database subsetting tool written in Python, for Postgres and MySQL | news.ycombinator.com | 2022-01-15
-
prisma-client-py
Prisma Client Python is an auto-generated and fully type-safe database client providing a simplistic yet extremely powerful API
Project mention: GitHub - RobertCraigie/prisma-client-py: Prisma Client Python is an auto-generated and fully type-safe database client | reddit.com/r/Python | 2021-11-16 -
-
Project mention: asyncmy, an asyncio MySQL driver accelerated by cython | reddit.com/r/Python | 2021-03-15
Repo: https://github.com/long2ice/asyncmy
-
Project mention: Does Pastebin have a public archive available for download or a way to scrape the entire site? I’ve looked at their API and doesn’t seem to have this functionality. | reddit.com/r/datasets | 2021-02-16
-
boxball
Prebuilt Docker images with Retrosheet's complete baseball history data for many analytical frameworks. Includes Postgres, cstore_fdw, MySQL, SQLite, Clickhouse, Drill, Parquet, and CSV.
Project mention: How do I compile a list of a team's games where event x did not happen? | reddit.com/r/Sabermetrics | 2021-10-06You know, I thought about that after posting, that the dailies might not be available directly from retrosheet. I use the Boxball distributions, which take the retrosheet data and process it into database images. These distributions include a "daily" table with the daily logs. So apparently Boxball is generating that table.
-
Python MySQL related posts
- Python 3.10.1
- python asyncio, how to prevent the other functions "block" themselves when connecting to db?
- Is connecting Django to MS SQL too much of a bad idea?
- Modern account handler/creator with support for mongodb, postgresql, mysql, sqlite & smtp
- Best approach for async SQLAlchemy in FastAPI
- Python3 Mysql Connector Issue. Help!!!
- Correct approach for simple like system at scale?
Index
What are some of the best open-source MySQL projects in Python? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Redash | 20,290 |
| 2 | mycli | 10,128 |
| 3 | PyMySQL | 6,725 |
| 4 | dev-setup | 5,590 |
| 5 | PonyORM | 2,778 |
| 6 | databases | 2,653 |
| 7 | tortoise-orm | 2,623 |
| 8 | AWS Data Wrangler | 2,445 |
| 9 | mysqlclient | 2,000 |
| 10 | python-mysql-replication | 1,964 |
| 11 | Gopherus | 1,733 |
| 12 | aiomysql | 1,392 |
| 13 | nagios-plugins | 1,034 |
| 14 | django-mysql | 454 |
| 15 | aerich | 450 |
| 16 | django-migration-linter | 333 |
| 17 | condenser | 216 |
| 18 | prisma-client-py | 113 |
| 19 | cheatsheets | 86 |
| 20 | asyncmy | 80 |
| 21 | pastebin-scraper | 79 |
| 22 | boxball | 70 |
| 23 | mqtt2sql | 47 |
Are you hiring? Post a new remote job listing for free.
