Redirect To

api schemas

i have added this as an issue now https://github.com/supabase/supabase-js/issues/339

Hi there, newbie Supabase user here 🙂 I want to create admin panel for a web app. What is your recommendation if I want to login like usual in client side, then do administrative task in this admin panel? 1. Make much more complex RLS policies that check user's

isAdmin

column. So user can login with anon key clientside. 2. Send the JWT after client side login to serverside. Verify it. And do administrative supabase function with servicekey.

User undefined on refresh

how do I add a button to resend email confirmation?

Hi, is it possible to create multiple organisations with self-host?

Hi guys, I'm having a weird problem with RLS, I have a

recipes

table with a foreign key named

user_id

that is related to

users.uid

. Then I created a policy on top of

recipes

for users to be able to se only what they have created, so I wrote

(auth.uid() = user_id)

. The problem is I can't see anything in my app and the queries always return RLS policy error :/

RLS issue

Resend email confirmation

Admin panel rbac

Hey folks, it seems like

setAuth

doesn't actually return a user, given a valid access token? https://supabase.com/docs/reference/javascript/auth-setauth

setAuth

Am I reading the docs correctly that using the

rpc()

features is in alpha preview?

RPC feature

Anybody have a sec to help me with this? I'm new to plglsql:

create or replace function get_or_create_api_key(user_id uuid) 
returns setof api_keys
language plpgsql
as $$
declare 
  kk varchar;
begin
  select key from api_keys into kk where api_keys.user_id = get_or_create_api_key.user_id;

  if not found then
      select digest(gen_random_bytes(32), 'sha512') into kk;

      insert into api_keys(key, user_id)
      values (kk, get_or_create_api_key.user_id);
  end if;
  
  select * from api_keys where api_keys.key = kk;
end;
$$;

how do I return the result of that last statement?

Hey everyone 🙂 I'm running supabase locally and the api page at

localhost:54323/project/default/api

is getting a 401 when communicating with kong - is this a known issue with the local setup?

nevermind! Figured something else out

ugh, sorry, another question: so I wrote my RPC function and it seems to work nicely, but when I execute it from the client side I hit row level security violations

that same function from a few lines above

what am I missing?

You need to add "security definer". After "language plpsql" should be fine. This runs with privileges of the function owner versus user.

you're a legend! Thanks!

He is indeed a legend.

Is there a tutorial anywhere about how to set up Azure SAML?

Hey guys, I'm using NextJS + Supabase, and am setting up a CI/CD for the frontend with GH Actions. In my GH Action, I have a step where I

npm run build

the Next app before running

npm run test

. Problem: I get the error

Error: supabaseUrl is required

during the build step. This is happening because

createClient(process.env.NEXT_PUBLIC_SUPABASE_URL ?? '', process.env.SUPABASE_SERVICE_ROLE_KEY ?? '')

runs on the client-side and I haven't passed those 2 environment variables to the GH action. Solutions I'm looking at: a) Add prod DB environment variables to the GH action so

createClient()

doesn't throw an error. This feels too dangerous. b) Create a special 'test' environment and pass its env variables to the GH action. This sounds like a lot of work as I'll have to manually keep the test DB in sync with prod DB. c) Move

createClient()

onto server-side and expose the client instance as an API for my frontend to consume. This way,

npm run build

wouldn't need those ENV variables to build correctly. Is this even possible? Thoughts 🙂 ?

Hi I have a question how to reset the password of the project that I have created?

Reset db password

GH Action and Supabase