Is there a way to increase the timeout period of phone auth OTP? Many times the sms takes a long time to deliver by which time the OTP is not valid anymore.

Possible and kind of annoying bug on supabase studio

is this server still active?

is this server still active

Is there a way to have test numbers for phone Auth similar to the way firebase provides test numbers where the OTP is always 123456?

test numbers for OTP

I found.a parameter in supabase/gotrue repo but not sure how to use it

SMS_OTP_EXP - number

Controls the duration an sms otp is valid for.

What exactly does the table identities (under auth) do? Can it be used to implement multitenancy, for example?

What exactly does the table identities

I wanted to have one authentication system (think like google.com) but also have a bunch of projects branch from that (like youtube.com, google maps, google docs, etc). I was thinking of having one supabase instance and one schema per project, but in an ideal world I'd like to have multiple supabase instances (one per app) and somehow share the authentication data (first name, last name, etc) and maybe something like a shared subscription (e.g. amazon prime). Any ideas or suggestions?

@nahtnam You could use 1 supabase instance as your global authentication and use oauth to authorise the other instancs on a per user basis

I had a quick question regarding the pricing of edge functions. In the free tier, the runtime hours is 100. Is that monthly?

I believe it is

That's great. Thank you very much

just here to say that i love you guys

spent so much time trying to import to a non-supabase sql database. now, gonna try supabase and it'll probably be a one click import thing

(i hope so)

Is this something supabase supports out of the box or something I'd have to build myself? Couldn't find any docs about it

You'd have to build it out yourself unfortunately. You honestly might be better off just hosting something like Ory's products for your auth: https://www.ory.sh/docs/welcome

Then implement it as a custom oauth provider in supabase

Hmmm, that's actually what I was already thinking (ory kratos plus hydra) but I was hoping to see if supabase already has a viable solution

Let me explore how hydra works with supabase

Do you forsee any issues with the monolith method other than being a monolith?

Not that I'm aware of.

I don't think it has built-in support but I don't think it would take much to build entirely inside supabase

If you were feeling extra useful you could probably make a PR to supabase/gotrue to enable custom oauth2 providers, which could then enable a whole class of oauth2 fun. Supabase would just need to add the custom oauth2 option inside the dashboard.

The way I envision it would be on the auth supabase project, use something like the npm passport library to get some sort of oauth2 quickly running inside supabase functions. Then you'd just need to do some custom db functions to hook into that auth instance I'd say

Hello, I use Supabase for my Chat backend. When you start an instance, this instance is Highly Available ? Or do i need to manually create more instances in order to achieve HA?

hi there, i’m stuck on this for hours.. if any kind soul can help.. i have 3 tables a_investors (id, name, user_id) a_startup (id, name, user_id) a_investor_startup (id, investor_id, startup_id) an investor can only query in investor_startup when it matches his id. Likewise for a startup. Tried this but getting null on the frontend

CREATE OR REPLACE FUNCTION is_member_of_investorstartup(_startup_id int8, _investor_id int8) RETURNS bool AS $$SELECT

EXISTS (  
  SELECT 1  FROM a_investors_startups om  
  WHERE om.investor_id = _investor_id  
  AND om.startup_id = _startup_id)

;$$ LANGUAGE sql SECURITY DEFINER;

const { data, error, status } = 
  await supabase.from("a_investors_startups").select(          `id,a_startups( name )`);

is_member_of_investorstartup(startup_id, investor_id)

Any idea what RLS can achieve this?