I'm currently implementing a supabase spring boot starter and wanted to implement custom roles with GoTrue. My Idea was to store the roles as a JSON Object in the user_metadata or is it better to use the app_metadata column?
In the GoTrue-KT Library I'm using there is only the /user endpoint implemented: https://github.com/supabase/gotrue#put-user Am I correct that any user could just talk to the GoTrue Endpoint directly with his JWT and give himself a Role?
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.