Gamification, XP/LVL records in database

Hello community!

I'm seeking technical help on this specific topic.
I can't find much information online so if anyone got experience here with games/gamification please help 🙏🏼

I'm preparing a gamification system for my app, I would like users to gain XP over time that will make their LVLs grow.

I've never done that yet and I don't know how I should record data.

If the XP grows over time, is it something I should record every X seconds, minutes, or hours to the DB continuously?

Or shall I update the XP information only when the user login?
Or I never need to record XP, this will only be calculated by the front end depending on how long the user has been growing its XP + the LVL he is at, therefore I would just save LVL records.

Then the same question for LVLs, shall I have a process always running to save records in a db?

Thanks a lot!