DEV Community

Shunsuke | こばしゅん
Shunsuke | こばしゅん

Posted on

3 1 1 1 1

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 ~

Image of Timescale

🚀 pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applications—without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read full post →

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more