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

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 ~