I want to make a real-time leaderboard and want to reset it daily. I wanted to know if I could handle that with Appwrite cloud's functions. If not, how could I solve this with (or maybe without?) appwrite?
I'm a bit confused on what to use functions for, is it solely to separate the backend of the website from the real backend where bigger and more fine-grained and specific processes run? Since I'm using node for the frontend, website backend (api routes) AND appwrite functions, I sometimes can't decide if something should be on appwrite functions or the api route in the backend of the website. Thank you!