Can I set it up like this?

RLS policy for specific set of users

Guys Im sorry but realy I need help with Schema Cache, is making me crazy, I have a function named : "channels_admin" I see this function everywhere, if I run it from sql editor on supabase or pgadmin work at 100% when I call it by supabasejs I get error of schema cache but isn't possible because I pruned the entire docker settings, images, containers, volumes and then I builded again from 0

the only difference I fount is the order of parameters, in my creation query is: mail, idtoexclude, nlimit supabase api say the order is: nlimit, idtoexclude, mail

I tried with values in both position + I tried the name declaration as well, like: {mail: this.mail, idtoexclude: this.ids, nLimit: this.limit} but nothing work

Guys Im sorry but realy I need help with

What is the max size of file I can upload to supabase? and can I increase that size anywhere?

It is 50MB on the hosted platforms. There is no user option on the hosted platform, but it is a setup option on the server. https://github.com/supabase/storage-api/issues/16

would supabase block connections from a host? i've been able to connect to my supabase DB from repl.it for months, but since last night i just get a connection terminated unexpectedly error. the same code running on my home computer connects to supabase just fine

thank you

Is it possible to have push notifications with Supabase?

Push notifications

Is it possible to limit scope in the twitter oauth api using supabase? How can I just use twitter to verify account information without accessing information that people mute or block etc?

I guess supabase would need to start using the Twitter v2.0 api that has been just released for that. This is from the twitter dev portal.

ahh got it! Do you know if it's possible to even limit the scopes somehow within the twitter oauth app? I really don't need any of the extra functionalities except for just logging in to verify an account. I'm afraid especially lists and seeing what accounts people block/mute could be a turn off to signing up.

Hi all, can anyone clarify to me if with supabase there is a way to generate mail action links through the API in order to have total control over the templates sent to customers?

I am interested in the enterprise solution

algolia

twitter 0auth 2.0

0auth scopes

Generate email links

this simple trigger breaks my signup flow, when I remove it everything works again

any ideas?

I am trying to put all the security policies for storage as db migrations in version control. I am using the postgres user to create the policy on

storage.objects

I currently get the error

must be owner of table objects

. Is there a way to achieve this?

Hey everyone i'm new with supabase, I've installed everything on my vps with docker, I made the tutorial on app.supabase everything worked fine but now I got a 401 'Invalid authentification credentials' edit : Solved, typo in kong.yml 🙃

Hey, I am trying to implement “guest users” with supabase, but I am not sure what the best approach is. Essentially, the app I am working on should give the users of my users read and write permissions to some data. I don’t want to store any personal information of guest users in the database since they never actually sign up to use my app. Ideally it should feel like they are still in the app of my users, and are just using an "extension" to it. I am currently thinking of the following approach: - Guest users get authenticated via an API key. This should give them read permission. - When guest users want to post something (write data), upon attempting to post for the first time, I call an API endpoint where I use the regular supabase sign up api to create an account for them using a generated email and password. The email address is then returned to the users browser and stored in local storage. The password will be the same for all guest users. When signing them up, I store their organization_id that I extract from the API key in user_metadata. - This gives guest users write access to the same data as “real” users of the same organization (currently, I have policies and place where users can only read and write data of their own organization). I plan on further restricting it by introducing roles and adding them to app_metadata, but I haven’t thought this through yet. I don’t really like the idea of using a generated email and password and signing them up as users, but I can’t think of a better alternative. Any input on what I could improve would be appreciated. Ideally, I only want to store a user id, the organization id, and their role and somehow work with this data to authenticate and authorize guest users.

Hey, my hosted supabase.co instance has been down for a few days, I'm only getting cloudflare 522's back. There is nothing in the logs. I've tried restarting it but to no avail. Anyone able to hit it with a hammer? https://icokftgmqponupjkzirr.supabase.co/

Hello guys I'm working on a migration script that has rollbacks as well. If I create a trigger on auth.users through postgres user I can not drop the trigger and get the following error: must be owner of relation users I guess this is because auth.users is owned by super user and hence postgres can't drop the trigger. Anyway I can overcome this issue?

Migration rollback on auth.users table