What are SQL migrations in Go?

What are SQL migrations in Go?

SQL migrations in Go are a way to manage database schema changes over time, allowing you to version control your database.

How do I create a migration in Go?

You can create a migration in Go using libraries like 'golang-migrate' or 'goose'. They provide commands to create and apply migrations.

Can you show me an example of a migration file?

Sure! A migration file typically contains SQL commands to create or alter tables. For example:

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

How do I apply migrations to my database?

You can apply migrations using the command line tool provided by the migration library, like migrate up for 'golang-migrate'.