Database - Supabase

​

Managing Projects with Supabase

​

Using Supabase for Database Management

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.

​

Fetching Projects

The getProjects function fetches projects from the Supabase database.

async function getProjects(supabase) {
  const { data, error } = await supabase.from("projects").select("*");
  if (error) {
    console.error("Error fetching projects:", error.message);
    return [];
  } else {
    return data;
  }
}

​

Adding a Project

async function addProject(supabase, projectData) {
  const { data, error } = await supabase.from("projects").insert(projectData);
  if (error) {
    console.error("Error adding project:", error.message);
  } else {
    console.log("Project added successfully:", data);
  }
}

​

Setting Up a Supabase Database

If you haven’t already set up a Supabase database, follow these steps to create one using the SQL editor:

1. Visit the Supabase Dashboard: Go to the Supabase Dashboard and sign in or create an account if you haven’t already.

2. Create a New Project: Click on the “New Project” button to create a new project. Follow the prompts to set up your project.

3. Access the SQL Editor: Once your project is created, navigate to the SQL editor from the left sidebar menu.

4. 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:

   CREATE TABLE projects (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    title TEXT,
    description TEXT
    )