1. Integrate
  2. Database

Integrate

Database

Setting up database in Supabase

  1. Setup Supabase Project

    • Create a Supabase account
    • Create a new Supabase project in the console.
    • Wait for the project to finish launching.
  2. Get Project API keys

    • Go to Project Settings ->API. Find your Project-URL, anon public and service_role. Copy and paste the values for the keys into your .env.local file.
    .env.local
            PUBLIC_SUPABASE_URL=https://your-project.supabase.co
    PUBLIC_SUPABASE_ANON_KEY=your-anon-key
    PRIVATE_SUPABASE_SERVICE_ROLE=your service_role secret
    
          
  3. Create your User Tables

    • Go to SQL Editor page in the dashboard.
    • Copy and Paste the SQL found in /src/lib/sql/database_setup.sql and click Run