Supabase
Supabase is completely open-source. We'll be using Docker to self-host Supabase on our local server. This provides full control over your data and infrastructure while maintaining all the powerful features of Supabase.
Please make sure that Docker and Docker Compose are installed on your server and running before following this guide. Visit the official Docker documentation (opens in a new tab) for installation instructions if needed.
The database service used in our application is Supabase (opens in a new tab). Supabase is an open-source Firebase alternative. It provides a Postgres database with a RESTful API, authentication, and real-time capabilities.
To self-host Supabase using Docker, follow these steps:
Clone the Supabase Docker Repository
First, clone the official Supabase Docker repository:
git clone https://github.com/supabase/supabase-docker.git
cd supabase-dockerConfigure Environment Variables
Create a copy of the example environment file:
cp .env.example .envEdit the .env file to set your configurations:
# Database Configuration
POSTGRES_PASSWORD=your-secure-password
JWT_SECRET=your-jwt-secret-at-least-32-characters
DASHBOARD_USERNAME=your-admin-user
DASHBOARD_PASSWORD=your-admin-password
# API Configuration
API_EXTERNAL_URL=http://your-server-ip:8000
KONG_DNS_RESOLVER=8.8.8.8
# Studio Configuration
STUDIO_DEFAULT_ORGANIZATION=your-org-name
STUDIO_DEFAULT_PROJECT=default
# SMTP Configuration (for Magic Link auth)
SMTP_HOST=your-smtp-host
SMTP_PORT=587
SMTP_USER=your-smtp-user
SMTP_PASS=your-smtp-password
SMTP_SENDER_NAME=Your App Name
SMTP_SENDER_EMAIL=noreply@yourdomain.comStart Supabase Services
Launch all Supabase services using Docker Compose:
docker compose up -dCreate Database Tables
In your source code folder, you will find a folder named supabase. This folder contains the SQL files for the
database tables. Navigate to this folder and open migrations folder inside. You will find the SQL file named
RandomNumber_remote_schema. Open it and copy all of the PostgreSQL queries. Access the Supabase Studio at
http://your-server-ip:3000 and click on the SQL Editor tab. Paste the copied queries in the SQL Editor and click
on the Run button. This will create the necessary tables in your database.
Configure Authentication
Navigate to Authentication settings in Supabase Studio:
- Go to Authentication > Email Templates
- Configure the Magic Link template:
<h2>Magic Link</h2>
<p>Follow this link to login:</p>
<p>
<a href="{{ .SiteURL }}/auth/confirm?token_hash={{ .TokenHash }}&type=email"
>Log In</a
>
</p>- Set up Site URL and Redirect URLs:
Site URL = http://your-server-domain
Redirect URLs = http://your-server-domain/**Update Application Environment Variables
In your application's .env file, update the Supabase configuration:
NEXT_PUBLIC_SUPABASE_URL=http://your-server-ip:8000
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key
SUPABASE_SERVICE_ROLE_KEY=your-service-role-keyYou can find these keys in the Supabase Studio under Project Settings > API.
This completes your database setup on Supabase. You can now proceed to deploy your application.