It's basic react context and all on github

that makes things easy

DELETE Policy is set to FALSE

Hello everyone. Just wanted to ask, is supabase a good option to use in production?

We are a property valuation company and want our ERP to be built. We're considering supabase as our backend.

Is it a good option?

an amazing option, it is all open source and based on proven tech

anything in particular you have an issue with?

I have a question regarding supabase realtime... In the docs https://supabase.io/docs/guides/auth it states: "Our realtime server doesn't provide per-user security. Until we build a more robust auth system for WebSockets, you can disable realtime functionality for any private tables." Does this mean realtime subscriptions are not using row level policies? Thanks...

Hi folks, I have truncated auth.users and that of course resulted in deleting all my data which is intended, but that also deleted storage, does that mean that the files are also deleted?

@User ☝🏻 please could you clarify this.

Using Supabase in Production

Hello everyone

does anyone know how to do role based auth in supabase? I want to have for example a 'admin' role besides the 'authenticated' role that I get by default.

Hello everyone, I’ve just created a supabase client for python as the current client has a lot of non implemented features and it hindered my project, so here is a client I created Repo: https://github.com/keosariel/supabase-client Documentation: https://keosariel.github.io/2021/08/08/supabase-client-python/

What's the recommended approach for users having their own folder in storage and only allowing them to edit (create, update, delete), but allow everyone to read? My thought is to grab the bucket, loop over all folders, and add a folder if one isnt present (for whatever user the operation was invoked by). Then after that, I can have the users files in a single bucket where uploading is accomplished by

supabase.storage.from('bucket_name/user_id_folder_name').upload('file.ext');

The part that seems awkward is determining if a user's folder exists in the bucket. As the number of folders (user id folders) grows, I end up having to loop over thousands and maybe more. I must be missing a way to search for a folder directly (where clause of sql query for example)

You can write security policies in SQL for both the db and storage

Hey, I'm watching the supabase crash course video and when you go to tables, you see everything (audit_log_entries, buckets, instances, etc.) but when Im on my tables, I'm only seeing the public schema tables - is that a UI/UX change and how can I access the users table (besides the auth tab)?

@erik_flywheel you can run queries with it... create a new query under the sql section

Yeah, that's what I'm doing now... Just ran a query to pull the entire table

but thought it would've been easier through the UI

@IvanCodes the policy for i/o to a user's own folder is a policy template but i didn't understand the part on creating a folder for the user

@erik_flywheel yeah, some things are like that.... but supabase is just getting started really. I've left via the feedback functionality (button in web cms) and they responded and actually implemented one of my suggestions

*left feedback

thanks, that's helpful. I know it's early stages, so absolutely no complaints. Pretty new to all of this, but I'd like to add some fields to the user's table instead of adding a profiles table. Having access directly to the users is pretty helpful

I've not used SQL policies with storage so you will need to ask someone who is sorry

What would a real world problem be that comes from real time updates not having restricted capabilities?