What are some examples of SQL migrations in Go?

Can you provide some examples of SQL migrations using Go?

Sure! In Go, you can use libraries like 'golang-migrate/migrate' for SQL migrations. Here's a simple example:

1. Create a migration file:

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

2. Run the migration using the command:

   migrate -path ./migrations -database 'postgres://user:password@localhost:5432/dbname' up
   

This will create the 'users' table in your database.

What if I want to roll back a migration?

To roll back a migration, you can use the command:

migrate -path ./migrations -database 'postgres://user:password@localhost:5432/dbname' down

This will revert the last migration applied.

Can you show me how to create a migration for adding a new column?

Absolutely! To add a new column, create a new migration file with the following SQL:

ALTER TABLE users ADD COLUMN age INT;

Then run the migration as before to apply the changes.

Are there any best practices for managing migrations?

Yes! Some best practices include:

• Keep migration files small and focused.
• Use descriptive names for migration files.
• Test migrations in a staging environment before applying them in production.