Hi there, having some issues inserting a javascript object into a supabase JSON field. The error is "See the value of key 'FIELD_NAME'" when trying to insert the object {test:'a test'}, message: 'expected JSON array' and code: '22P02'. I've tried finding answers but no success. Stringifying the object first didnt help either.

my issue is definitly related to RLS

Valid json uses double quote (

"

) to surround keys and values, not single quote (

'

)

Gotcha moment -> i have enabled RLS, disabled it and it works

Thanks for the idea. I am creating the object with javascript though, single or double quotes will not matter if passing an object into .upsert() right?

if it's a JSON column, you might have to surround the whole thing with quotes:

.upsert({boplats_data: '{"test": "a test"}'})

oh yea, that makes sense!

Hi, say that i have a "School" and "Student" objects , the "Student" has a "school_id" reference , now when l query a student, how can l get the School object (instead of only the school_id) in the json response like this:

or should l just get the student --> retrieve the school_id from it --> then query the corresponding school seperatly?

Getting related record with Supabase

How to I order by random using the supabase client?

i wait more than 3-5 mins to receive the email confirmation, how can i make it less than 1 minute

Is it possible to redirect users that sign's up to a specific route? For clarification: I don't want to have the same redirect URL after signup as I have after signin

The signIn and signUp functions in the supabase-js client takes an additional parameter where you can state the redirectTo. You can see an example here https://github.com/supabase/supabase/discussions/2760#discussioncomment-1144158

Anyone having problems with login?

I mean the login at the website itself app.supabase.io It logged me out (my sessions was expired) 2 times in a row Then I started using it on a private window It just did it for the third time 🥲

An error has occured: 401

Ok it happened the fourth time. I'll try to change the browser, I'm using Brave Browser

Wouldn't that be what JSON.stringify does? Didn't help unfortunately 😦 Edit: Nice I got it working! I was using the wrong column type in the database- it's a bit confusing. I was using varchar[] (array) instead of JSONB column type.

I got logged out automaticaly for the #5 time. Now on firefox...

6th time 🥲 my session was timed out again. Any tips on this? I've already changed the browser and I'm using incognito mode Browsers: Firefox v91.01.04 Brave v1.29.77

Hi. The signup confirmation emails aren't being delivered. Is there someway I can check what is going on? The status page shows everything as operational.

I'm not sure if I should open a github bug report for this.

Are there any features missed by self-hosting a project besides the awesome web dashboard?

how to all delete data ? all database reset

is there a way to force delete all triggers? I keep getting an error everytime I delete

solved.

Could someone help with this issue? https://discord.com/channels/839993398554656828/869406062036529193/885270868849201152

pls copy what i put as the value for boplats_data - yours is slightly different edit: just saw your column type update! 👍