SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Go MySQL Projects
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-trialProject mention: Ask HN: Who is hiring? (January 2023) | news.ycombinator.com | 2023-01-02
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/
Vitess is a database clustering system for horizontal scaling of MySQL.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.
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.
Dolt – Git for DataProject 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 MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)Project mention: Make Deno MySQL driver works better | dev.to | 2022-12-01
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.
GitHub's Online Schema-migration Tool for MySQLProject 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
Database migrations. CLI and Golang library.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
Universal command-line interface for SQL databasesProject mention: Usql – Universal command-line interface for SQL databases | news.ycombinator.com | 2022-12-30
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.
Generate type-safe code from SQLProject mention: You might not need an ORM | news.ycombinator.com | 2023-01-25
Go (Golang) Clean Architecture based on Reading Uncle Bob's Clean ArchitectureProject mention: A Go (Golang) Backend Clean Architecture Project | reddit.com/r/golang | 2023-01-08
A high-performance MySQL proxy
Generate a Go ORM tailored to your database schema.Project mention: ORM or no ORM (and which ones)? | reddit.com/r/golang | 2023-01-17
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.
Database CI/CD for DevOps teams. https://www.bytebase.com
MySQL replication topology management and HA
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-05
Congrats 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 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).
Open source Firebase + Heroku to develop, scale and secure serverless apps on KubernetesProject mention: Show HN: Algorithmic Trading for Everyone | news.ycombinator.com | 2022-04-21
A database migration tool. Supports SQL migrations and Go functions.Project mention: DB schema management strategy (migrations) | reddit.com/r/golang | 2022-10-25
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-23
I am using the library xo to generate basic data retrieval code from a sql schema for a crud api.
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-28
You 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.
:rocket: A lightweight, framework-agnostic database migration tool.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).
GraphJin - Build NodeJS / GO APIs in 5 minutes not weeksProject 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
:tophat: Small self-contained pure-Go web server with Lua, Markdown, HTTP/2, QUIC, Redis and PostgreSQL support
database to golang struct
write APIs using direct SQL queries with no hassle, let's rethink about SQLProject mention: sqler: Write APIs using direct SQL queries with no hassle, let's rethink about SQL | reddit.com/r/himigifavievcu | 2022-07-29
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Go MySQL related posts
PSA: For anyone having trouble narrowing down performance issues on your sites, use code profiler to find the culprits
2 projects | reddit.com/r/Wordpress | 1 Feb 2023
Prisma laying off 28% staff
5 projects | news.ycombinator.com | 22 Jan 2023
Database on a limited budget: Pay per-usage database or "cheap" config of Cloud SQL?
1 project | reddit.com/r/googlecloud | 8 Jan 2023
Faster MySQL with HTTP/3
2 projects | news.ycombinator.com | 6 Jan 2023
Using Prisma Migrate with a Dockerized Postgres
2 projects | dev.to | 1 Jan 2023
Usql – Universal command-line interface for SQL databases
1 project | news.ycombinator.com | 30 Dec 2022
Managing external database versions in Kubernetes
8 projects | reddit.com/r/kubernetes | 25 Dec 2022
A note from our sponsor - #<SponsorshipServiceOld:0x00007fea59451370>
www.saashub.com | 3 Feb 2023
What are some of the best open-source MySQL projects in Go? This list will help you: