User Roles with Supabase

Ask the community
1

Hello,
I have two questions.

  1. how can I use condition-based user roles in Softr with Supabase?
    I have a table “profiles” which is connected to auth.id and contains a role in the field “role”.
    But in Softr I can only access the Auth → Users table.
    Is there an instruction for this?

  2. what is the best choice of database for Softr with unlimited rows?
    Supabase and Softr do not seem to be suitable for each other.

Best regards
Joerg

1 Like
2

Hi Joerg,

Thanks for reaching out.

You can create custom user groups from the User Groups section for each role that you have in Supabase. Please check this article for more details on how to create custom user groups.

There is no data source in Softr that supports unlimited roles. Each plan supports a different number of records per data source. For example, in the Pro plan, Supabase allows 1,000,000 records, while in the Business plan, it allows 10,000,000 records.

image
image3420×1782 191 KB

3

Hi RedTiger,
I do not think that the issue is that they are not compatible.
The issue with Supabase is that the setup is a bit complicated.
Other users that use other tools are complaining about that too.

4

@RedTiger80 we have 100s of users and apps building on top of Supabase… what we haven’t supported direct supabase users as it’s artifitial layer… we see Supabase as PostgreSQL which it is and you can put any table with users and use as a user table