commit | 69472d5f5cdca0fb2766d8d86f63cb2e78e1d869 | [log] [tgz] |
---|---|---|
author | Matthias Kadenbach <matthias.kadenbach@gmail.com> | Tue Oct 24 18:00:00 2017 |
committer | GitHub <noreply@github.com> | Tue Oct 24 18:00:00 2017 |
tree | 95e2fb634f711c60c8645420607f2397bb8614ba | |
parent | 5b98c13eff7657ab49a1a5f705b72f961d7fc558 [diff] | |
parent | 4ac3ee9d75ed2e4d73a81d0762c304b31ef61faa [diff] |
Merge pull request #301 from shaneodonnell/master Issue 247: Removed '(always included)'
Database migrations written in Go. Use as CLI or import as library.
Looking for v1?
Database drivers run migrations. Add a new database?
Source drivers read migrations from local or remote sources. Add a new source?
$ brew install migrate --with-postgres $ migrate -database postgres://localhost:5432/database up 2
GracefulStop chan bool
.io.Reader
streams internally for low memory overhead.import (
"github.com/mattes/migrate"
_ "github.com/mattes/migrate/database/postgres"
_ "github.com/mattes/migrate/source/github"
)
func main() {
m, err := migrate.New(
"github://mattes:personal-access-token@mattes/migrate_test",
"postgres://localhost:5432/database?sslmode=enable")
m.Steps(2)
}
Want to use an existing database client?
import (
"database/sql"
_ "github.com/lib/pq"
"github.com/mattes/migrate"
"github.com/mattes/migrate/database/postgres"
_ "github.com/mattes/migrate/source/file"
)
func main() {
db, err := sql.Open("postgres", "postgres://localhost:5432/database?sslmode=enable")
driver, err := postgres.WithInstance(db, &postgres.Config{})
m, err := migrate.NewWithDatabaseInstance(
"file:///migrations",
"postgres", driver)
m.Steps(2)
}
Each migration has an up and down migration. Why?
1481574547_create_users_table.up.sql 1481574547_create_users_table.down.sql
Best practices: How to write migrations.
Yes, please! Makefile
is your friend, read the development guide.
Also have a look at the FAQ.
Looking for alternatives? https://awesome-go.com/#database.