How do I apply SQL migrations in Go?

How do I apply SQL migrations in Go?

To apply SQL migrations in Go, you can use a library like 'golang-migrate'. First, install it using go get -u github.com/golang-migrate/migrate/v4. Then, create migration files and use the command line to apply them.

Can you show me an example of a migration file?

Sure! A migration file typically contains SQL commands. For example, to create a users table, you might have:

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

How do I run the migration from the command line?

You can run the migration using the command: migrate -path ./migrations -database 'postgres://user:password@localhost:5432/dbname' up. Make sure to replace the database connection string with your actual credentials.

What if I need to roll back a migration?

To roll back a migration, you can use the command: migrate -path ./migrations -database 'your_database_url' down. This will revert the last applied migration.