Supabase makes it super easy to create new tables, and change the structure of your database over time!
In this video, we look at creating a lesson table, which will store our publicly available data for each lesson. We add a column for title
and description
, and input some basic test data.
Instructor: [0:00] Let's head over to the Table Editor to create our first table. Let's click "Create New Table." The name for this one is going to be Lesson. We have some automatically generated columns for ID and created_at, and we want to add a new column for our title, which is going to be of type text, and a column for our description, which will also be text.
[0:20] Now, let's click "Save" to create our new table. We can create some example lessons by clicking "Insert Row" and filling in our title and description and click "Save" to create that new record. Let's create another example lesson. Now, we have a Lesson table with some example data.