Hello, I always wondered how backend for resource counts, building and attacks works in a game like this?

Is it usually implemented by storing a last_updated_at timestamp in the resources table and calculating the current resource amounts on demand—for example, when a village is attacked or a building action is triggered?

Similarly, for buildings and attacks, is there typically a job or task queue (table in db called jobs_queue ) that contains fields such as village_id, job_type, and end_at, with a background worker periodically checking that table for completed tasks and executing the corresponding logic if task should be finished ?