I am currently storing temperature data (8 sensors, 1 reading/min) in a google spreadsheet and reading this data into a highchart embedded on a html to visualise the results.
This is working well, even with 20,000 rows which the google spreadsheet has now. I am wondering however if there is a more robust method, e.g. what would a pro developer use? Something like a MySQL database or similar? Something that can easily handle massive datasets? I feel like i might reach the a limit at some point with the google sheet. Thanks.