I have setup my account for phone sign up and added my Twilio credentials. I am trying to call

signUp({phone:'+15141234567', password: 'some-password')

(with of course my real number) but I get the error

Error sending confirmation sms: json: cannot unmarshal number into Go struct field SmsStatus.status of type string

I tried restarting my server on the dashboard to no avail. Any clues?

Am I reading the documentation wrong? UPSERT isn't that update if exists or insert new?

anyone here using smtp with a google domain?

I can't seem to figure out how to run this query in supabase. The actual query is

SELECT u.first_name, u.date_of_birth, u.profile_picture_urls
FROM public.users u
         JOIN likes l on u.user_id = l.to_user_id
WHERE l.from_user_id = '34fca6cd-4c6e-49f5-87c7-e0e3ff461509'

I did something like this as a test

final PostgrestResponse res = await _supabase.client
        .from(_users)
        .select('*, likes!inner(*)')
        .eq("likes.from_user_id", callingUser.userId)
        .execute();

but I'm getting an error because there are multiple foreign keys. Any ideas?

hey all, I'm having trouble with database functions, I think it's an issue with case sensitivity...? Here's the function body:

begin
  update spells
  set timesPlayed = timesPlayed + 1
  where code = spellcode;
end;

I'm getting an error about how the column

timesplayed

doesn't exist, and maybe I meant

timesPlayed

(even though that's obviously what I have in the function). Any easy way to fix this?

hey all, i'm self-hosting a supabase instance and trying to figure out the proxy set up i need in order to make rest api requests from the JS client

hey community, is there anyone who know how to create live streaming with screen share, similar like google meeting? Of course with Supabase

Afternoon all Loving Supabase so far, though I've hit a potential snag with the local development setup. After much Googling, YouTube "tutorial" watching and head scratching I stumbled across https://github.com/supabase/supabase/issues/4440#issuecomment-1073853032 which revealed that the "Storage" menu option in Studio not being available with local

supabase start

is deliberate and not a bug as I first though. > but it should still work 100% through the API I don't know what this means. I've tried to create a dummy page to create a bucket called

avatars

, with the intention of then removing that code and implementing the actual functionality for updating/reading from that bucket. I get an RLS error. I cannot configure the RLS settings for Storage because Storage is not in my Studio, so I can't access "Storage > Policies" to configure it. Catch 22. Seems impossible to use locally? My question is this, can we currently only develop applications that need to use Storage by connecting directly to the cloud Studio? If not, and there is a way to use the Storage API locally, I would very much appreciate any pointers! Thanks in advance.

Has anyone use Supabase and Algolia?

Hi, is there any way for Supabase to send notifications (e-mail or text or something) to team members whenever a user updates a field in the database?

Does the .upsert() onConflict support something like DO NOTHING in stead of updating updated fields??

Geeze I can absolutely not get RedirectTo working in C# for magic links. I've got Additional redirect URLs copied identically to what I'm passing as RedirectTo, but it still just falls back to the site URL. If I manually change the magic link's redirect, I just get a 'User not found' message

Can I use Supabase with Jetbrains Datagrip?

Hello I am trying to delete a user from Users table on dashboard and getting this error message

Failed to delete user: update or delete on table "users" violates foreign key constraint "objects_owner_fkey" on table "objects"

i dont have any info matching to this user on any tables, ive gone through and deleted the table that did contain information

I'm having troubles trying to establish a direct connection (using a connection pool) 1) how can I reset the password 2) can I use a custom/dedicated user in the connection infos?

Does anyone know if you can change the API URL? https://kgfdgefherthrfbhtrr.supabase.co/ ? It looks unprofessional with this kind of url.

Is there a way to write a function in

plpgsql

which returns heterogeneous data? I've tried using

plv8

for this but

plv8

modifies nested arrays which ruins my data structure for the front-end (e.g., it turns

[['a', 'b', 'c'], ['d', 'e', 'f']]

into

['a', 'b', 'c', 'd', 'e', 'f']

).

is it possible to transfer a project across orgs?

Hey, is there any way how I can add a scope or permission-set to the jwt? Which the logged-in user can't modifiy and I can use this scope/permission-set in my nodejs backend. All tipps welcome.

Hi supabase friends! I'm currently building an app that works similar to Tinder, i.e. I have to fetch posts that are within a certain radius of a user's geolocation. Would love to hear how you would approach this the most efficient way. I came across this extension: http://www.postgis.net/docs/ST_DWithin.html, but interested to hear how you'd go about it!

Is there a security theoretic reason not to implement log in by 6 digit code sent over 2FA? The reason that I ask is that I would like to do magic_link style log in, but without opening a second browser tab, mostly for cognitive accessibility reasons. 🙂 hello

Hello! I’m using Supabase in my React Native app. We’re struggling with the async storage issue outlined here https://github.com/supabase/gotrue-js/issues/143#issuecomment-970288835 – specifically, we need a good way to distinguish whether supabase.auth.user() is null because there is no session, or if it is null because we are waiting for the token to refresh. This is a fairly consistent problem whenever the token expires while the app is in background – on app launch, we have indeterminate behavior as to whether the user is null, because it loads async from AsyncStorage. The only options I have been able to think of are to introduce a delay on app launch for any network dependent logic, or to modify gotrue-js to expose some sort of “is refreshing” state. I know that I can subscribe to the listener when the Auth State changes on refresh, but for cases where it’s determining logged in/logged out behavior, I would rather not flash the login screen if possible. Curious if there are any other suggestions – thanks!

Can someone help explain more about the policy for removing images server side from the supabase bucket?

Hello, Is there a way to write raw level security policies using JavaScript somehow (perhaps if we use something in between)? Any resources on this? The only way to meanigfully use supabase on it's own now is by writing SQL right? Thanks again

How would I detect the role of a user through the Supabase SDK from a JWT token (including service role and anon)? Would it just be

userData.data

since I know

userData.user

is null when an anon or service role token is provided. Also, what's the easiest way to forbid users from any database access and only allow function access?

Why am I not allowed to delete an auth user if I am using a NULLABLE foreign key that points to that user? Should it not just turn into null? I'm getting this message:

Failed to delete user: update or delete on table "users" violates foreign key constraint "todos_user_id_fkey" on table "todos"

Hi, I'm having trouble finding the signingKey for JWT decoding when launching supabase on local : "supabase start" (no problem with the cloud version, easy to find, easy to use) Do any of you know how to get it ?

Hey all, new to Supabase and Postgres. When trying to invite a user via the UI I now receive a

Failed to invite user: Database error saving new user

and 500 error in the logs. This is after adding a trigger to update my profiles table from user auth additions. I see it is a common error from a search, but I'm not sure what the solution for me is. Any suggestions?

Hey! Is it possible to use Ath without any service providers / email. Just with an arbitrary ID and password ?😊

How do I find my “JDBC direct connection string”? I want to connect using Jetbrains DataGrip