#FlutterFlow + #Supabase - Building a Goals Tracking App + Episode 3

In this bumper Episode we go all out #Supabase and commence creating our database project. We then focus on the detail and study the tables we are going to create. Next we create the actual tables to specification and then enter the world of Supabase policies to implement rules to restrict access to database operations. We also look at the token which gets exchanged between #FlutterFlow and Supabase. We also will create a table relationship and modify our authentication provider in prep for our next episode on getting authentication up and running between FlutterFlow and Supabase. There is a lot to get through! Hope you enjoy it!

If you love my content why not consider buying me a coffee, it's really appreciated:

00:00 Introduction
00:52 Creating a new Supabase project
01:45 Tables introduction
02:20 Goal table structure
03:24 Tasks table structure
03:57 Creating the Goals table in Supabase
05:21 Creating the Tasks table in Supabase
06:18 Introduction to Policies
07:11 Creating our Policies
14:36 Setting up table relationships
16:42 Enable Row Level Security (RLS)
17:02 Update the email provider
17:53 Outro

_____

(official launch in September, but welcome to join today 😉)

🎉 Your love is much appreciated ... A like to this video is like a High Five!!! Thank you all.

[tek]

You explain everything so clear that even someone who forces himself not to understand will understand it. I mean he has no chance of the opposite. 😄 Thank you for your efforts and time, sir.

[daviddrnovsky]

I would like to ask where do I find SQL conditional expression? As if I'm making completely new application I wouldn't actually know where to find these commands that Supabase undrestand. Also how to know that the according name 'sub' is the right name for the client/user in case without pressing Ctrl+Shift+I, because when I tried to do that in my unfinished app I couldn't find anything, probably because in the tutorial it was found in the fully made application if I'm not mistaken. Otherwise you're great teacher thank you very much for this tutorial / series - very helpful!

[Jasonsimson]

best tutorials on super base and flutterflow thank you.

[alanb]

Excellent concise and precise videos. Row level security explanation is the best I've encountered. Thank you.

[Koachie]

I am totally amazed by the quality of your tutorials! Using clarity and economy, you communicate complex concepts in a way that is immediately understandable and actionable. In addition, your efforts to make each tutorial as well-thought-out and professional as possible reflect your generous spirit and motivation to empower others to succeed. As I look for an alternative to Bubble, I genuinely appreciate the time and effort you put into these tutorials. I hope the positive feedback/comments confirm the difference you are making. OK. So I guess it's time to hit the refresh button (again) as I eagerly await your next tutorial! 😃

[DanVanDamme]

This is great! Thanks for sharing your knowledge. Are there any cases you would not use supabase and use firebase instead?

[SantiagoDigitalDesign]

would it be possible to add the code we should insert into our app within your description? The video gets a bit grainy and I can't see the code to know if or where the spaces are or what the characters are unless I pause, take a screenshot and zoom in on it.

Maybe you could make a future video for beginners on creating policies? I've never heard of JWT so that's where my knowledge stops for now. :)

Thank you for the content!

[cmcare]

Thank you so much for this tutorial!!! Can you create more tutorials on using flutterflow with supabase? There're so few tutorials on using flutterflow with supabase and I don't think FF is the most intuitive builder in the world :) Can you make a tutorial on how to connect/disconnect and query complex relationships with supabase? I think it's the main reason why ppl will choose supabse over firebase. Thank you!

[Dreysimmons]

great tutorial. Much needed. I want to ask though, do we always have to create the policies ourselves with those codes? Because some of us arent developers and dont have extensive knowledge in coding. Are the default policies ok enough to build and publish our apps? Or we should just stick to firebase since they handle most of these things for us?

[alieshkal]

thanks so much
can we follow by Firebase and have all settings as you did?

[jfcode]

Hi, Greetings from Quito - Ecuador. Thank you for sharing the knowledge, it is very valuable. Maybe you could make a tutorial to be able to generate a QR code with user information to be able to match with another user within the application. In advance my thanks.

[Bixbysalterego]

This process is entirely different now. It looks nothing like it does on your tutorial.