Just because we have enabled Supabase for our project, it doesn't mean that we have a way to actually
store data in the database.
And actually we have just connected our application to Supabase.
There is no database, there are no tables.
So there are things that we still need to configure.
So let's take a look at our project requirements and to do list and see if we find anything useful there.
Going into Settings and Knowledge I'm going to scroll a bit further down and take a look here at what
we have in terms of the setup.
So we're done with the first part with the setup.
Then we have here the second part create Supabase project create columns and card tables.
So there are a few things that we need to do here.
And we're going to say here okay work on task number two.
So this would be the best way to do this.
We're going to see here.
First on the screen are SQL commands that are needed to create the respective tables and to insert some
data in those tables.
It's going to tell us to review these SQL commands.
We're going to say okay just apply them.
We're going to see later if they actually work or not.
And now actually there is a problem.
This is something that lovable can figure out on its own.
There is some error that has occurred when lovable has tried to actually send this.
Just going to go here with whatever lovable wants in terms of this SQL and say, yeah, it's good,
just do it.
We don't want to get too deep into this.
I'm not going to tell us, okay, SQL migration was successfully executed and it's also going to implement
some changes.
And if we go inside our Supabase project, let's go ahead and refresh it for a second.
And I'll take a look here at database.
And we're going to see here that we have a table there.
Actually here in terms of the schema we have two tables a cards table and a columns table which does
make a lot of sense.
Let's take a look at a table.
Stem cells.
I'm going to see here the tables that we have.
It's also going to tell us exactly how many rows are in this table.
We currently says here we have zero cards and three columns.
So that's something interesting.
Okay.
Let's go back to lovable to see what is happening here.
Still applying a few changes.
Now it's telling us exactly what has happened.
There is here the discussion about an API service that has been added.
And this is probably being used to send data back and forth in terms of the data that we have here currently.
Let's see if this is working.
So we're going to add a new task which is called Learning Lovable and click here on add.
The task now appears on the board.
That is important but I'm going to click here on refresh page.
And if it's still there after we have refreshed the page means that this information has been stored
in the database itself.
If you're taking a look again at the database tables that we have.
We're now going to see that the cards table now has one row.
These are the columns that we have here in this particular table.
And we can also go here to the table editor.
And we can see here the various tables.
We have the cards and the columns.
These are some unique IDs.
Don't worry about them.
This is actually the name of the card that we have created.
So this demonstrates here that the information that we're seeing right here in our application is actually
coming from the database.
And this is such an important step because it opens up our application to many, many possibilities.
So this integration with Supabase is really amazing.
So if you manage to build your application and actually store data in the database, big thumbs up to
having any struggles with this.
Get back to me in the Q&A and I'll do my best to help you out, figure this out and understand exactly
what's happening.