Supabase Database Adapter

Supabase is used to store contributor profiles and task information.

How to set up supabase project locally

1. To get started with supabase, you have to create a project at Supabase. Once you create a project, please put both variables into .env file.

SUPABASE_URL=XXX
SUPABASE_KEY=XXX

2. The Supabase CLI available as a node package through the dev dependencies provides tools to develop your project locally and deploy to the Supabase Platform. Most common useful commands are

• Run Supabase locally

bun supabase start

• Manager database migrations

bun supabase migration

• CI/CD for releasing to production

bun supabase db push

• Manager your supabase projects

bun supabase projects

• Generate types directly from your database schemas

bun supabase gen types

3. Link the local project to the supabase project you created.

bun supabase link -p PASSWORD --project-ref PROJECT_REF

For more information about arguments, please go through here

Database Operation

• supabase migration new MIGRATION_NAME: It will create a migration file in supabase/migrations folder.
• supabase migration repair <MIGRATION_NAME> --status reverted: Revert a given migration file.
• supabase db push: Update database schema on supabase platform
• supabase gen types typescript > src/adapters/supabase/types/database.ts --linked: Generate typescript types from the supabase project linked