Generate SQL with the Supabase Studio locally

[@Supabase]

**NOTE**: the `--local` flag is currently on the beta release channel, please use `npx supabase@beta db diff --local` or install the beta release following these steps: github.com/supabase/cli#install-the-cli

[@jtjt8777]

I actually just wanted to implement a better flow dev to prod. thx. I am wondering what is the official/recommended flow to sync sql function and trigger and edge function.

[@holycrimpsauce]

What does it mean to create a shadow database? Does the shadow database represent a distinct local db cleanly built from migration files? Does it leave artifacts somewhere on my system?

[@shafu_xyz]

how to pull in data that is in remote to local setup?

[@kamil_supabase_enjoyer]

I had the same question. Now they introduced something called branching. It looks helpful.

[@makl-the-oracle]

Idk man the -f flag just stopped working out of no where, always the same with you guys never anything stable just new random ass features constantly