I want to dump a large multi-hierachy JSON file there will that work?

how to check the post body came for API from logs

trying to create new bucket using Java SDK (newly beign created by me)

Hello, I managed to create my own OAuth flow to get OAuth tokens and user info with Twitter API. What's the best way to create a supabase user (to have RLS enabled)?

(I'm running sveltekit)

Hi Xavier . Not sure if this is helpful but I have just built a todo app with email authentication using sveltekit and supabase which includes email recovery and password change and selected access to the table using rls with policies (so specific users only have access to thier todo data). https://github.com/PaulAyling/svleltkit-superbase-todo

FYI I did get it to work in the end I think it was providing the invalid json error becuase I put something into the autonumber Id field. I got it to work now but looks like the validations was not working quite right

I'm connecting to the db with a connection string using my admin password, but when doing auth (using postgraphile), I set the role to authenticated after verifying the JWT, but it says I don't have permission to set the role to "authenticated". However, it works locally with the supabase cli. What could I be doing wrong?

I'm close to throwing away postgraphile and just using the supabase client, but I need to do some other backend stuff with the aws sdk

I'm super new with postgres, but I figured it out. It was super simple for anyone else that runs into this problem:

grant authenticated to postgres

or any other user/role you want

How can I execute an RPC call on NextJs SSR, but the user needs to be logged in. I already have the setup with auth Cookie, but I just need to know how I can apply that to the RPC call.

hi! im using the supabase client with angular to retrieve data from the supabase db. is there any way to get a sort of ORM like functionality where i will get either a fully assembled type or an error? right now i do a lot of manual checking to see if fields are present in the data that comes back from the db

so superbase is running postgresql can I use all the postgresql functions? As I tried this and got this result

documents is a text type with array checkbox on

array_append not working

Brilliant! Thanks Silentworks! The data type was indeed incorrce. changed it and it works.

I'm having trouble getting realtime updates to work. I enabled replication on every table (1) and subscribed to every event (2). I get heartbeat messages going back and forth over the socket, but no updates of any kind (3).

Hello! I have a question I hope someone can answer, I restored supabase using a backup and now, whenever I try to update anything on the table I get the error "permission denied for table http_request_queue". Anybody have any ideas?

Hello, this my first question on your Discord and i personally sponsored your awesome project ! ❤️ keep working team (sorry for my english btw) anyway I would like to know if there is a (futur) feature to develop in a "dev env" ? I mean, if you could create you DB and set up your supabase for production and copy the set up for a dev version with differente KEY and sometimes copy paste the PROD DB to DEV DB ; again sorry if i'm not clear enought :/

Most of that work is occurring in the CLI I believe. https://github.com/supabase/cli/tree/main/examples/tour

I am trying to pull some data from supabase based on if the values are in an array. I cannot get it to work - any ideas?

let arr=[1,2,3]
        let { data: documents, error } = await supabase
            .from('documents')
            .select('*')
            .in('id', arr);

the field in documents is called "id"

resolves an empty array

no error

the Ids are 8 bit ints. Is it a data type issue maybe?

I would check if RLS on, then if policy is valid if so.

thanks but rls is off (I like your logo image!)

.in not working

I need some clarification on how the redirect url works with creating an account. 1. User creates an account and they get an email to confirm. 2. They can click the anywhere there is an email client. My understanding is that I should create a deep link in my app to handle this and I can then create a custom schema. But what happens if the user then clicks the link on a computer?

I'm having a rough time getting multiple rows and I don't think I should be.

final PostgrestResponse res = await _usersEwkb
        .select(columns)
        // .neq("user_id", callingUser.userId)
        // .limit(16)
        // .withConverter((data) => UserModel.fromJson(data))
        .execute();

I keep getting

PostgrestError(message: JSON object requested, multiple (or no) rows returned, code: null, details: Results contain 2 rows, appl