Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I have a site with discord social auth enabled, but I need to get the referenced user_id (from `auth.users` via `auth.identities`), is it possible to get the user_id? 

Help

Perhaps, you can create a trigger on_user_create to insert into public.profile with user_id | discord_id

Wait, how would I get the discord id from the new user event though?

You can have a ON INSERT and UPDATE trigger that checks for the discord_id and populate that field within the `public.profile` table if it exists

I'm just using the `signinwithOauth()` function

you can add the trigger ON that table then right?

I don't use social auth, but the process should work

hm, no good on `new.raw_user_meta_data` at least

Use `raise log 'my value = %',new;` in your trigger function and look in postgres logs to see all the values.   But it would be whatever column name it is in for that table new.colname.   I don't use OAuth either so not sure where it goes to.  Some info like the OAuth access token are not stored at all for security reasons.  I don't think that table has raw_user_meta_data like auth.users.

Looking at that table it almost has to be under the column identity_data if it is there.


https://cdn.discordapp.com/attachments/1111097762247884852/1111121874424971314/image.png

thanks -- I'm on local for dev, but I guess I'll just have to push

Yeah, it is there, but I don't do local either.  It is in the file system somewhere.  But if your trigger is on that table the new.xxx means .xxx is a column name in that table.