(Hi I’m new here - I believe this question suits here from the guide saying “ architecture, and design” - however if there is a better place, just pop me a comment. As there’s no actual code it doesn’t suit stack overflow )
I am designing a simple site and app where people can create alerts for product stock availability and prices.
So users would create an alert for let’s say a lawnmower at $125.
There would be many products at many prices from a few different vendor APIs.
The hard bit is the backend. I’d have to loop through a unique list of all products submitted, query APIs for their price, put that in another table of product-to-price, then loop through the entire user table again checking that current price against the alert price the user has set.
But the alert needs to be real-time as users bid on products, yet that script could take minutes to run with just a few users. I’m hoping for many users with many notifications.
Any ideas on a better architecture? Open to tech, ideally JS and AWS but am open to change.