The latest articles on DEV Community by Shunsuke | こばしゅん (@ksyunnnn). https://dev.to/ksyunnnn https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F42819%2F22b7a928-b9fe-48e1-a9cb-3f601975d9aa.png https://dev.to/ksyunnnn en Shunsuke | こばしゅん Wed, 03 Jan 2024 05:48:34 +0000 https://dev.to/ksyunnnn/how-to-use-supabase-cli-local-dev-5bic https://dev.to/ksyunnnn/how-to-use-supabase-cli-local-dev-5bic <p>this is a memo for personal reference🙇</p> <h2> How to use on local machines </h2> <p><a href="https://supabase.com/docs/guides/cli/local-development">https://supabase.com/docs/guides/cli/local-development</a></p> <p><strong>encountered an issue 💫</strong></p> <p>I encountered an issue while using <code>supabase start</code>.<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>&gt; supabase start Error: service not healthy </code></pre> </div> <p>It might be related to the problem reported here: <a href="https://github.com/supabase/cli/issues/1083">https://github.com/supabase/cli/issues/1083</a></p> <p>It was resolved by following these steps:</p> <blockquote> <p>v4.23.0 The setting location had been moved.<br> Settings &gt; General<br> Change VirtioFS to osxfs(Legacy) and disable Use Virtualization framework.<br> <a href="https://github.com/docker/for-mac/issues/6824#issuecomment-1726939831">https://github.com/docker/for-mac/issues/6824#issuecomment-1726939831</a></p> </blockquote> <h2> Manage database </h2> <h3> Add table </h3> <ol> <li>Create migration by using <code>supabase migration new create_some_table</code> </li> <li>Edit <code>{timestamp}_create_some_table.sql</code>. and add query.</li> <li>Apply to databases by using <code>supabase db reset</code>.</li> </ol> <h4> If I changed it in GUI? </h4> <p>You need to apply difference to migration file by using <code>supabase db diff -f {table_name}</code></p> <p>Ref: <a href="https://supabase.com/docs/reference/cli/supabase-db-diff">https://supabase.com/docs/reference/cli/supabase-db-diff</a></p> <p>And it might be continued ~</p> supabase docker