I need some help im starting up a company that will be logging data from several 100 devices. The data will consist of Internal temperature as well as outdoor temperature barometric pressure humility and audio frequency. The data will update every 1,5,15,30 min depending on the users request. my question is im going to need to keep this historical data for about a year. I want to take this data and display it to the user in a nice chart (line pie graph). What is the best way to go about doing this?

I have seen some IOT dashboards that allow you to set up a web hook and capture your data from the sensor and send it to there website and it displays the content really nice. But so far i have not found any options to get it from the IOT DB to my website.