Supabase Tutorial | Building a Synced Profiles System

💡 Supabase Auth: Changes to default email provider : https://github.com/orgs/supabase/disc... 🚀 Sync Supabase Users to Public Profiles for Role Based Access in WeWeb Learn how to create a profiles table in Supabase’s public schema that auto syncs with the private auth.users table. Perfect for managing user permissions in your WeWeb app. What You’ll Learn ✅ Why auth.users can't be directly edited ✅ How to auto create profiles on sign up ✅ Use Supabase SQL Quickstart templates ✅ Set up secure Row Level Security (RLS) ✅ Map metadata like nickname and avatar ✅ Trigger functions for real time syncing ✅ Test workflows live inside WeWeb ✅ Extend logic for admin controlled updates Resources 📘 Supabase Docs → https://docs.weweb.io/plugins/auth-sy... ✨ WeWeb → https://www.weweb.io ❤️ Join the Community → https://community.weweb.io Chapters 00:00 Introduction 00:45 Why You Can’t Edit auth.users Directly 01:17 Supabase’s Public profiles Table Solution 03:01 Create Profiles Table and Trigger Function 05:35 Enable and Configure Row Level Security 08:04 Write a Triggered Function to Sync Data 10:21 Execute the SQL and Validate in Supabase UI 13:29 Test New User Signup from WeWeb 15:02 Map Nickname to Username Correctly 16:11 Final Thoughts and Extend for Admin Use Learn more about WeWeb: 🏠 Homepage: https://weweb.io/ 📣 Twitter: https://x.com/weweb_io ❤️ Community: https://community.weweb.io/ #weweb #supabase #tutorials #backend #frontend #nocode #webappdevelopment #backendwebdevelopment #backenddevelopment #webappdevelopment #weweb #authschema #publicschema #sqltutorial #userdatamanagement #webdevtools #codingtutorial #appbuilding