Skip to content

Latest commit

 

History

History
62 lines (41 loc) · 1.57 KB

File metadata and controls

62 lines (41 loc) · 1.57 KB

Supabase Database Adapter

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

How to setup 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

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
  1. 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 db push -p PASSWORD: Update database schema on supabase platform
  • supabase gen types typescript > src/adapters/supabase/types/database.types.ts --linked: Generate typescript types from the supabase project linked