[DEV_HELP] I’m building a feature that involves scheduled tasks.

Hi Everyone!

I’m building a feature that involves scheduled tasks. I'd love to hear your ideas and opinions on how to better implement it.

1. Scenario:

• 1.1. Users can create a task for a specific date (i.e. scheduled date).
• 1.2. The task will be flagged open only when that scheduled date comes. Until then, it will be marked closed.
• 1.3. Once the scheduled date is over, this task will be flagged closed again.

2. Prerequisites:

I’m using the following technologies:

• React
• Firebase Realtime Database
• Firebase Cloud Functions
• Google Cloud Scheduler
• Google Cloud Pub/Sub

3. Initial Plan:

• 3.1. I will create a separate database for the Task Queue. Any new tasks scheduled by users will also be stored here. Task and User data are stored on different databases respectively.

• 3.2. I will create a function that is scheduled to run everyday at 00:00:00. On the event that this function fires, it will do 2 things:

• 3.2.1. It will check today’s date and retrieve the collection from the Task Queue database with that same date. The function will then go over each task and mark it open for that day.

• 3.2.2. It will also retrieve yesterday’s task queue, go over those tasks and mark them closed.

4. Questions:

• 4.1. How should I structure the task queue DB more efficiently (in Firebase RDB)?
• 4.2. Ideally, how should I setup the scheduler function (i.e. should I run it once a day)?
• 4.3. How should I handle Users from different timezones?

I know there's a much more effective and efficient way of setting this up so I'm looking forward to everyone's feedback. Any links/resources for further reading will be awesome. Thank you in advance!