I am storing the username temporarily in the user_metadata, my understanding is its not secure to leave it in user_metadata. but I can't figure out how to move this data onto my public table, The link above I think is telling me to make a trigger on the auth.user table? but when I try to do this I'm told I am not allowed to make a trigger on this table.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.