What are some examples of database migrations in Go?

What are some examples of database migrations in Go?

In Go, you can use libraries like 'gormigrate' or 'migrate' for database migrations. Would you like to see a specific example?

Yes, can you show me a simple example using 'migrate'?

Sure! First, install the package with go get -u github.com/golang-migrate/migrate/v4. Then, you can create a migration file like this:

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100) UNIQUE NOT NULL
);

And run the migration using:

m, err := migrate.New("file://path/to/migrations", "postgres://user:password@localhost:5432/dbname")
if err != nil {
    log.Fatal(err)
}
if err := m.Up(); err != nil {
    log.Fatal(err)
}

What if I want to roll back a migration?

You can roll back the last migration by calling m.Steps(-1). This will revert the last applied migration.

Are there any best practices for managing migrations?

Yes, it's best to keep migration files organized, use version control, and test migrations in a staging environment before applying them in production.