Hey guys, I created a view using:

CREATE OR REPLACE VIEW projects_public AS
  SELECT P.id, P.name, P.description, P.instructions, P.created_at, U.first_name, U.last_name, U.avatar
  FROM public.projects P
  INNER JOIN public.user_profile U ON P.owner_id = U.owner_id
  WHERE P.visibility = 'PUBLIC'

And I read something saying views are public. So I'm not sure if is public PUBLIC or is public available to authenticated users. So, I tried to add authenticated only for this view...

ALTER VIEW projects_public OWNER TO authenticated;

But then I get an error:

Failed to run sql query: permission denied for schema public

Looks like this is not the correct way. What I'm doing wrong? Do I have to add this kind of role to access my view? Thanks

I am currently calling RPC from within a dockerized .NET server, but it seems like it's not working. It's giving me this weird error saying that no function can be found without parameters in schema.. but my logs says my parameters do exist... I wonder if there is some additional step I have to do if I am calling Supabase RPCs within a dockerized server. For reference, the RPC works in my local device, and other Supabase functionalities work. Wonder if anyone has encountered such issue with docker and supabase? IF ANYTHING - I can just migrate all my RPC calls to the front-end, but I really want to have it in the server for security and additional business rules.

Hi! I'm trying to upload an image to a storage bucket from the browser using the JS client api with a custom JWT, but it responds with the error "The parent resource is not found". I am setting my Supabase client up with a JWT header that I'm creating with NextAuth.js like so:

createSupabase<Database>(
  process.env.NEXT_PUBLIC_SUPABASE_URL!,
  process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!,
  {
    global: {
      headers: {
        Authorization: `Bearer ${supabaseAccessToken}`,
      },
    },
  },
);

Also, I'm running Supabase locally in Docker on macOS. If I remove this Authorization header, the upload does work. However, I can use this custom JWT to insert data into the database without a problem and access my custom JWT data in the RLS policies for my table, so it seems to only affect the storage API. (I want to be able to access my custom JWT data in the storage bucket policy too, but currently I'm using a storage policy that evaluates to

true

until I can get the upload working). Searching the error "The parent resource is not found" on Google only returns a single result: https://www.reddit.com/r/Supabase/comments/1137lru/how_to_upload_through_http/ Any ideas what this means or how to further debug?

Does supabase storage have a way to retrieve file/image metadata? Cloudinary/Imgix have dedicated calls to retrieve this, making it easy to store in database.

I'm having some problems with using an "in" filter in a realtime subscription, i'm pretty sure that there is no docs explaining how to use it in this case. I need help.

I try to set supabase realtime for my table but I get this error: failed to update pg.publications with the given ID: must be owner of publication supabase_realtime How can I fix this error?

I ran into the following error when updating my dependencies. I probably need to upgrade or downgrade a dependency but Idk which. Has anyone ran into this issue before? Only the web version of my react native app is failing. error:

Uncaught TypeError: Cannot read properties of undefined (reading 'decode')
    at new URLStateMachine (url-state-machine.js:541:1)
    at module.exports.basicURLParse (url-state-machine.js:1259:1)
    at new URLImpl (URL-impl.js:19:1)
    at Object.setup (URL.js:73:1)
    at new URL (URL.js:105:1)
    at new SupabaseClient (SupabaseClient.ts:104:1)
    at createClient (index.ts:38:1)
    at ./src/state/supabase.js (supabase.js:6:1)
    at __webpack_require__ (bootstrap:24:1)
    at fn (hot module replacement:62:1)

supabase config

js
import "react-native-url-polyfill/auto";
import AsyncStorage from "@react-native-async-storage/async-storage";
import appjson from "../../app.json";
import { createClient } from "@supabase/supabase-js";

export const supabase = createClient(
    appjson.supabase.url,
    appjson.supabase.anon_key,
    {
        auth: {
            storage: AsyncStorage,
            autoRefreshToken: true,
            persistSession: true,
            detectSessionInUrl: false,
        },
    }
);

hi devs i am facing this issue while removing domain from supabase this message clearly say i dont have any domain register but it show on supabase admin portal this cause issue in auth flow i have to remove

I am facing an issue in inviting the user. As a super admin i am inviting user using inviteUserByEmail. I want to redirect them to set password page where they can set their password and login. I am unable to set their password i assume it would require and access token or something which I am not getting in the url. #1006358244786196510

So I have a kinda hard problem that I don't know how to solve. I have 2 tables 1 publicprofile 2 profile publicprofile is a the same as profile but doesn't contain tokens know I am creating an admin panel but I need to access the private profile of other user. The question is is there any way to only return the private profiles of everyone if the user that is making the request is admin

Hi! I am currently evaluating Supabase for a Project where realtime Updates of the Dashboard would be real nice. As I wanted to caluclate the presumable cost, I wasnt sure what metric to apply tho. In the docs there is a "eventsPerSecond" param for the realtime options. If I were to set this to 10 and create a client that uses realtime Postgres Updates to stay on the newest version of data, would this be 10*60 = 600 Updates per minute, or just the actual number of changes to the DB Table? Thx!

I'm running supabase locally using the supabase CLI via

supabase start

. I'm trying to import createClient, SupabaseClient, and other objects from 'https://esm.sh/@supabase/supabase-js@2' to use within my edge functions. Using

supabase functions serve <edge function name>

