Best way of handling recurring events through NextJs and tRPC
Hi, I'm working on a project that handles users' "bonuses" and I need to refill these bonuses every day (so, every 24 hours).
The easiest solution that I was thinking uses sql events so that they would modify the users table periodically.
However, I'm using PlanetScale which doesn't support stored routines (triggers, procedures, events...).
What's the easiest solution to this problem with this stack? Probably cron jobs are the way to go right?
What tech would you guys suggest using?
The easiest solution that I was thinking uses sql events so that they would modify the users table periodically.
However, I'm using PlanetScale which doesn't support stored routines (triggers, procedures, events...).
What's the easiest solution to this problem with this stack? Probably cron jobs are the way to go right?
What tech would you guys suggest using?
