pnpm install
pnpm dev

Install the supabase CLI & docker.

supabase login
supabase link --project-ref ibkqxhjnroghhtfyualc
supabase start

Create a .env.local file with the generated API URL and anon key.

NEXT_PUBLIC_SUPABASE_URL=the-generated-API-URL
NEXT_PUBLIC_SUPABASE_ANON_KEY=the-generated-anon-key

See https://supabase.com/docs/guides/cli/local-development#database-migrations

See https://supabase.com/docs/guides/cli/local-development#database-seeds

After a change in the database schema, run the following command to regenerate the typescript types.

pnpm db:types

More info: https://supabase.com/docs/reference/javascript/typescript-support

Generate the seed file by running the script and then reset the database.

The script will automatically install dependencies and pipe the results into supabase/seed.sql.

pnpm db:seed
pnpm db:reset

Sync the database schema with the seed file.

pnpm seed:sync