Skip to main content

⚡ Supabase

Integrating a robust backend is essential for any application, enabling functionalities such as data storage, user authentication, and real-time updates. AppStruct simplifies this process by providing seamless integration with Supabase, allowing you to establish a powerful backend for your app in a few clicks.

Prerequisites​

Before proceeding, ensure you have the following:

  • AppStruct Account: You must be logged into your AppStruct account.
  • Supabase Account: If you do not have a Supabase account, sign up here.

Creating a Supabase Project​

Setting up a Supabase project is the foundational step for integrating your backend with AppStruct.

Step 1: Create and Log In to Your Supabase Account​

  1. Sign Up or Log In:
    • Visit Supabase and sign up for a new account or log in to your existing account.

Step 2: Initialize a New Supabase Project​

  1. Navigate to Your Dashboard:
  2. To create a New Project click on the "New Project" button.
  3. Configure Project Details:
    • Organization: Select your preferred organization. This represents the account context for your project. You can change it later if needed.
    • Project Name: Enter a unique name for your project (e.g., "AppStruct Backend").
    • Database Password: Create a strong password for your database.
    • Region: Choose a region closest to your target user base to optimize performance.
  4. Finalize Project Creation:
    • Click on the "Create New Project" button.
    • Note: The project setup may take a few minutes. Wait until the process is complete before proceeding.

Setting Up Your Database Table​

With your Supabase project ready, the next step is to create the necessary database tables that your app will interact with.

Step 1: Access the Table Editor​

  1. Navigate to Table Editor:
    • In the Supabase dashboard's navigation bar, locate and click on the "Table Editor" section.

Step 2: Create a New Table​

  1. Click on the "Create a new table" button.
  2. Configure Table Details:
    • Table Name: Provide a descriptive name for your table (e.g., "Users", "Products").
    • Description: Optionally, add a brief description of the table's purpose.
  3. Define Table Schema:
    • Columns: Add as many columns as required for your table.
      • Column Name: Enter a name for each column (e.g., "id", "username", "email").
      • Data Type: Select the appropriate data type (e.g., UUID, VARCHAR, INTEGER, BOOLEAN).
      • Default Value: Specify a default value if applicable.
      • Primary Key: Designate one column as the primary key by selecting the "Primary Key" option.
  4. Save the Table:
    • After configuring all necessary columns, click on the "Save" button to create the table.

Connecting Supabase API to AppStruct​

With your Supabase project and database tables set up, the next step is to integrate Supabase with your AppStruct project.

Step 1: Access Supabase Project Settings​

  1. In the Supabase dashboard, locate and click on the "Project Settings" section in the menu bar.
  2. Within Project Settings, find the "Configuration" chapter.
  4. Click on the "API" section to view API-related settings.

Step 2: Initiate AppStruct Integration​

  1. Return to the main AppStruct dashboard menu bar and click on the "Backend"
  2. Click on the Supabase icon to begin the integration process.

Step 3: Retrieve Supabase Credentials​

  1. Go back to the Supabase dashboard.
  2. Navigate to "Settings" > "API".
  3. Copy the "Project URL" and "Project API Keys" (specifically the "anon" key for client-side operations).

Step 4: Configure AppStruct with Supabase Credentials​

  1. Return to AppStruct’s "Supabase Integration"
  2. API URL: Paste the "Project URL" from Supabase.
  3. Secret Key: Paste the "Project API Key".
  4. Click on the "Get Schema"
  5. AppStruct will retrieve the database schema from Supabase, allowing you to interact with your tables within AppStruct.

Finalizing the Integration​

With Supabase connected, your AppStruct project is now equipped with a powerful backend. You can leverage Supabase's capabilities to manage data, authentication, and more within your no-code application.

Best Practices​

To ensure a smooth and secure integration between AppStruct and Supabase, consider the following best practices:

  1. Secure Your API Keys:
    • Treat your Supabase Secret Key with confidentiality. Avoid exposing it in client-side code or public repositories.
  2. Enable RLS for Production:
    • Always enable Row Level Security (RLS) before deploying your application to safeguard your data.
  3. Regularly Update Schema:
    • Keep your database schema in sync between Supabase and AppStruct to prevent discrepancies and ensure seamless data operations.
  4. Monitor Usage and Performance:
    • Utilize Supabase’s monitoring tools to keep track of database performance and optimize queries as needed.
  5. Backup Your Data:
    • Regularly back up your Supabase databases to prevent data loss and ensure data integrity.

Next Steps​

With your backend successfully integrated, you can now proceed to enhance your application by:

  1. Utilizing Database Requests:
    • Learn how to create and manage database requests within AppStruct to interact with your Supabase tables effectively.
  2. Exploring Supabase Extensions:
    • Enhance your backend capabilities by exploring additional Supabase extensions and integrations.

Need Assistance?​

If you encounter any challenges or require further guidance while building your app, please refer to the Documentation or, contact our support team at [email protected].

Happy Building with AppStruct!