Skip to content
This repository has been archived by the owner on Sep 19, 2024. It is now read-only.

Latest commit

 

History

History
61 lines (41 loc) · 1.63 KB

README.md

File metadata and controls

61 lines (41 loc) · 1.63 KB
Raw

Supabase Database Adapter

Supabase is used to store contributor profiles and task 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
  1. 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
  1. 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