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