Hello @joshcowan25! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

When I upload an imagine, I have my policies as public currently. But when I'm logged in, it seems like my URL to the image loses it access after 1 minute. Why is this so even though my policy is public?

const imagePath = `${userUUID.data.id}/${fileUUID}`

          const saveImage = await supabase.storage
          .from('editorjsimages')
          .upload(imagePath, file, { upsert: true })
          
          const retrieveImageURL = await supabase.storage
          .from('editorjsimages')
          .createSignedUrl(imagePath, 60)

I'm having an issue when signing with Github: Provider is not enabled

is it possible to manually insert users into the supabase users table?

can i connect supabase with bravostudio.app ?

I am having an issue inserting into a table with row level security. I understand why this is issue, but trying to figure out a workaround.

const { error } = await supabaseClient
      .from('todos')
      .insert(data, {
        returning: 'minimal'
      });

The policy I am using is below:

create policy "Enable users to manage todos." on public.todos
  for all using (auth.uid() in (select user_id from public.todo_users where public.todos.id = public.todo_users.todo_id))
  with check (auth.uid() in (select user_id from public.todo_users where public.todos.id = public.todo_users.todo_id));

I went down route of adding a trigger on insert to immediately add the user into todo_users but didn't seem to work (or I didn't do it correctly).

create function public.handle_new_todo()
returns trigger as $$
begin
  insert into public.todo_users(todo_id, user_id)
  values (new.id, auth.uid());
  return new;
end;
$$ language plpgsql security definer;

create trigger on_todo_created
  after insert on public.todos
  for each row execute procedure public.handle_new_todo();

How would you do complex backend / business logic with Supabase? I mean, if you need more than just a simple select? Would you rather create a separate backend? Or would you use Edge Functions?

I'm struggling to setup an external auth provider such as Google. I've tried Github as well and on both I keep getting unsupported provider. I'm doing this under the Next.js framework and am using valid oauth2 keys from both providers and have enabled it in the dashboard.

@silentworks Sorry for tagging you directly and please don't stress about responding. I saw that you mentioned that you use postgres.js. Do you ever use postgres.js with RLS and auth? I imagine I would pass the user ID from the session but haven't validated it yet. Also wondering if you have some pattern that's more ergonomic.

What if I want to use RLS but do not want to use any of the authentication system provided by Supabase? I don't want to bother with storing users email addresses in my database, so it's going to be a very simple process. I have a very simple authentication system which will store a bcrypt-hashed password in a table. In which, the user will have to provide the correct password in order to modify the row that they own inside the table. Is it possible to call a function (which will run a JS script) within RLS checks to make sure if the password and the hashed password stored in the database is matched before allowing update/delete access? This way, I can make sure that I can use the

anon

key almost exclusively just like you would when using supabase's built in auth systems. The way I handle this currently is by comparing the password and the hash server side but this means I have to use the secret key to obtain the hash to my server. I would like to avoid this since it means I have to potentially expose my secret key to Vite (SvelteKit) and eventually to the client.

Failed to run sql query: invalid input syntax for type uuid: ""

This issue is supposed to be fixed in https://github.com/supabase/supabase/issues/6971 But it's not for me. Getting this while trying to view data of a foreign key in the row insertion modal

Weird One, I've been using Edge Functions for a few weeks now and they've been working great. However, I edited a small part of one of them today (just a string literal) and on redeploy I'm getting a 502 error. Tried redeploying another function I didn't change at all. Same 502 error after re-deploy. Reverted to previous known working code + redeployed -- 502 error. Not sure what's going on. Functions I haven't redeployed appear to be working fine. Get the below error message when testing via Curl.

502: Bad Gateway (DEPLOYMENT_FAILED)

The deployment failed while serving the request.

I saw a few things on Github that this could be related to script memory / size limits,

deno compile ./myScript

produces an output file that is ~80MB in size, but again, this same script was working just a week ago. In Supabase GUI, there are no Logs present (even the one that should be printed on init), but I do see the Invocations. Any thoughts?

The supabase vercel integration adds the

NEXT_PUBLIC_SUPABASE_URL

NEXT_PUBLIC_SUPABASE_ANON_KEY

and

SUPABASE_SERVICE_ROLE_KEY

env vars. I am looking to get direct access (via the postgres client) to the database. I have been using the supabase connection string for this up until now but I'd like to automate it for my customers via the supabase integration. Is it possible to get the integration to provide the database connection string somehow? Or to get the connection string via the Supabase API?

My supabase app has google auth enabled and all the info is filled in but whenever i login using the JavaScript SDK i get an error sawing that google auth hasnt been enabled (and yes i saved the info) Error

{
  "code": 400,
  "msg": "Unsupported provider: Provider is not enabled"
}

My code:

async function googleLogin(){
        const { user, session, error } = await supabase.auth.signIn({
            // provider can be 'github', 'google', 'gitlab', and more
            provider: 'google'
        })
    }

Same issue as @Slen https://refrikdvbtkhrnenntkc.supabase.co/auth/v1/authorize?provider=google returning: { "code": 400, "msg": "Unsupported provider: Provider is not enabled" }

Is there a status code list?

Is there a way of updating a row in a table using the current values of that specific row in one query? For example I want to update

attempts

by +1 of its current value:

let {data, error} = await supabase.from("table").update({attempts: attempts + 1}).eq("email", email);

Or do I first have to fetch the data in one query and then update it with a second?

Is there a way to add multiple values from another table to a cell? I see that we can't add an array of foreign keys, but is there a workaround?

Hi i'm struggling with something, I have set the Site URL but if i go into users > Send password recovery the redirect link in the email still points to '&redirect_to=http://localhost:3000'. The odd thing is in my other project it works fine. Am i missing something ?

@User I am getting sorry, you have been blocked error from cloudflare

I'm suddenly getting CORS errors from supabase when sending updates/inserts through the API. no code or DB config changes on our end. is there an outage of some kind?

hello

Hi can i refresh my api keys ? i kinda commited them to github 😦

My Egde function who use Stripe SDK, stopped to work without changes in prod ! :/

is there a recommended way to migrate data from firebase firestore and storage over to supabase?

hey, launched a site and we're using supabase (which we love). was wondering if there was any way we could hire (on a freelance level) someone from supabase to take a look at our setup and ensure everything is secure?

Would like to call api and use that json to insert row on table. Would like to have function run on interval. Can you call apis from plpgsql? Can you run function on interval in supabase? I am familiar with the ability to seperately make a lambda function in my aws account that I can call apis and also could use supabase js to insert rows and call that lambda on interval. I know there are these new edge functions and just plpgsql funcs or lambda that I am familiar with. Any suggestions on way to go? Thanks

i get this

<title>Temporarily unavailable | *db-endpoint-here*.supabase.co | Cloudflare</title></title>

error page intermittently on DB reads. Is this a known thing?

Hi everyone - I'm still struggling with some elements of auth with Supabase. I'm probably missing something or just not understanding something. I have successfully set up sign up and sign in on my Express server. However, I cannot figure out how to persist the user in my app. Currently, if I sign up/sign in then everything is fine, but if I refresh the app, the user goes away. This makes sense because I'm storing the user data using React Context, but I can't figure out how to check if a user is signed in and then get that information back to my Context. I hope that made sense, but can anyone help/explain this to me?

hi everyone - im trying to write a policy to enable only the current row inserted to be returned. any suggestions?