We utilize Supabase for managing our projects database.
Below are the functions used to interact with the Supabase database. These functions
can be found inside src/pages/dashboard/projects.js file.
If you haven’t already set up a Supabase database, follow these steps to create one using the SQL editor:
Visit the Supabase Dashboard: Go to the Supabase Dashboard and sign in or create an account if you haven’t already.
Create a New Project: Click on the “New Project” button to create a new project. Follow the prompts to set up your project.
Access the SQL Editor: Once your project is created, navigate to the SQL editor from the left sidebar menu.
Create a Table for Projects: Use the SQL editor to create a table named “projects” with columns for the project data, such as project name, description, etc. Here’s an example SQL query:
Copy
CREATE TABLE projects ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title TEXT, description TEXT )