I am hoping someone can provide some architecture advice on a project I am working on.
High Level Objective
My high level objective is to use IOT devices (particle Boron’s) to collect end-user data and send via the cellular network to an online database. This data will then need to cleaned to remove any obvious outliers, although this functionality can be added at a later stage. We will also be calculating averages and fluctuations in the data over time. This data will then be presented to the individual end users via a dashboard behind a login wall on our website.
Note: I have a php application up and running that was fully built using Wappler, that includes a user login feature and security privileges. This application is currently connected to a mySQL database that is hosted on an apache web server supplied by my website hosting provider.
The current problem I have is that my IOT devices are currently sending data to an Azure Iot Hub and then piped into an Azure SQL Database. I now want to connect this data to my hosted website and this is where my problems arise.
Perhaps I should try and connect my IOT devices directly to a php form on my Wappler website? The devices could be submitting 50-500 data points per day, initially we will only have 4 devices but I am trying to build a solution that is reasonably scaleable. In my very limited knowledge, webhooking this data to a php form does not seem like the most scaleable solution, but I could be mistaken.
I am hoping someone here can give some guidance as to whether I am going about this the right way, or if I am overly complicating things. Thanks in advance.
EDIT: Perhaps I would be better to move my hosting to Google cloud or Azure entirely so that everything is hosted with either of these providers? Essentially I am trying to get a minimum viable product up and running, but if I can make a scaleable solution from the outset it would be great.