|27 days ago||18 days ago|
|MIT License||Apache License 2.0|
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Is there a DB framework that can manage migrations like Ruby on Rails ?
4 projects | reddit.com/r/golang | 8 Jun 2022
Currently a fan of this one https://github.com/rubenv/sql-migrate
Go Echo API Server Development
4 projects | dev.to | 14 May 2022
db migration by sql-migrate
Most recommended database migration tool? using golang for the record
11 projects | reddit.com/r/golang | 4 Apr 2022
How do you install commands using go.mod
4 projects | reddit.com/r/golang | 2 Nov 2021
There are some packages in my project that are not used in the source code, but they're used as commands (i.e. https://github.com/vektra/mockery https://github.com/rubenv/sql-migrate).
What is the fastest way to clear my SQL database between integration tests?
5 projects | reddit.com/r/golang | 29 Jan 2021
Keep your migrations in the code repo and use a tool like sql-migrate to automatically apply them for you. At my job, we run a new container for each package's tests, and create a new db with the migration scripts for every test. It's certainly a bit slower, but the reproducibility is worth it.
Database character sets and collations explained – why utf8 is not UTF-8
3 projects | news.ycombinator.com | 5 Jan 2022
VARCHAR(N) can store N characters. So with utf8mb3, that's a max of 3N bytes worst-case. But with utf8mb4, it's now 4N bytes, which (with a high N) may exceed internal limits such as maximum length of an index key.
IIRC, there were additional problems in older versions of MySQL, situations where sort buffers were sized to a fixed length equal to the value's worst-case size or something like that. So sorting a large number of utf8mb4 values would use a lot more memory than utf8mb3 values (again, iirc, I might be wrong on this).
So the safer and more backwards-compatible approach was to introduce utf8mb4 as a new separate charset, and allow users to choose. MySQL 8 is now transitioning towards deprecating utf8mb3, and will finally make the utf8 alias point to utf8mb4 sometime in the near future.
That said, there are still a bunch of unpleasant uses of utf8mb3 internally in things like information_schema. I develop schema management tooling and recently lost a week to some of the more obscure ones in https://github.com/skeema/skeema/commit/bf38edb :)
Are entity framework tools typically avoided with MySQL & Go and are there alternatives for migration script tooling that version control the entire schema like SSDT?
2 projects | reddit.com/r/golang | 16 Nov 2021
I realize my paradigm on schema driven projects comes probably from my background. I found a very similar tool by chance when reading through my latest feeds and found this tool: https://github.com/skeema/skeema
What are some alternatives?
migrate - Database migrations. CLI and Golang library.
TinyGo - Go compiler for small places. Microcontrollers, WebAssembly (WASM/WASI), and command-line tools. Based on LLVM.
cockroach - CockroachDB - the open source, cloud-native distributed SQL database.
go-mysql-elasticsearch - Sync MySQL data into elasticsearch
noms - The versioned, forkable, syncable database
BTrDB - Berkeley Tree Database (BTrDB) server
tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try free: https://tidbcloud.com/free-trial
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
kingshard - A high-performance MySQL proxy