Top 23 Python MySQL Projects
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Project mention: How often do you use SQL query tool or service in your daily work? | reddit.com/r/SQL | 2021-11-21Regarding the subqueries: try https://tablum.io or https://redash.io, they materialize queried data so you can do a subquery multiple times.
-
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
Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
-
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.
-
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
-
-
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.
-
Project mention: Tortoise-ORM: Familiar asyncio ORM for Python, built with relations in mind | news.ycombinator.com | 2021-04-28
-
-
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).
awslabs has developed their own package for this and given it's for their product, seem likely to maintain it. https://github.com/awslabs/aws-data-wrangler
-
-
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: 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
-
Project mention: asyncmy, an asyncio MySQL driver accelerated by cython | reddit.com/r/Python | 2021-03-15
Repo: https://github.com/long2ice/asyncmy
-
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.
-
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
-
-
mysql_secure_installation_Ansible
Idempotent Ansible Module that provides the functions of "mysql_secure_installation" script
Project mention: mysql_secure_installation custom Ansible module | reddit.com/r/ansible | 2021-06-01
Python MySQL related posts
- 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?
- thermostat optimization, trying to find the right algorithm to apply to the right framing
Index
What are some of the best open-source MySQL projects in Python? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Redash | 19,987 |
| 2 | mycli | 10,014 |
| 3 | PyMySQL | 6,671 |
| 4 | dev-setup | 5,566 |
| 5 | PonyORM | 2,742 |
| 6 | databases | 2,567 |
| 7 | tortoise-orm | 2,518 |
| 8 | AWS Data Wrangler | 2,321 |
| 9 | mysqlclient | 1,988 |
| 10 | python-mysql-replication | 1,939 |
| 11 | Gopherus | 1,674 |
| 12 | aiomysql | 1,369 |
| 13 | nagios-plugins | 1,033 |
| 14 | django-mysql | 444 |
| 15 | aerich | 420 |
| 16 | django-migration-linter | 324 |
| 17 | cheatsheets | 79 |
| 18 | pastebin-scraper | 77 |
| 19 | asyncmy | 69 |
| 20 | boxball | 68 |
| 21 | prisma-client-py | 63 |
| 22 | mqtt2sql | 43 |
| 23 | mysql_secure_installation_Ansible | 21 |
Are you hiring? Post a new remote job listing for free.
