How to use Supabase CLI & Local Dev

ksyunnnn

Shunsuke | こばしゅん

Posted on January 3, 2024

How to use Supabase CLI & Local Dev

this is a memo for personal reference🙇


How to use on local machines

https://supabase.com/docs/guides/cli/local-development

encountered an issue 💫

I encountered an issue while using supabase start.

> supabase start Error: service not healthy
Enter fullscreen mode Exit fullscreen mode

It might be related to the problem reported here: https://github.com/supabase/cli/issues/1083

It was resolved by following these steps:

v4.23.0 The setting location had been moved.
Settings > General
Change VirtioFS to osxfs(Legacy) and disable Use Virtualization framework.
https://github.com/docker/for-mac/issues/6824#issuecomment-1726939831


Manage database

Add table

  1. Create migration by using supabase migration new create_some_table
  2. Edit {timestamp}_create_some_table.sql. and add query.
  3. Apply to databases by using supabase db reset.

If I changed it in GUI?

You need to apply difference to migration file by using supabase db diff -f {table_name}

Ref: https://supabase.com/docs/reference/cli/supabase-db-diff


And it might be continued ~

💖 💪 🙅 🚩
ksyunnnn
Shunsuke | こばしゅん

Posted on January 3, 2024

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related