WEBVTT 00:01.920 --> 00:08.160 Just because we have enabled Supabase for our project, it doesn't mean that we have a way to actually 00:08.160 --> 00:10.240 store data in the database. 00:10.800 --> 00:15.000 And actually we have just connected our application to Supabase. 00:15.000 --> 00:16.720 There is no database, there are no tables. 00:16.720 --> 00:18.760 So there are things that we still need to configure. 00:18.880 --> 00:24.200 So let's take a look at our project requirements and to do list and see if we find anything useful there. 00:24.840 --> 00:30.560 Going into Settings and Knowledge I'm going to scroll a bit further down and take a look here at what 00:30.560 --> 00:32.920 we have in terms of the setup. 00:32.920 --> 00:35.360 So we're done with the first part with the setup. 00:35.360 --> 00:42.120 Then we have here the second part create Supabase project create columns and card tables. 00:42.160 --> 00:45.120 So there are a few things that we need to do here. 00:45.720 --> 00:50.080 And we're going to say here okay work on task number two. 00:50.240 --> 00:52.840 So this would be the best way to do this. 00:54.000 --> 00:54.920 We're going to see here. 00:54.920 --> 01:04.230 First on the screen are SQL commands that are needed to create the respective tables and to insert some 01:04.510 --> 01:06.030 data in those tables. 01:06.430 --> 01:08.830 It's going to tell us to review these SQL commands. 01:08.830 --> 01:10.750 We're going to say okay just apply them. 01:10.750 --> 01:13.390 We're going to see later if they actually work or not. 01:14.510 --> 01:16.590 And now actually there is a problem. 01:17.150 --> 01:20.350 This is something that lovable can figure out on its own. 01:20.790 --> 01:26.150 There is some error that has occurred when lovable has tried to actually send this. 01:26.390 --> 01:32.990 Just going to go here with whatever lovable wants in terms of this SQL and say, yeah, it's good, 01:33.150 --> 01:33.870 just do it. 01:34.550 --> 01:36.230 We don't want to get too deep into this. 01:36.870 --> 01:43.430 I'm not going to tell us, okay, SQL migration was successfully executed and it's also going to implement 01:43.430 --> 01:44.470 some changes. 01:44.510 --> 01:49.750 And if we go inside our Supabase project, let's go ahead and refresh it for a second. 01:50.270 --> 01:53.110 And I'll take a look here at database. 01:54.630 --> 01:57.470 And we're going to see here that we have a table there. 01:57.470 --> 02:05.430 Actually here in terms of the schema we have two tables a cards table and a columns table which does 02:05.430 --> 02:06.380 make a lot of sense. 02:06.420 --> 02:07.500 Let's take a look at a table. 02:07.540 --> 02:08.420 Stem cells. 02:09.300 --> 02:12.140 I'm going to see here the tables that we have. 02:12.940 --> 02:16.820 It's also going to tell us exactly how many rows are in this table. 02:17.140 --> 02:21.980 We currently says here we have zero cards and three columns. 02:22.900 --> 02:24.420 So that's something interesting. 02:24.460 --> 02:24.660 Okay. 02:24.660 --> 02:27.500 Let's go back to lovable to see what is happening here. 02:27.980 --> 02:29.500 Still applying a few changes. 02:31.100 --> 02:33.300 Now it's telling us exactly what has happened. 02:34.180 --> 02:38.580 There is here the discussion about an API service that has been added. 02:39.100 --> 02:47.780 And this is probably being used to send data back and forth in terms of the data that we have here currently. 02:48.060 --> 02:49.860 Let's see if this is working. 02:50.020 --> 02:54.700 So we're going to add a new task which is called Learning Lovable and click here on add. 02:55.420 --> 02:57.780 The task now appears on the board. 02:57.780 --> 03:01.420 That is important but I'm going to click here on refresh page. 03:02.060 --> 03:07.380 And if it's still there after we have refreshed the page means that this information has been stored 03:07.380 --> 03:09.050 in the database itself. 03:09.370 --> 03:12.730 If you're taking a look again at the database tables that we have. 03:13.010 --> 03:16.650 We're now going to see that the cards table now has one row. 03:17.690 --> 03:21.090 These are the columns that we have here in this particular table. 03:21.970 --> 03:24.770 And we can also go here to the table editor. 03:25.210 --> 03:27.450 And we can see here the various tables. 03:27.490 --> 03:29.370 We have the cards and the columns. 03:30.210 --> 03:32.090 These are some unique IDs. 03:32.130 --> 03:33.250 Don't worry about them. 03:33.250 --> 03:35.690 This is actually the name of the card that we have created. 03:35.690 --> 03:42.050 So this demonstrates here that the information that we're seeing right here in our application is actually 03:42.050 --> 03:43.570 coming from the database. 03:44.210 --> 03:51.450 And this is such an important step because it opens up our application to many, many possibilities. 03:51.450 --> 03:54.890 So this integration with Supabase is really amazing. 03:55.610 --> 04:01.570 So if you manage to build your application and actually store data in the database, big thumbs up to 04:01.610 --> 04:03.130 having any struggles with this. 04:03.450 --> 04:08.930 Get back to me in the Q&A and I'll do my best to help you out, figure this out and understand exactly 04:08.930 --> 04:09.770 what's happening.