1-How to Set Up a Supabase Project with Tables & Sample Data

Screenshot from the tutorial

Setting Up a Supabase Project with Tables and Sample Data: A Step-by-Step Guide

In this blog post, we’ll walk through how to create a Supabase project from scratch, including setting up a table and populating it with sample data. This tutorial is designed for beginners and will guide you step-by-step through the Supabase dashboard, help you define schema fields, and show you how to insert example rows to get your backend up and running quickly.

What is Supabase?

Supabase is an open-source backend-as-a-service platform that provides developers with a powerful and easy-to-use alternative to Firebase. It offers features such as real-time data synchronization, authentication, and storage, all built on top of PostgreSQL.

Getting Started with Supabase

Step 1: Create a Supabase Account

1. Visit the Supabase Website: Go to supabase.io.
2. Sign Up: Click on the "Sign Up" button and create an account using your email address or GitHub account.

Step 2: Create a New Project

Once you’ve signed up and logged in, you can create a new project.

1. Dashboard Navigation: You will be directed to your Supabase dashboard.

2. Create Project: Click on the “New Project” button.

3. Project Details: Fill in the project details such as:

   • Project Name: Choose a unique name for your project.
   • Organization: Select or create an organization if prompted.
   • Database Password: Set a strong password for your database (make sure to save this password as you'll need it later).
   • Region: Select the region for your database.

4. Create Project: Click on the “Create Project” button. It may take a few moments for Supabase to set up your project.

Step 3: Accessing the Database

Once your project is created, you will be redirected to the project dashboard.

1. Database Menu: Navigate to the "Database" section in the left sidebar.
2. Table Editor: Click on “Table Editor” to start creating your tables.

Step 4: Creating a Table

1. Add a New Table: Click on the “New Table” button.

2. Define Table Name: Enter a name for your table (e.g., users).

3. Schema Fields: You will need to define the schema fields. Below is an example schema for a users table:

   Column Name	Type	Constraints
   id	integer	Primary Key, Auto Increment
   name	text	Not Null
   email	text	Unique, Not Null
   created_at	timestamp	Default: now()

4. Add Columns: Click on "Add Column" to define each field according to the table schema above. Ensure to set the constraints as specified.

5. Save Table: Once you are done defining all the columns, click on the “Save” button to create the table.

Step 5: Populating the Table with Sample Data

After creating your table, the next step is to insert some sample data.

1. Insert Row: In the Table Editor, navigate to the users table, and click on the “Insert Row” button.

2. Add Sample Data: Fill in the fields with sample data. For example:

   name	email
   John Doe	john@example.com
   Jane Smith	jane@example.com

3. Save Row: Click on “Save” after entering the sample data. You can repeat this process to add more sample rows as needed.

Step 6: Viewing Your Data

To view the data you have just inserted:

1. Table View: Make sure you are still in the Table Editor and navigate to the users table.
2. Check Data: You should see the rows you inserted displayed in the table view.

Conclusion

Congratulations! You have successfully set up a Supabase project, created a table, and populated it with sample data. Supabase provides a powerful framework for building your backend without the complexities of traditional database management.

With this foundational setup, you can now explore more advanced features of Supabase, such as authentication, real-time subscriptions, and more. Be sure to check the Supabase documentation for additional resources and tutorials to further your skills.

Feel free to leave any questions or comments below! Happy coding!

Another view from the tutorial

---

Connect with SkillBakery Studios

Explore more tutorials, tools, and resources:

• skillbakery.com
• Facebook
• X (Twitter)
• YouTube Channel

Posted by SkillBakery Studios