SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python MySQL Projects
-
MindsDB
AGI's query engine - Platform for building AI that can learn and answer questions over federated data.
But this hacktoberfest I took a great step towards contributing to open source. During this hacktoberfest I have contributed to MindsDB which is a great platform for building AI from enterprise data, enabling smarter organizations.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Project mention: The 50 best open-source alternatives to popular SaaS software | dev.to | 2024-07-10GitHub: Redash GitHub Repository
-
airbyte
The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
Let’s say I’m using Cursor to build a bunch of data apps and using Airbyte as the data movement platform and Streamlit for the frontend. I’m writing in Python and using the Airbyte API libraries. This is my basic ‘tech stack’.
-
Project mention: SQLiteStudio: Create, edit, browse SQLite databases | news.ycombinator.com | 2024-11-24
One day I set out to resolve this, though I can not find in my notes' files what the solution was (for MySQL). It might have been to simply use MyCLI instead of the standard MySQL CLI. Have you tried it?
https://github.com/dbcli/mycli
-
-
Project mention: Writing Composable SQL Using Knex and Pipelines | news.ycombinator.com | 2024-11-28
You can compose SQL with https://ibis-project.org/tutorials/ibis-for-sql-users, which is using https://github.com/tobymao/sqlglot to parse the SQL under the hood.
As an alternative to parsing the SQL yourself, DuckDB's [relational API](https://duckdb.org/docs/api/python/relational_api) allows you to compose SQL expressions efficiently and lazily, which I've used when playing around with thinks like https://gist.github.com/ajfriend/eea0795546c7c44f1c24ab0560a...
-
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: Django and Postgres for the Busy Rails Developer | news.ycombinator.com | 2024-12-11
Wouldn't know. However, some standalone projects are attempting to replicate the same experience, check Tortoise ORM - https://github.com/tortoise/tortoise-orm.
-
AWS Data Wrangler
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: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24
SQLAlchemy Core: the core SQL query builder, without the mapping to objects part. There is also a higher level ORM built on this called databases that looks very nice. I do wonder how actively developed the project is however.
-
Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24
Alternative ORMs: there are many such as peewee, PonyORM, etc.
-
-
-
python-mysql-replication
Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL
-
-
prisma-client-py
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
-
Project mention: Syncthing – A decentralized continuous file synchronization program | news.ycombinator.com | 2024-08-18
You could use Syncthing just to empty the incoming files from your phone (ingest) and then move the photos via cron to a second folder (also Syncthing) which is just shared with the replicas.
Another approach would be to push the files from Syncthing to borg (borgmatic can do replicas) https://torsion.org/borgmatic/
-
-
-
-
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...
-
django-dbbackup
Management commands to help backup and restore your project database and media files
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).
Python MySQL discussion
Python MySQL related posts
-
SQLiteStudio: Create, edit, browse SQLite databases
-
Building a better and scalable system for data migrations
-
Real-time analytics into MySQL/MariaDB and ProxySQL in the terminal
-
Top open-source repos/projects to contribute (Hacktoberfest Edition 🎃)
-
Dolphie: Single pane of glass for RT analytics into MySQL/MariaDB/ProxySQL
-
Announcing the public beta for dedicated clusters
-
Show HN: SQL Explorer – Open-source reporting tool that just works
-
A note from our sponsor - SaaSHub
www.saashub.com | 19 Jan 2025
Index
What are some of the best open-source MySQL projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | MindsDB | 27,076 |
| 2 | Redash | 26,758 |
| 3 | airbyte | 16,935 |
| 4 | mycli | 11,546 |
| 5 | PyMySQL | 7,704 |
| 6 | sqlglot | 6,998 |
| 7 | dev-setup | 6,130 |
| 8 | ibis | 5,452 |
| 9 | tortoise-orm | 4,782 |
| 10 | AWS Data Wrangler | 3,965 |
| 11 | databases | 3,870 |
| 12 | PonyORM | 3,674 |
| 13 | Gopherus | 2,928 |
| 14 | mysqlclient | 2,471 |
| 15 | python-mysql-replication | 2,338 |
| 16 | learning | 1,935 |
| 17 | prisma-client-py | 1,932 |
| 18 | borgmatic | 1,870 |
| 19 | aiomysql | 1,777 |
| 20 | fapro | 1,562 |
| 21 | eralchemy | 1,184 |
| 22 | nagios-plugins | 1,139 |
| 23 | django-dbbackup | 1,003 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com