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: Open source DW? | reddit.com/r/dataengineering | 2022-01-03

    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.

  • 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

    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.

  • GitHub repo PyMySQL

    Pure Python MySQL Client

    Project mention: Python 3.10.1 | reddit.com/r/mysql | 2021-12-13

    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.

  • 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: PostgREST v9.0.0 | news.ycombinator.com | 2021-11-29
  • GitHub repo tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    Project mention: Show HN: Django Async ORM | news.ycombinator.com | 2021-12-01

    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]

    [1] https://github.com/tortoise/tortoise-orm

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

  • 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: Automate some wrangling and data visualization in Python | reddit.com/r/aws | 2022-01-03
  • 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 condenser

    Condenser is a database subsetting tool

    Project mention: Condenser: A database subsetting tool written in Python, for Postgres and MySQL | news.ycombinator.com | 2022-01-15
  • GitHub repo 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
  • GitHub repo cheatsheets

    My Cheatsheet Repository (by ruanbekker)

    Project mention: My cheatsheets repo | reddit.com/r/cheatsheets | 2021-09-19
  • 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 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 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 mqtt2sql

    Copy MQTT topic payloads to MySQL/SQLite database

    Project mention: Uploading data from smartphone to VPS | reddit.com/r/selfhosted | 2021-05-13
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 2022-01-15.

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 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
Find remote MySQL jobs at our new job board 99remotejobs.com. There are 2 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
OPS - Build and Run Open Source Unikernels
Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.
github.com/nanovms