Has the team made any progress on appending items to arrays or modifying a single key of a json object via the client lib without having to fetch the objects before hand? aka something outside of the docs that i'm not aware of

Hey all! I'm working on setting up Supabase locally, and interacting with the db using DataGrip. I'm getting an error that 'relation "public.users" does not exist' when trying to query with the API. I posted the full details on Stack Overflow, but no luck yet. https://stackoverflow.com/questions/69304261/running-supabase-locally-with-datagrip-relation-public-users-does-not-exist

bump

Hi all, I have a sign-up from with fullname, email, and password. Right after

await supabase.auth.signUp(...)

, I tried to update

public.users

table to set the fullname, but * I set up to require confirmation * so, at this point, the user is not logged in yet * so, unauthenticated user fails to update the record because of row policy I made How do you normally deal with it?

Hi, I know that we do have authentication system using

email

and

password

to generate the token. is there any way we can use something like

access_id

and

access_code

with the same purpose, to generate the token ? Thank you

so, the project that i am working on, that the user can login to a web report portal system using

email

and

password

(JWT 1 hour expire) and also this user can login to a flutter app using

access_id

and

access_code

(JWT 1 day expire). I am struggling on how to set this up. any suggestion would be really appreciate ? Thanks

* ❓ Storage API question ❓* How would I go about fetching multiple files/urls (image in this example) with the Supabase Storage API? Do I need to make a separate request for each file/url?

@User what exactly are you looking for? How to setup the project? There are excellent guides for this: https://supabase.io/docs/guides/with-flutter The JWT (access token) is returned upon successful login, and when it is expired you can refresh it

You can save the user email and password (hashed preferably) on secure storage (keychain iOS and keystore Android) and retrieve them when you want to re-authenticate without the user having to re-login

Also in order to keep the token from expiring virtually never you can bind the refresh of it on the App lifecycle, so when the App returns from the background you refresh the token. That virtually guarantees that the token will never expire.

I'm implementing google auth provier in our project. Is it possible to change that URL or show something different? Doesn't look very trustworthy for users signing up

How can I set up auth on a self-hosted instance?

google login

Is it possible to define a custom OAuth providers?

does the postgres instance have any rate limiting? I think I got myself blocked and need to get myself unblocked 😂

There is a thread on here about rate limiting and from what I remember there is none at the moment.

maybe fail2ban, then?

Does anyone use magic link authentication for iOS/Android? I'm wondering how to open the app by clicking on the link generated by Supabase 🤔

@User check this out https://github.com/phamhieu/supabase-flutter-demo it has an example. I know it is for flutter but it will help, as well as these: https://supabase.io/docs/guides/with-flutter#setup-deep-links

Does auth work for self-hosted instances?

Has anyone resolved the permission issue on auth.refresh_tokens_id_seq trying to backup db? I have contacted support multiple times and almost two weeks no help.

I can't grant on it as I have no permission to do so

Backup DB

when you do queries in the supbase web interface, you have virtually unlimited privileges (queries run under the supabase_admin role)

Ok, gave that a try and was able to grant usage and select to that one sequence in auth that I didn't actually create and now the backup works, thanks!

Good to know the web is higher privs than postgres account given

Is there anyway to get same access via pgadmin?

you can be granting all privileges on all tables to the postgres user from the web interface, after which you can do everything from pgadmin logged in as postgres

what I do is create a separate schema for all my own tables and grant all permissions on that to postgres - this way you don't accidently delete or stuff up anything that supabase manages, like things in the auth schema, the public schema as so forth

Hi, I plan to deploy my web application in production mode, and I started to set up the google oauth, and Google required me to verify the domain of xxxx.supabase.co, how do I solve this problem?? anyone experienced before?