bingo

your correct man

thanks man for your response 🙂 ,

Hello guyss, So i tried creating a profiles for users a bit similar to what we can found on supabase quickstart with policies and buckets for an avatar. After that I began to create some way for the user to upload a photo for their avatar and then after uploading, I retrieved the photoURL of the uploaded photo and inserted it to the avatar_url of its corresponding profile table.... Now the problem is, when I try to get the photo via the URL, it shows 404 error..

Posted in the general channel before noticing this one, so cross posting here. Any help would be appreciated! https://discord.com/channels/839993398554656828/839993398554656831/873554158542794833

guys: even i change site Url as (http://localhost:3000/auth/login) , when im trying to click the email confirmation its always redirect me here (http://localhost:3000/#)

@Poypoypoy use additional redirect urls.

Hi guys, is it possible to call third party API within supabase or postgres? Eg. I want to create user in Stripe, when a new user is created in Supabase. When calling the create API within Stripe, i want to store the stripe user ID in my Supabase DB. Is it possible to do it with supabase?

How do I create a PostgreSQL function (that can be called using

supabase.rpc

) that will run the following query?

pgsql
select distinct on (view_users.id) view_users.*
from relation_meeting_people relation_meeting_people1
join relation_meeting_people relation_meeting_people2
on relation_meeting_people1.meeting = relation_meeting_people2.meeting
join view_users
on relation_meeting_people2.user = view_users.id
where relation_meeting_people1.user = 'p5W8EB2YKReYAJz334UGMDi6m9H2';

And will replace

'p5W8EB2YKReYAJz334UGMDi6m9H2'

with the

user_id

passed to the function?

PostgreSQL function

Third Party APIs

Hey everyone, apologies if some of this is pretty basic, but I come from a solid no code background and I'm building an integration with Adalo, using Supa as a the backend. Going to have a lot of questions in the near future

first one is - does supa auth automatically create a uuid for each user and how do you get that value? when you create the profile table, it links to the uuid from the users table, but there isn't a table there

I tried to run a script to get the uuid, assuming it was hidden in the supa ui, but it said there wasn't a field for that

Yes it automatically creates a uuid everytime you create a user, I don't really know much about Adalo, but if it uses js then you can pretty much use all the pre made javascript code on your API tab, for example, getting user information should be

javascript
  const user = supabase.auth.user()

assuming you are logged in, then it retrieves the user info with uuid, but if you are not logged in it just returns null value

if anyone is into pair programming and wants to help a brother out - working on some middleware and was curious about my current archeticture on it.

yeah, im willing

Trying to understand some auth behavior. I am having users authenticate with discord. A user changed their email on discord and it appears that a new user was created. Which in turn had them no longer connected to their profile etc as I am using the user id to associate them. I was able to resolve this but is it expected behavior?

Auth - changed emails

with storage.from.createSignedUrl() - what is the max value allowed for expiresIn?

I reallyy don't know about max value, but I made mine to 31556926, which I searched in google as equivalent to 1 year

What kind of data should go in

user_metadata

vs the row for the user in the database? Is there a best practice either way?

Can I make custom auth provider? I'd like to still take advantage of RLS, but source the JWT elsewhere (I have my own auth provider). Easiest would be if Supabase supports generating tokens like firebase does using

createCustomToken

with the user ID and service token.

Hello, I have fully config the SMTP service using the information provided by AWS SES. But this service didnt work and keep showing" Error sending confirmation mail" while handling user registration. I have successfully sent test email via AWS SES to my mail box, and it's actually work. But when I set it in Supa, it got a problem. Anyone have experience in configuring AWS SES and supabase SMTP config??? Thank you.

okay, thanks for this. We can't embed JS into adalo, but I figured out why I couldn't find the id originally, the field was id, not uuid 🤦‍♂️

Hello ! Is it possible to use authentication using different tables. For example, for one app use the 'User' table to log in and in another app use the 'Company' table and in another app use the 'Admin' table?

Good morning, does anyone know how we can filter queries through the REST API? I see the example for range in the docs, but let's say I need to show all transactions for a company a user works for, how would I structure that API call?

Hi All, which would be the best way to restart my project from scratch and remove all current data and tables etc...

If I have a one to many relationship, how can I properly join and filter? What i have right now is

response_time, UserSites (Url, user_id)

but i'd like to filter the matches by the user_id