Database

Supabase Integration

Supabase Registration Process

1. Visit Supabase Website

   • Open your browser and visit Supabase website
   • Click on "Get Started" or "Sign Up" button on the page

2. Create an Account

   • You can choose to sign in with GitHub or register using email
   • If choosing email registration, enter your email address and set a password
   • Complete verification steps (if any)

3. Log in to Supabase Console

   • After registration, you will be automatically redirected to the Supabase console

Creating a New Project

1. Create Project

   • In the Supabase console, click the "New Project" button
   • Select an organization (if this is your first time, you'll need to create one)

2. Configure Project

   • Enter a project name (e.g., "my-app-db")
   • Choose a database password (make sure to save this password)
   • Select a geographical region for your project (recommend choosing the region closest to your users)
   • Choose a pricing plan (free tier is available)
   • Click "Create New Project" button

3. Wait for Project Creation

   • Supabase will begin setting up your project, which may take a few minutes
   • Once setup is complete, you'll be redirected to the project dashboard

Database Design and Creation

1. Access Database Interface

   • Click on "Table Editor" in the project sidebar
   • Or click on "SQL Editor" to create tables using SQL commands

2. Create New Tables According to the project's:

   • migrations/supabase/auth.sql
   • migrations/supabase/navstack.sql