tern
The SQL Fan's Migrator (by jackc)
sql-migrate
SQL schema migration tool for Go. (by rubenv)
Our great sponsors
tern | sql-migrate | |
---|---|---|
12 | 9 | |
770 | 3,066 | |
- | - | |
5.6 | 6.7 | |
19 days ago | 15 days ago | |
Go | Go | |
MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
tern
Posts with mentions or reviews of tern.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-10-31.
-
database migrations
If you are using postgres and pgx you may want to use tern.
-
Database migration tool
Recently i started using turn its more fun (IMPO) compared to others tool available https://github.com/jackc/tern
-
How do you handle migrations ?
We use https://github.com/jackc/tern library (from the author of the pgx driver). We run migrations in k8s init containers and we do not do rollbacks (only up). Advantages over other popular solutions are:
-
what do you use for migrations? or how do you the sql tables and seeding?
I use tern! It’s the migrator tool written by the same author of pgx the de facto Postgres driver.
I’ve been happy with https://github.com/jackc/tern .
-
orms in go
I use tern for migrations. It’s from the same Author as pgx so everything in that ecosystem plays well.
- Is there a Go alternative to dbdeploy?
-
Does Go have a nice library for database migrations etc without necessarily being a full ORM?
I use https://github.com/jackc/tern + .env files which interpolate with its config for various environments.
-
What migration/versioning tool do you use?
Tern is a great language and framework agnostic solution for SQL migrations https://github.com/jackc/tern
- Most recommended database migration tool? using golang for the record
sql-migrate
Posts with mentions or reviews of sql-migrate.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-02-16.
- 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.
-
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.
What are some alternatives?
When comparing tern and sql-migrate you can also consider the following projects:
goose
migrate - Database migrations. CLI and Golang library.
skeema - Declarative pure-SQL schema management for MySQL and MariaDB
TinyGo - Go compiler for small places. Microcontrollers, WebAssembly (WASM/WASI), and command-line tools. Based on LLVM.
migrations - SQL database migrations for Golang go-pg and PostgreSQL
BTrDB - Berkeley Tree Database (BTrDB) server
noms - The versioned, forkable, syncable database
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
cockroach - CockroachDB - the open source, cloud-native distributed SQL database.
goose - A database migration tool. Supports SQL migrations and Go functions.
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.