@User would you happen to know what's happening with the second part of my question ("When signup is called, I'm getting no output in the console, and the page just reloads. Would you know what's causing that/how I could go about fixing/debugging this?")? I'm now getting this with both signin and sign up, and i'm not sure what's going on there

Regarding the signIn function, is there a Build in way to handle it as an PopUp ? Or in another Window ? 0.o

we've just started seeing the exact same problem within our app. noticed another report here: https://github.com/supabase/supabase/issues/4577

How can I check if a specific image already exists in the Storage?

I don't see anything in the SDK that can return a boolean if an object exists or not

The objects are stored in the table storage.objects, so u can check if the record exists.

Oh! So I can do supabase.from(‘storage.objects’)? Gotcga

is there a way for me to get the number of users with RLS?

do you mean "get the number of users, even if the users can't see other users"? You'll need a "security definer" function or view for that, they do bypass RLS.

Ok thank you

That’s exactly what I meant

Hey guys, Quick question regarding media storage: I'm working on basically a Google photos clone and am currently storing the filename in my db. When the user opens his photo-grid I have to call

createSignedUrl

for every single photo. Is that the intended way to store / retrieve media (in a private app) or am I missing something?

im trying to build a pokemon like game. i have user specific pokemon data in my supabase table (exp, species number) and then i have their base stats and abilities in a json file. how would i combine both datasets into a complete pokemon? ive thought about using a helper function but then id have to import it everywhere i want a complete pokemon. is there a better way to handle this?

Hello guys. Was the auto refresh token fixed for the js client? If i have a project with supabase auth, and i Let the page open for 1h, after i come back, i receive a jwt expired error. Do i need to catch the error and refresh it myself?

Auto refresh token

on a re-enabled database I'm getting:

"Invalid authentication credentials"

when doing

let { data: multiplayer, error } = await supabase
  .from('multiplayer')
  .select('*')

curl also throws the same for this operation. But other APIs work correctly. The anon key is correct.

Invalid auth credentials

What is the correct way to setup Supabase auth with Sveltekit (including server side auth)? There's a few tutorials out there, all of which seem to be doing something different. Is there a recommended way?

i don't know if there is a single, correct way of doing this, but most of the guides and repos i've seen uses similiar techniques, which sends the jwt to the server and sets the cookie with the sveltekit hook. here's a great guide about it https://dev.to/ashleyconnor/authenticated-server-rendered-pages-with-sveltekit-and-supabase-pif

the code for this article didn't quite work for me when i tried it, and i changed a few stuff. https://github.com/rmrt1n/auiss-nodejs-prototype this is working for me atm

js
    const { data, error } = await supabase.from("users").select(`
      cur_student ( 
        uuid,
        subject,
        students (
          abilities (id)
        ) 
      )
    `).limit(1).single()

this is how im querying a many to many relationship inside a foreign key right now and returns an object in the shape of

js
{
  cur_student: {
    uuid: 'fca886aa-1e75-4913-832f-3237703e4753',
    subject: 'sciences',
    students: { abilities: [Array] }
  }
}

what im trying to get is an object that looks like this

js
{
  cur_student: {
    uuid: 'fca886aa-1e75-4913-832f-3237703e4753',
    subject: 'sciences',
    abilities: [Array]
  }
}

how can i shift the abilities column up to my foreign key while still being able to query for it

I've faced the same question but did not find a way to do it. Ping me if you find the solution!

Hi everyone, I'm new to Supabase and attempting to spin it up with a brand-new Next.js project, but upon attempting to execute my first database query below, I'm getting error code 42501: "Permission denied for schema public."

import { supabase } from "../lib/supabaseClient";

export default function HomePage({ courses }) {
  return (
    <div>
      <p>Under construction...</p>
    </div>
  );
}

export async function getStaticProps() {
  const { data, error } = await supabase.from("course").select();
  console.log(data, error);

  return {
    props: {
      courses: data,
    },
  };
}

I have no role-level security set on any of my database tables, and I just created my database and first few example tables from scratch using the Supabase UI, so unfortunately I don't know where to start with how to fix this. I'm sure that I'm doing something wrong here, but I've read through the Supabase docs and I can't seem to find the solution. I very much appreciate any help that you can provide, thanks!

Hi everyone (& @User ) I've been banging my head against the wall with a new project in SvelteKit using the Supabase

auth

API. Sign-up & login work, but for some reason, I cannot access the

user

object on the client.

supabase.auth.setAuth($accessToken)

returns nothing—no error, no data. I've documented the problem here: https://github.com/supabase/supabase/discussions/4634#discussioncomment-1865642 Can anyone point out what I'm missing? Thanks!

Random question, but is the service_role not allowed to subscribe to changes? Subscribing to the wildcard doesn't seem to pick up on any changes, although I'm able to make changes to the database & bypass RLS. It's not that much of an issue though since I'm just using function hooks as an alternative, was just curious.

Are you trying to get the current signed in user's access token? You can do that with

<supabase>.auth.session().access_token

the example in the docs are for svelte only, the sveltekit approach is a bit different (to my knowledge at least, i've looked at plenty of examples online and all of them work in a similiar way). usually cookie based auth is used, and its set using the sveltekit hook. the user is stored in the server

session

object. You can access it through the

getSession

function during page load with the

load

function (similiar to getStaticProps in nextjs).

Hey guys Is there a way I can add a key value pair to the raw_user_meta_data column of auth.users when signing in using Magic Link from Nextjs client?

Adding data to user_meta_data while using magic link

SvelteKit with Supabase auth