results in this error:

error: TS2305 [ERROR]: Module '"internal:///missing_dependency.d.ts"' has no exported member 'createClient'

. This has never happened before, and I'm honestly not sure what I did to make this happen. Not sure where to begin solving this to be honest. I stopped and started my local supabase, updated the CLI, but nothing I can think of is working. Is there a particular reason why this is happening? This is my function. It is basically the default template, with the added import.

ts
import { serve } from 'https://deno.land/std@0.168.0/http/server.ts'
import { createClient } from 'https://esm.sh/@supabase/supabase-js@2' // <- causes the typescript error. seems like the types are not getting imported, which is weird, since this has never happened before.

console.log('Hello from Functions!')

serve(async req => {
  const { name } = await req.json()
  const data = {
    message: `Hello ${name}!`
  }

  return new Response(JSON.stringify(data), {
    headers: { 'Content-Type': 'application/json' }
  })
})

I need help using plv8 to query graphql and then create a custom resolver. Thank you

Hi all, I am starting my first project using nextjs13, where I plan to use prisma for any db operations and like to use supabase auth for user auth and management. I don't want to use "multischema" as by using multischema exposes all auth schema in the application. Looking any recommendations/pros and cons using "multischema" or using prisma and auth separately. Regards #prisma #multischema #auth

I am looking in to alternative, and wondring if Supabase is a good choice for application like (Social Network)?

can some give me pointers how can i use supabase and graphql as backend? i need to do some business logic for query result. i need to them in graphql resolver but really have no clue where to write custom resolver.

As described in documentation https://supabase.com/docs/reference/javascript/auth-onauthstatechange currently

onAuthStateChange()

doesn't work across tabs. But I suppose this is not true. I setup next js 13 project with app directory routing, wrapped

onAuthStateChange

in

useEffect

callback with empty array of dependencies, and added condition it

event === "PASSWORD_RECOVERY"

then show password reset modal. When I follow password recovery link, it opens in new tab, modal shows and everything is okay. Except one thing - this modal also opens in initial tab, from which I invoked the process of restoring password. So the issue here is when I reset password from newly opened tab (the one opened by following password reset link), this reset password modal closes after successful password reset, but on the initial tab (the one from which I initialised password reset procedure), password reset modal also appears and not closes until I manually go to this initial tab and close this modal. Is this expected behaviour of

onAuthStateChange

or I'm doing something wrong with my application state?

I have an application with 5 users. In the supabase dashboard I am seeing 3000 requests to

/token

per minute. I am using the Flutter SDK, is this normal? There must be something wrong?!

How can I make specific user as the admin and only let this account to do certain action, in this case, insert data into the database? EDIT: anon works and authenticated does not when inserting data into table with RLS setting "authenticated" as the target role

I've got this table I imported from a CSV, can i convert the moves and categories column to an array? I tried just marking it as array but there wasn't an option to specificy it should split on space's or anything like that

If i login with social provider, my tokens are saved in local storage so if i refresh i keep the session. If i login with email and password and i refresh, it lose the session. Why does this happen, and what are some ways i can handle this?

Hi, I'm wondering if there's a way to ensure uniqueness of a row based on multiple columns. i.e. each row must have a unique combination of two columns. In my case I have a bookings table which combines student_ids and lesson_ids. I want to ensure that there can only ever be one booking in the table for each student-lesson combo, in order to prevent the same user booking onto a lesson multiple times. Was wondering if I have to use triggers/functions for this or if I could use policies?

Hello, Where can I find documentation for all the api endpoints. I want to see all return status, error messages etc and the javascript references does not provide a detailed list of all possible params, return types and error codes that can be returned.

Hi, I’m using supabase-py package inside a python project. I called sign_up method a few times while testing and I’m getting: httpx.HTTPStatusError: Client error '429 Too Many Requests' for url 'https://aplakvklqzaywmdehpxc.supabase.co/auth/v1/signup' this is ridiculous. How can there be 429? I only made 3 requests this minute. Nobody will be able to use the database at all with such limitations. What is happening? I also created trigger & sql function on new user sign up

I am trying to secure an edge function I have deployed via basic auth. Its a webhook listener and i want to make sure people cant slam the webhook. I tried calling the webhook url via http://foo:bar@localhost:54321/functions/v1/function-name, but I'm not seeing the url in the request of the Edge function to be able to validate if the password if correct. I couldnt find any docs on this so Id appreciate anyones help! Thanks

I want to retrieve a random row that still complies with some criteria:

js
    const { data, error } = await supabaseClient
    .from("puzzles")
    .select("*")
    .eq('id', Math.floor(Math.random() * (50000)))
    .lt('rating', 700)
    .limit(1)
    .single();

I want to retrieve a random row from puzzle where the rating column has a value thats less than 700, how could i achieve such a thing?

My plan has 50gb of Database egress a month. I want to know how much is added to that when I retrieve values from the database using my client. What's a good way to check this? Should I just grab the size of the returned json in bytes? What's the overhead?

Hello everyone, could you please explain where is this function store in the architecture diagram? I'd like to learn how Supabase saves Edge function metadata in this function store.

Im singing up with email. If i delete the user from authentication section on supabase and i refresh the page. The user and session is still there

I have a table with public data like names and private data in it is there any way I can only return the private of all user if they are admin ? admin is a value that each user has that is boolean