Surprised to see no mention of this within the community.
I'd like to integrate an XP rewards system that facilitates the following:
allocating XP after a task
viewing total XP
'level' advancement based on XP (eg. LVL 9, LVL 10)
leaderboard feature
Currently, I foresee doing each via the following:
upon task completion: API call --> insert new Supabase row with awarded XP (eg. "10").
backend query --> filter user_id, get sum of all rows.
??
backend query --> sort by XP (sum of all rows), descending order.
Are there any more experienced minds out there who may have a better way of going about all this? Curious if there is a more creative way to approach this!