Last time we did frontend-only version and now need to actually implement the backend, so I have some further questions
In our system, a single account can have hundreds of projects and many-many tasks. Some times there are dependencies set across different projects tasks.
Users can edit individual tasks using different methods, including direct API calls with their Zapier integrations. We need to implement schedule update on the backend, when single task is changed.
As far as I understand, I need to provide the node.js engine with a set of existing tasks and then initiate an edit. What worries me is that I really don't want to pull all accounts tasks into memory just to check if anything needs rescheduling.
How would you recommend to approach this task? Is there a smart way to gradually pull tasks from the store only if they are affected by the task change?