sql-migrate
BTrDB
| sql-migrate | BTrDB | |
|---|---|---|
| 9 | 1 | |
| 3,094 | 907 | |
| - | 0.2% | |
| 6.6 | 0.0 | |
| 17 days ago | over 2 years ago | |
| Go | Go | |
| MIT License | MIT License |
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.
sql-migrate
- GORM
-
How to seed database for testing?
I'd never did this with sqlite3, but I think sql-migrate should work (https://github.com/rubenv/sql-migrate)
-
Can anyone help me on how you are using golang with databases in production systems?
I use sqlboiler which generates an ORM from your database, and sql-migrate which is a tool for managing SQL migrations. Although you have to write your migrations in SQL, which IMHO is a plus.
- How to use sql-migrate in Kubernetes?
-
Is there a DB framework that can manage migrations like Ruby on Rails ?
Currently a fan of this one https://github.com/rubenv/sql-migrate
-
Go Echo API Server Development
db migration by sql-migrate
- Most recommended database migration tool? using golang for the record
-
How do you install commands using go.mod
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?
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.
BTrDB
-
Implicit In-order Forests: Zooming a billion trace events at 60fps
Check out http://btrdb.io/ which is a similar idea. It's a distributed database as well. It was designed for storing billions or even trillions of records for electrical data from hundreds of sources at once.
It was written by a couple of friends of mine and others, so I'm not sure how it compares to the article link, as I'm not a databases expert.
What are some alternatives?
goose
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
migrate - Database migrations. CLI and Golang library.
goleveldb - LevelDB key/value database in Go.
skeema - Declarative pure-SQL schema management for MySQL and MariaDB
Squirrel - Fluent SQL generation for golang
TinyGo - Go compiler for small places. Microcontrollers, WebAssembly (WASM/WASI), and command-line tools. Based on LLVM.
prometheus - The Prometheus monitoring system and time series database.
noms - The versioned, forkable, syncable database
xo - Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
rqlite - The lightweight, distributed relational database built on SQLite.