How would you store the total amount of points given to another user
I've come from firebase and my original structure was to store a field on my
userData
userData
called
points
points
. When a user gives another user points, this amount increments by 100.
I would then have a field called
pointGivers
pointGivers
where I would store the givers user data + how many points they have given in total.
I'm trying not to go back to my noSQL ways so how would you best do this?
Would the most sensible thing be to join users and their point givers via a table. In that table we'll store the givers data and the amount of points given and I'll just query that, or would you more SQL experienced guys also have a
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.