Realtime.txt and mysql
Posted: Fri 17 Feb 2012 4:03 pm
OK so I finally managed to figure out how to take the data from realtime.txt and put it into a database on mysql. I currently have it running via a cron job and so far so good. There are 58 column's within the table and cron updates it every minute.
This make's the data very accessable for anybody wanting to build their site graphs ect.
Just as an example here is a trend graph for outside temp. Bear in mind that I have only managed to have the cron job running for the last hour or so so there are only 80 odd records to plot with, But it is building by the minute
.
Am i going to release the code for doing all this, Of course I am but I would like a week of making sure its all stable before I do.
Oh here is the example, Should change and grow over the next couple of days as more data is added to the database.
Edit: Seems to be showing the year 2018, Have to figure out how to format data into correct date format its not storing it correctly in the database.
http://mspec.no-ip.org/spline.php
This make's the data very accessable for anybody wanting to build their site graphs ect.
Just as an example here is a trend graph for outside temp. Bear in mind that I have only managed to have the cron job running for the last hour or so so there are only 80 odd records to plot with, But it is building by the minute
Am i going to release the code for doing all this, Of course I am but I would like a week of making sure its all stable before I do.
Oh here is the example, Should change and grow over the next couple of days as more data is added to the database.
Edit: Seems to be showing the year 2018, Have to figure out how to format data into correct date format its not storing it correctly in the database.
http://mspec.no-ip.org/spline.php