Migrations

1. Install goose if you don't already have it.

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

2. 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

3. 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

4. Use the Turso CLI to get an authentication token:

turso db tokens create notely-db

5. Add the token to your connection string in the .env file:

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

6. Run the migrations, I created a nice little script for you:

./scripts/migrateup.sh

7. Once successful, use the Turso CLI to ensure the tables are there:

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!