Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

ah got it thx 👍 now it becomes more about terminology! 
do you store user profile information in the users table or the profile table?

I use both. Metadata like subscription level, etc in `users` and public profile infos like username, public mail, website in `profiles`

ah cool. how about account settings/prefs?

Haven't implemented that, but thought about that just today. I'm still unsure

I would add another table for security reasons. There are fields, which the user itself shouldn't be allowed to edit

i was just going to jam everything in the same table for simplicity but now i see value in separating private data to another table