Supabase Database Cheatsheet

Supabase is an open-source alternative to Firebase that provides a set of tools to build scalable and secure applications. One of its key features is the Supabase Database, a powerful and easy-to-use database service. In this cheatsheet, we’ll explore some essential operations and commands to help you navigate and leverage the capabilities of the Supabase Database effectively.

Prerequisites

Before diving into the cheatsheet, make sure you have:

• Created a Supabase account.
• Set up a project and obtained your API key.
• Initialized your database and connected it to your application.

Connecting to Supabase

To interact with your Supabase Database, you need to establish a connection. Use the following code snippet in your application:

import { createClient } from '@supabase/supabase-js';

const supabaseUrl = 'https://your-project-id.supabase.co';
const supabaseKey = 'your-api-key';
const supabase = createClient(supabaseUrl, supabaseKey);

Replace your-project-id and your-api-key with your actual project ID and API key.

Querying Data

Retrieving Data from a Table

To fetch data from a specific table, use the select method:

const { data, error } = await supabase
  .from('your_table_name')
  .select('*');

Replace your_table_name with the name of your target table.

Filtering Data

Filter data based on a specific condition:

const { data, error } = await supabase
  .from('your_table_name')
  .select('*')
  .eq('column_name', 'desired_value');

Adjust column_name and desired_value to match your criteria.

Modifying Data

Inserting Data

Add a new record to a table:

const { data, error } = await supabase
  .from('your_table_name')
  .insert([
    { column1: 'value1', column2: 'value2' },
    // Add more records as needed
  ]);

Adjust your_table_name, column1, value1, etc., according to your table structure.

Updating Data

Modify existing records based on a condition:

const { data, error } = await supabase
  .from('your_table_name')
  .update({ column_to_update: 'new_value' })
  .eq('condition_column', 'condition_value');

Replace column_to_update, new_value, condition_column, and condition_value accordingly.

Deleting Data

Remove records from a table based on a condition:

const { data, error } = await supabase
  .from('your_table_name')
  .delete()
  .eq('column_to_delete', 'value_to_delete');

Adjust column_to_delete and value_to_delete as needed.

Real-time Capabilities

Supabase offers real-time functionality for your applications. Subscribe to changes in a table:

const subscription = supabase
  .from('your_table_name')
  .on('INSERT', (payload) => {
    console.log('New row inserted:', payload.new);
  })
  .subscribe();

Replace your_table_name and adjust the event type (‘INSERT’, ‘UPDATE’, ‘DELETE’) as required.

This cheatsheet provides a quick reference for common Supabase Database operations. For more detailed information and advanced use cases, refer to the Supabase documentation.

Supabase simplifies database management, making it an excellent choice for developers seeking a scalable and developer-friendly solution. As you explore and implement these commands, you’ll find that Supabase empowers you to build robust applications with ease.

FAQ