Hi, With the API, can I easely see the structure of the database ? (Tables, colonnes, types, etc.)

Hi, does pgbouncer pooling support self-created database (not the default

postgres

one)? It seems NO as I tested.

Hey y'all, I've been working on getting the .contains and .containedBy filters to work with strings for awhile. Following the docs I'm able to use a reference array like [1, 5, 6] or even ["1", "4"] but when I try using one of the form ["a", "b"] I get "Error: invalid input syntax for type json". I've tried both json and jsonb types and neither works.

I recall seeing some example on role-based access through JWT's last week, I believe by @burggraf . Care to share the link again? Can not seem to find it .. Thanks!

How to order a table with multiple field? I tried to add multiple order(), but that doesn't seem to work

Anyone aware of a boilerplate or a guide on how to achieve multi tenancy (organizations) using the same database with the auth? Example: user can belong to many organizations, organizations has many projects

Hey guys, i created a Function Hook, to send a http request to an endpoint when i INSERT something into a table, but when i try to INSERT a row manually through HeidiSQL (postgres client) i get this error "permission denied for table http_request_queue". Did i forgot to do some config?

Hey I am stuck using the api - I can access the public tables but I have a schema called portal and need to access a table from there but I can't figure out the url to use url = "https://xxxxxxxxxxx.supabase.co/rest/v1/project_table?select=*&time=gte.2022-06-06T15:39:16" Gets this back - {"message":"relation \"public.project_table\" does not exist","code":"42P01","details":null,"hint":null} If I put portal.project_table I get the same but with public.portal.project_table does not exist

Hi everyone, I posted this thread https://discord.com/channels/839993398554656828/982328388897366066 on #869405720934744086 but I guess it makes more sense to ask for help here, I'm having issues with my db's roles after using prisma

Hello everyone 👋 I'm sorry I'm a bit stuck... I'm building something a simple version of a "youtube clone", and I'd need some help with policies. I'd like to make the video file only accessible if the related

videos

table that is linked to the file, says it's "public". More about this structure in this thread

Is it possible to find the

user_metadata

somewhere in the supabase Authentification? All I can find is email/phone/provider/created/last sign in/user UID

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.

Hello guys any idea why i need to json.parse the output of one of my table ?

const { data, error } = await supabase
          .from<definitions['users']>('users')
          .select()
          .eq('id', auth?.id)
          .limit(1)
          .single()
        if (!error && data) {
          console.log('user', data)
          main.user = JSON.parse(data as any as string) // TODO: Understand why it's needed
          // main.user = data
        }

Hello ! I'm trying to enable RLS for some table, and I got a knowed issue for

INSERT

, I get

message: "new row violates row-level security policy for table \"UserDatas\""

on error and even with

returning: "minimal"

and RLS for enable SELECT for all users, I get this error. Someone has a solution ?

Hi, I'm building an edge function that when invoked fetches some data from an external API and then pushes it to SupaBase's database. The issue here is, that fetching and parsing this data takes some time and it looks like the function instance is closed before it can finish running. How long does an instance of a function live? Any ideas on how to extend the lifecycle of a function/circumvent the issue?

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.

anyone had this issue on angular supabase sample app? error TS2345: Argument of type 'Blob | null' is not assignable to parameter of type 'Blob | MediaSource'. Type 'null' is not assignable to type 'Blob | MediaSource'

This might be a stupid question but is there some way to stop a client connection manually? Say I create a connection through

supabaseClient = supbase.createClient(url, key)

, is there a way to go supabaseClient.disconnect() ?

Hi, I am trying supabase for the first time and am following the Auth example for React, however everytime I try to signup I run into a CORs error on localhost - has anyone else encountered this?

wanted some advice on querying the database. If I want to get a record that has foreign keys and fold the inner-joined data in the response, is there a nice way to do this? I'm assuming I need to use a function, but not sure what the return type is if I have all the additional data present in the SELECT

Question for anyone who might have time. I have been working on a web app using Supabase. I have configured Google Auth with Supabase for this project. I'm able to authenticate correctly and what not on the web client. I have decided to start building a companion app for Android/iOS using Flutter. When I try to authenticate with the Flutter application I am getting an error about my application not being allowed. My guess would be that my Google Client is set for web applications? I know I can create a second set of credentials for mobile, but I don't see a way in the supabase admin to set more than 1 credential set. Anyone who can point me in the right direction would be greatly appreciated.

My guess would be that my Google Client is set for web applications? I know I can create a second set of credentials for mobile, but I don't see a way in the supabase admin to set more than 1 credential set. Anyone who can point me in the right direction would be greatly appreciated.

Hey! I just heard of , and got started with supabase. Great experience so far! I have a table called

talents

and one of its column is of

INT[]

which is an array referencing the column

id

of another table called

skills

. When I run the following query it runs fine, but for the column

skills

I currently get for example [1,8,19], when I'd like to instead return its `name`column like ['Engineering','Python','Solidity']

let { data, error } = await supabase
    .from('talents')
    .select("*")
    .order('id', { ascending: false })
    .limit(5)

How would I modify above query to get the values from a foreign table?

is there a way to pause a project?

Hi, can supabase cloud hosting location be changed? I remember choosing it when I signed up, but I want to change the AWS hosting location from Mumbai to US now.

did anything changed to API between yesterday and now? my app suddenly doesn't work without any changes in the code. all patch(update) requests return 404 with empty array as response

Hi, I can upload file to my storage bucket. Migration failed. Reason: An error occurred running 'pathtoken-column'. Rolled back this migration. No further migrations were run. Reason: relation "storage.objects" does not exist

Hello @BENROBO! 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.

Hi, What's the size limit for the body of a request that triggers an Edge Function?

Hey guys, it seems that i uploaded some JPG images with a ".png" extension and with the "image/png" mimeType, is there any way i could update the name with the new .jpg extension and new mimetype? I tried to update the objects table but it gives me an error when trying to download the image via supabase studio