61 lines (41 loc) · 1.65 KB

Supabase Database Adapter

Supabase is used to store bounty hunters profiles and bounties information.

How to setup supabase project locally

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

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

yarn supabase start

Manager database migrations

yarn supabase migration

CI/CD for releasing to production

yarn supabase db push

Manager your supabase projects

yarn supabase projects

Generate types directly from your database schemas

yarn supabase gen types

Link the local project to the supabase project you created.

yarn 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