Running migrations locally and remotely in Supabase - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to run migrations locally using Supabase CLI.

Supabase

supabase db [1]

Drag options to blanks, or click blank then click option'

Apush

Bmigrate

Cdeploy

Dstart

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'migrate' instead of 'push' for local migration.

Confusing 'deploy' with local migration commands.

The supabase db push command applies migrations locally to your development database.

2fill in blank

medium

Complete the code to deploy migrations remotely to Supabase cloud.

Supabase

supabase db [1]

Drag options to blanks, or click blank then click option'

Amigrate

Bpush

Cdeploy

Dstart

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'push' which only applies migrations locally.

Using 'migrate' which is not a valid Supabase CLI command.

The supabase db deploy command applies migrations to your remote Supabase database in the cloud.

3fill in blank

hard

Fix the error in the command to generate a new migration file.

Supabase

supabase db [1] new_migration

Drag options to blanks, or click blank then click option'

Apush

Bmigration

Cgen

Dmigrate

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'push' which applies migrations instead of creating them.

Using 'gen' which is not a valid Supabase CLI command.

The correct command to create a new migration file is supabase db migration new_migration.

4fill in blank

hard

Fill both blanks to run migrations locally and then deploy remotely.

Supabase

supabase db [1] && supabase db [2]

Drag options to blanks, or click blank then click option'

Apush

Bdeploy

Cmigrate

Dstart

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the order of commands.

Using 'migrate' which is not a valid command.

First, push applies migrations locally, then deploy sends them to the remote database.

5fill in blank

hard

Fill all three blanks to create a new migration, apply it locally, and deploy remotely.

Supabase

supabase db [1] new_migration && supabase db [2] && supabase db [3]

Drag options to blanks, or click blank then click option'

Amigration

Bpush

Cdeploy

Dstart

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'start' which is unrelated to migrations.

Skipping the creation step before pushing and deploying.

Use migration to create a new migration file, push to apply it locally, and deploy to apply it remotely.