Hello @fgiordanelli! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Hello @fgiordanelli! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Hello, how can I use Supabase in iOS (Swift) - Android (Kotlin)? Is there any client?

Is there a specific process for updating a user phone number? (More details in thread)

Hello ! This thread has been automatically created from your message in a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

I'm getting this error when making a request using postgrest

{'message': 'permission denied for table clients', 'code': '42501', 'details': None, 'hint': None}

I have tried putting and removing the RLS to the table, and it keeps the error. It seems to be a postgres level permissions error, is there a way to reset to default permission settings?

Hello, is there any info about realtime concurrency in Supabase? Is Supabase able to handle 5K concurrent users (listeners etc..) with the basic plan (2GB Ram - 2vCPU)?

Getting following error when I am creating new table with 30 columns. (Free tire) Have a foreign key relationship with user table.

Hi guys! the supabase.getPublicUrl() method returns a URL without ?token={token} at the end of the URL, so it can't be accessed as img src. How can i get the url+access token which the Copy URL button in my app.supabase/project/storage/buckets/bucket-name returns?

Hi folks,

hey, I would like to know, is it possible to use custom domain at all?

Hello everyone, I have a function that returns values. How can I call this function from curl script point of view? I've tried this script but it didn't work

curl 'https://cbgccbohphtbbvnoecep.supabase.co/rest/v1/latestOilTracker?select=*' \
-H "apikey: xxx" \
-H "Authorization: Bearer xxx"

In the above script "latestOilTracker" is actually a function

Hey there! I don't see anything about the TTL of a Magic Link - just that it can be requested once every 60 seconds. When does a magic link expire?

Hi, why can't I see my own attendance if I use this policy?

ALTER POLICY "only own user can see attendance" IN public.attendance USING (( EXISTS ( SELECT 1 FROM profile WHERE (profile.id = attendance.profile_id) ) )))) ;

return empty from server . I just want to learn how the policy rules work. if I try

auth.uid() = profile_id

it works.

Is is possible to create a policy that a user can upload an image or modify that image, but only if it matches their uuid ?

anyone know if there is a section to download invoices on supabase? can't seem to find it.

Hey guys! I'm facing an issue updating a password on NextJs project. Basically, I have a reset password method that works perfectly. First I send an email with a reset link, that opens a page where the user can update his password like so:

js
const { error, data } = await supabase.auth.api.updateUser(token, { password: password.trim() })

the token being the one in the url. This works, but when I try to update the password for a logged in user, using the exact same method

supabase.auth.api.updateUser

, it fails to find the user; The difference is the token is the

session.access_token

So I've tried to use the

supabase.auth.api.updateUserById

method, but it gives me another error:

{ message: 'User not allowed', status: 401 }

Any ideas? I feel the docs about this is not very clear, and probably outdated as it doesn't show all the available methods :/

[SOLVED] Does anyone know what the rls policy for a SELECT would look like where the user should only be able to get their own data? The table they are selecting from has a

user_id

property that contains their id

hey

why isn't this working? "CREATE POLICY "ss" ON public.profiles FOR SELECT USING (auth.uid() = id);" I get "Error adding policy: operator does not exist: uuid = character varying" This is recommended in the doc, what am I missing?

Is there a way to get supabase to set the type as a

number[]

? When i set it as that it seems to get return as

type: 'array', format: 'ARRAY'

I need a locking mechanism for a table row to ensure that at most one of multiple potential concurrent serverless functions hitting supabase will win and then perform some external work that eventually results in a database update before any other serverless function modifies therow. I can think of several ways to do this with more traditional Postgres clients; what is the recommended approach with supabase? ...or is this cutting against the grain? I need the equivalent of a select_for_update atomic client-side transaction. I cannot put this in a stored procedure because the client-side transaction might fail and need rollback.

javascript
const mySubscription = supabase
  .from('*')
  .on('*', payload => {
    console.log('Change received!', payload)
  })
  .subscribe()

im using this push notification code from the documentation, and i set the trigger and the function in the supabase interface but im still not getting the console.log('change received'....

how can I validate what the user is sending the server? I'm currently using nextjs with client side code to write to the db. I'm using Yup for client-side validation, but I'm not sure how to do serverside validation with supabase.

Hey, can I apply two conditions to a RLS statement using

OR

? like this:

((is_public = true) OR (uid() = user_id))

How does postgres get the current authenticated user, i.e.

auth

to run checks in RLS policies?

Im trying to Host it on Raspberry pi 4. but it gives me this Error:

standard_init_linux.go:228: exec user process caused: exec format error

is there any tutorial/info on how to use supabase with RxJS? (angular) what I'm currently struggling with is how to continue my pipe, when the data gets returned as a promise

I want to do the RLS rule on storage that needs to make a call to the database table? Is that possible or do I need a backend for such check?

Hey guys, I'm trying to upload an avatar for authenticated users, but I keep getting this error:

error: "Key is not present in table \"users\"."
message: "insert or update on table \"objects\" violates foreign key constraint \"objects_owner_fkey\""
statusCode: "23503"

I'm not sure of what it means 🤷‍♂️ Maybe my policies are not properly set? Or could it be that the

roles=authenticated

property of the request is not understood by supabase? Any advice about this?