Supabase Manual Setup Guide

Overview

This guide will walk you through the manual setup of Supabase for your project. Unlike the Automatic Setup Guide, which automates the creation of tables, functions, and policies, this guide provides step-by-step instructions for manually configuring your database.

By the end of this guide, you will have:

• A fully configured Supabase database
• Role based access control
• Manually set up tables, functions, and triggers tailored to your project

For a quicker setup, you may refer to the Automatic Setup Guide.

Database Setup

We need a database to manage customers, collect emails, authenticate users, and more. Our project will utilize Supabase, an open-source database provider that offers a full Postgres database, authentication, and various other features. Postgres is one of the world's most stable and advanced databases.

1. Set Up Supabase: Refer to the Supabase Setup Documentation to setup Supabase and add your Supabase keys to .env.local.

2. Supabase Roles: Refer to the Supabase Roles Documentation to create roles and manage user access.

3. Configure Supabase: Follow the Supabase Configuration Guide to create tables, set up RPC functions, and configure triggers to handle customers and payments.

This concludes the Supabase manual setup for StartupBolt. By completing these steps, including setting up the necessary tables, functions, and triggers, your application will be fully equipped to manage customer data and handle payments efficiently.

Blog Setup

StartupBolt includes a built-in blog with a dedicated dashboard for managing blog content.

Refer to the Blog Setup Guide to setup your blog.

Start Your Application

Once you have completed the manual setup, start your project locally by running:

npm run dev

Your website is now ready to be viewed locally. Open your browser and navigate to http://localhost:3000 (or the port your application is running on if different).

Next Steps

Proceed to the Essential Configuration guide to learn how to configure the rest of your StartupBolt website.

Final Remarks

You have successfully completed the manual setup. While this method requires more configuration, it provides deeper insight into how your database operates.

• If you prefer a streamlined setup, check out the Automatic Setup Guide.

Happy building! 🚀