now just gotta get the values from the

INSERT

out

hello my dear supabase friends

I think its time for me to finally update my deno ports

to match the new code of the npm packages of supabase

Hello, is there a way to update a database row aswell as a row from a foreign table in a single request ?

I think there are 2 options: - define a stored procedure in PostgreSQL and invoke it via supabase().rpc() (https://supabase.io/docs/reference/javascript/rpc) - create a view and an associated INSTEAD OF trigger - that way you can still use supabase().from().update() but you would still need to setup a trigger function to actually carry out the inserts (https://postgrest.org/en/v3.2/api_writing.html#multiple-tables-insertion-or-update, https://www.postgresql.org/docs/13/trigger-definition.html)

Thanks for the reply. I will checkout those links !

Is anyone else having this issue trying to edit a value in the web client?

Is it possible to adding signed Up user full Name????? I mean, when the user was signed up to the system, they're should give their full name (FirstName and LastName) so i can show their full name on dashboard like this :

What would the appropriate channel to ask about backing up and restoring the supabase Postgress db via CLI?

I think there are 2 ways to achieve this: - the currently recommended way as suggested by Supabase's co-founder: https://github.com/supabase/supabase/discussions/556 - the signUp() method also accepts a third parameter for user metadata (you can pass a any field you want) which I think is then stored in the raw_user_meta_data field of the auth.users table;

a couple of important notes on the latter approach above: - since raw_user_meta_data is a JSONB field, it will not be easy to enforce uniqueness on any of its subfields; I think there are ways to do it, but it's not as easy as just adding a UNIQUE constraint; - I think the data in raw_user_meta_data gets inserted in the access_token of a user. This means that if you have long-lived access_tokens, it will be tricky to change the name (since the data in the access token is expected to be valid for the duration of the access token, regardless of any changes in the db) - You might be able to avoid both issues above is you setup a trigger which moves the data from raw_user_meta_data to another table as soon as it is inserted - just an idea, not sure exactly how to do it;

I am getting 1-5sec of latency on my hello world project. Is it due to free acount?

so based on this, i should creating

users

table and the id should be

UID

from authentication???

yes...maybe you should call it profiles, user_profiles or user_details to make it easier to differentiate from the original auth.users table

So FB requires a platform to be added in order to use the Facebook Login, the guide doesn't show a platform picked, should we go with web or depending on the usage mobile/web to add the correct platform?

#ASK Why i got this error when inserting data ????

"new row violates row-level security policy for table \"category\""
status: 403

guys, ive two redirect urls for auth, but only the first one works and the second one doesnt

can someone tell me why

RLS enabled

when doing an update to a row how does supabase know which row to change?

from my flutter code there isn't really anything here to say "change this" it should just do every row

I think its the row level security that stops it selecting the wrong thing

update which row

* dart code (I’m a stickler for details)

Is it possible to create rls policy based on an input? For example: allow insert if the inserted id does not exist yet

Hey all 🙂 I'm trying to migrate my supbase DB from cloud to my on-premise environment with no success does anyone have good tutrial for it?

hey guys can anyone explain shortly how can i add a scope to the current discord oauth?