Question (tl;dr): After logging in to my Supabase-powered webapp (iOS PWA), users can’t save their profile — I get an error when trying to update the profiles table. Public member profiles load fine, so I suspect it’s an RLS or policy issue, but I’m not sure.
Goal: • Display member profiles publicly ( working). • Let users edit their own profile after logging in ( not working). • Profiles should be updated with the profile editor after login from dashboard. (independently from the is_visible value)
Problem: • Users log in successfully via Supabase Auth. • When trying to update an existing profile, I get error • The profile doesn’t get updated into the profiles table. • I don’t know if it’s due to RLS policy, schema setup, or client-side code.
Table Structure (profiles): • id: UUID (user ID from auth.uid()) • created_at, updated_at: timestamps • full_name, email, phone, etc. • is_visible: boolean • status: text (e.g. 'active') • is_admin: boolean (just one profile has it set to true) (Plus many optional JSON fields like services, address, business hours, etc.)
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.