Setting up custom user table and roles

Ask us anything How do I?
1

I’m using Supabase to authenticate users, but I saw it’s common practice to store custom data like name, profile info etc. in a separate table.

After researching a little more I saw someone recommending having a custom Users table that mirrors some data from the default auth.users

I would create relations to my Users table, rather than to the default auth.user table.

Would that work fine with WeWeb?
Even if I create a Roles table that is not directly related to the auth.users table?

2

I think at least roles should be referenced directly to the auth.users, the rest can in theory be whatever. I’d need to see a more in depth usecase.

3

How do you do it in your projects?

4

I do it as I suggested above :+1: every project is different, so there is no one fits all solution. As I mentioned, I do 1:1 Consulting for things that are specific like this it usually is best to talk about the project in question.