#Supabase
Vložit
- čas přidán 28. 07. 2024
- This is a 2024 update to how to automatically create a user profile in your #Supabase database when someone signs up for your #FlutterFlow application. I'll walk you through all the steps involved to get you up and running fast. This is part 1 of a 2 part video series. In the next one we will implement some basic RLS security to improve the security of your application.
Note: This is an update to a video I did in 2023 as the steps involved are now different from that video. Hope you enjoy it!
_____
Starter Project - app.flutterflow.io/project/n-...
Scripts which are used in the video:
create trigger new_user_trigger
after insert on auth.users for each row
execute function create_profile_for_new_user ();
BEGIN
INSERT INTO public.profile(id, email_address)
VALUES (NEW.id, NEW.email);
RETURN NEW;
END;
🔥 Looking for more content? Checkout the details below!
_____
Chapters
00:00 Introduction
00:39 Supabase Initial Setup
05:35 Trigger Function
08:02 Creating the Trigger
10:59 FlutterFlow Test
_____
🚀 The Digital Pro's NoCode Academy: www.thedigitalpro.co.uk
(Support the channel and go ad-free! 😉)
🔥 If you love my content why not consider buying me a coffee, it's really appreciated: www.thedigitalpro.co.uk/coffee
👍 Support the channel and grab yourself a free FlutterFlow account by clicking here: www.thedigitalpro.co.uk/flutt...
🎉 Your love is much appreciated ... A like to this video is like a High Five!!! Thank you all.
🔥Looking for more content, further content, and a helpful community? Why not consider joining The Digital Pro's #Nocode Academy at www.thedigitalpro.co.uk
On minute 7:10 that is kind of cool that you can add functions, bit similar to procedures in Microsoft SQL Server. Great content, thank you !
Hi Steve 👋 Following this great tutorial, could you make a video about Change Password for loged-in user and Reset Password for loged-out users? Should be really very useful! Thanks a lot.
Hi!
Thank you for your video.
I have a question.
How can I check if an email account already exists when registering again?
Flutterflow does not return any message stating this.
In Supabase it is already configured to not allow duplicate data.
Thank you very much for your attention.
Please help us with how to auth with anonymous in sups base and flutterflow
Excellent Video. Now how can we read the profile table from FlutterFlow ?
Hey Steve 👋 Thanks a lot for this video very helpful, I managed to reproduce the process in my project and that works fine.
However, I can't figure out how to make an email address UPDATE (which works fine from Flutterflow to Supabase auth table) propagate from the auth table to the public table? Thank you very much for helping.
[SOLVED] Needed to set the security dedicated update function to "Definer" instead of the default "Invoker".
Ah nice one yes this is correct. Glad its working.
how can we read the profile table from FlutterFlow?
Just like any other table in FlutterFlow.
Isn't it security definer means letting user calling the function with the privilege of the user who created the function? I would have thought security invoker will then allow the function to be calling depending on the front end user, which gives more security?
Could you make crypto news app please
Could u make crypto app please
Please please please
Could you make crypto news app please
The way it is done is no different from other applications.
Could you make crypto news app please