SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Go MySQL Projects
-
tidb
TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial
PingCAP | https://www.pingcap.com | Database Engineer, Product Manager, Developer Advocate and more | Remote in California | Full-time
We work on a MySQL compatible distributed database called TiDB https://github.com/pingcap/tidb/ and key-value store called TiKV.
TiDB is written in Go and TiKV is written in Rust.
More roles and locations are available on https://www.pingcap.com/careers/
-
Project mention: Database on a limited budget: Pay per-usage database or "cheap" config of Cloud SQL? | reddit.com/r/googlecloud | 2023-01-08
There are a few products that claim to "solve" these issues with MySQL/Postgres, but one look at the excellent Kyle Kingsbury's work showcases just how brittle these systems are, even when they aren't distributed. Just about the only distributed MySQL based provider I trust is Planetscale, because their underlying software Vitess, was invented at Google for use at YouTube. However, even we don't use it anymore, as we've long since moved everything into Spanner.
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
-
Project mention: storage of pictures into a database, and referencing them. | reddit.com/r/Database | 2023-01-30
The database is Dolt (https://github.com/dolthub/dolt) but it would work the same way in MySQL.
-
go-sql-driver/mysql
Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)
Authentication method mismatch is not allowed to occur more than once. It is not a part of MySQL protocol. go-sql-driver also has the same rule.
-
Project mention: Changing column from longtext to mediumtext taking over 2 hours | reddit.com/r/mysql | 2022-11-04
Not sure which version of MySQL you're using, but one approach would be to use a tool like pt-online-schema-change (from Percona) or g-host -- which will create a duplicate table and then swap it in place of the original table. It's a safer approach when operating in production environments. Here's a good comparison of the tools many people use https://planetscale.com/docs/learn/online-schema-change-tools-comparison
-
Project mention: Managing external database versions in Kubernetes | reddit.com/r/kubernetes | 2022-12-25
We use golang-migrate for our platforms and it’s works exceptionally well even when many pods are active. https://github.com/golang-migrate/migrate
-
Project mention: Usql – Universal command-line interface for SQL databases | news.ycombinator.com | 2022-12-30
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
-
Project mention: A Go (Golang) Backend Clean Architecture Project | reddit.com/r/golang | 2023-01-08
Try this
-
-
SQL code generator (aka inspect a database or SQL files to generate data models). You have the option of using something like volatiletech/sqlboiler which looks at the a physical database and generates code based on the schema. Or SQLC which is an amazing and fast project.
-
We built a GUI based solution called https://github.com/bytebase/bytebase. You may also take a look.
-
-
octosql
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Project mention: Show HN: ClickHouse-local – a small tool for serverless data analytics | news.ycombinator.com | 2023-01-05Congrats on the Show HN!
It's great to see more tools in this area (querying data from various sources in-place) and the Lambda use case is a really cool idea!
I've recently done a bunch of benchmarking, including ClickHouse Local and the usage was straightforward, with everything working as it's supposed to.
Just to comment on the performance area though, one area I think ClickHouse could still possibly improve on - vs OctoSQL[0] at least - is that it seems like the JSON datasource is slower, especially if only a small part of the JSON objects is used. If only a single field of many is used, OctoSQL lazily parses only that field, and skips the others, which yields non-trivial performance gains on big JSON files with small queries.
Basically, for a query like `SELECT COUNT(*), AVG(overall) FROM books.json` with the Amazon Review Dataset, OctoSQL is twice as fast (3s vs 6s). That's a minor thing though (OctoSQL will slow down for more complicated queries, while for ClickHouse decoding the input is and remains the bottleneck).
-
space-cloud
Open source Firebase + Heroku to develop, scale and secure serverless apps on Kubernetes
-
Try: github.com/pressly/goose
-
xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)
Project mention: Help with XO's new templating, how to access fields and params | reddit.com/r/golang | 2022-08-23I am using the library xo to generate basic data retrieval code from a sql schema for a crud api.
-
upper.io/db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Project mention: [Hiring] Remote Golang job: Senior Backend Engineer (Go) at Horizon (Toronto, Canada) | reddit.com/r/jobbit | 2022-05-28You will be joining the expert Go team at Horizon, previously who in our spare time + for fun, authored OSS projects like chi (https://github.com/go-chi/chi), upper/db (https://github.com/upper/db), webrpc (https://github.com/webrpc/webrpc), goware (https://github.com/goware), and much more. Our Go codebases are extremely clean and the patterns we've built have been shaped over 7 years of writing production Go systems and open source projects. These are the patterns which we apply to our infrastructure at Horizon in our products Skyweaver and Sequence.
-
Project mention: New post: Is Prisma better than your 'traditional' ORM? | reddit.com/r/node | 2022-12-06
Would always go for a language agnostic migration tool, e.g. https://github.com/amacneil/dbmate to stay flexible and stay away from lock-in effects (besides sql).
-
Project mention: Advice on ORMs with REST/GraphQL & Hasura/PostGraphile implementation | reddit.com/r/graphql | 2023-02-01
Checkout GraphJin it's an automatic GraphQL to SQL compiler, you write your database queries in GraphQL instead of SQL and it compiles them into efficient SQL on the fly. Works as a library in GO and NodeJS. https://github.com/dosco/graphjin
-
algernon
:tophat: Small self-contained pure-Go web server with Lua, Markdown, HTTP/2, QUIC, Redis and PostgreSQL support
-
-
Project mention: sqler: Write APIs using direct SQL queries with no hassle, let's rethink about SQL | reddit.com/r/himigifavievcu | 2022-07-29
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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 2023-02-01.
Go MySQL related posts
- PSA: For anyone having trouble narrowing down performance issues on your sites, use code profiler to find the culprits
- Prisma laying off 28% staff
- Database on a limited budget: Pay per-usage database or "cheap" config of Cloud SQL?
- Faster MySQL with HTTP/3
- Using Prisma Migrate with a Dockerized Postgres
- Usql – Universal command-line interface for SQL databases
- Managing external database versions in Kubernetes
-
A note from our sponsor - #<SponsorshipServiceOld:0x00007fea59451370>
www.saashub.com | 3 Feb 2023
Index
What are some of the best open-source MySQL projects in Go? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | tidb | 33,288 |
| 2 | vitess | 15,431 |
| 3 | dolt | 13,999 |
| 4 | go-sql-driver/mysql | 13,021 |
| 5 | gh-ost | 10,785 |
| 6 | migrate | 10,705 |
| 7 | usql | 7,815 |
| 8 | sqlc | 7,329 |
| 9 | go-clean-arch | 7,198 |
| 10 | kingshard | 6,138 |
| 11 | SQLBoiler | 5,551 |
| 12 | bytebase | 4,827 |
| 13 | orchestrator | 4,775 |
| 14 | octosql | 4,328 |
| 15 | space-cloud | 3,718 |
| 16 | goose | 3,405 |
| 17 | xo | 3,309 |
| 18 | upper.io/db | 3,244 |
| 19 | dbmate | 3,049 |
| 20 | graphjin | 2,585 |
| 21 | algernon | 2,176 |
| 22 | gormt | 2,108 |
| 23 | sqler | 2,021 |
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com