Migrations

Notely uses goose to manage database migrations, that is, the process of updating the database schema so that the server can function properly.

Assignment

go install github.com/pressly/goose/v3/cmd/goose@latest
goose -version # should be at least v3.18.0

On the Databases tab in Turso, click on your database and copy the URL. It should look something like this:

libsql://notely-db-YOURNAME.turso.io

Paste it into a .env file in the root of your repo under the key DATABASE_URL.

The final connection configuration line will look something like this:

DATABASE_URL=libsql://notely-db-YOURNAME.turso.io

Don't forget to add your .env file to your .gitignore

turso db tokens create notely-db

DATABASE_URL=libsql://notely-db-YOURNAME.turso.io?authToken=YOURTOKENHERE

./scripts/migrateup.sh

turso db shell notely-db

PRAGMA table_info(users);

PRAGMA table_info(notes);

If everything looks good, you're ready to move on to the next lesson!