Python MySQL

Open-source Python projects categorized as MySQL | Edit details

Top 23 Python MySQL Projects

  • GitHub repo 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-21

    Regarding the subqueries: try https://tablum.io or https://redash.io, they materialize queried data so you can do a subquery multiple times.

  • GitHub repo mycli

    A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

    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.

  • GitHub repo PyMySQL

    Pure Python MySQL Client

    Project mention: Python3 Mysql Connector Issue. Help!!! | reddit.com/r/mysql | 2021-09-02

    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.

  • GitHub repo 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.

    Project mention: MacOS Development workspace 2021 | dev.to | 2021-03-08

    donnemartin - dev setup

  • GitHub repo PonyORM

    Pony Object Relational Mapper

  • GitHub repo databases

    Async database support for Python. 🗄

    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.

  • GitHub repo tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    Project mention: Tortoise-ORM: Familiar asyncio ORM for Python, built with relations in mind | news.ycombinator.com | 2021-04-28
  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • GitHub repo 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: Redshift API vs. other ways to connect? | reddit.com/r/datascience | 2021-10-21

    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

  • GitHub repo mysqlclient

    MySQL database connector for Python (with Python 3 support)

  • GitHub repo 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-28

    From 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.

  • GitHub repo Gopherus

    This tool generates gopher link for exploiting SSRF and gaining RCE in various servers

    Project mention: Is the Web Application Hacker's Handbook still relevant? | reddit.com/r/Pentesting | 2021-05-06
  • GitHub repo aiomysql

    aiomysql is a library for accessing a MySQL database from the asyncio

    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.

  • GitHub repo 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...

    Project mention: Weird Nagios plugin output | reddit.com/r/sysadmin | 2021-04-18

    Did you check this issue for possible fixes of your first problem? https://github.com/HariSekhon/Nagios-Plugins/issues/328

  • GitHub repo django-mysql

    :dolphin: :horse: Extensions to Django for use with MySQL/MariaDB

    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.

  • GitHub repo aerich

    A database migrations tool for TortoiseORM, ready to production.

    Project mention: FastAPI + Ormar + Alembic setup | dev.to | 2021-08-14

    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.

  • GitHub repo django-migration-linter

    :rocket: Detect backward incompatible migrations for your django project

    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

  • GitHub repo cheatsheets

    My Cheatsheet Repository (by ruanbekker)

    Project mention: My cheatsheets repo | reddit.com/r/cheatsheets | 2021-09-19
  • GitHub repo pastebin-scraper

    Live-scraping pastebin to fight boredom.

    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
  • GitHub repo asyncmy

    A fast asyncio MySQL driver with replication protocol support

    Project mention: asyncmy, an asyncio MySQL driver accelerated by cython | reddit.com/r/Python | 2021-03-15

    Repo: https://github.com/long2ice/asyncmy

  • GitHub repo 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-06

    You 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.

  • GitHub repo prisma-client-py

    Prisma Client Python is an auto-generated and fully type-safe database client

    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
  • GitHub repo mqtt2sql

    Copy MQTT topic payloads to MySQL/SQLite database

    Project mention: Uploading data from smartphone to VPS | reddit.com/r/selfhosted | 2021-05-13
  • GitHub repo 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
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-11-23.

Python MySQL related posts

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
Find remote MySQL jobs at our new job board 99remotejobs.com. There is 1 new remote job listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com