✨ Proof of concept asynchronous operation

[petertgiles]

✨ Feature

We have a need to be able to handle asynchronous operations. When a user needs to complete an operation that will take longer than the Nginx response time limit we need to be able to queue the operation and then allow the user to interact with the result afterwards.

🕵️ Details

The current use case is to request a big query and download the bulk result after but there may be others.

🙋‍♀️ Proposed Implementation

Some discussed ideas:

• Run the operation on a timer, like overnight, and then save the results to a file to be downloaded later
• Run the operation asynchronously then email the results to the user
• Queue the operation then use something like websockets to notify the client when the result is ready
• Laravel Notifications is being set up in #6927 and has the concept of a worker queue and event broadcasts
• Graphql and Lighthouse has subscriptions. read more
• Possibly in Azure: https://learn.microsoft.com/en-us/answers/questions/1261058/pusher-com-service-equivalent-in-azure

✅ Acceptance Criteria

• [ ] A proof of concept to demonstrate the solution
• [ ] The solution is well suited to generating bulk data reports
• [ ] The solution is general enough to be used for other things

[vd1992]

Might be unneeded due to Power BI