Page 1 of 1

Realtime.txt and mysql

Posted: Fri 17 Feb 2012 4:03 pm
by mspec
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 :D .

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

Re: Realtime.txt and mysql

Posted: Fri 17 Feb 2012 6:40 pm
by steve
Nice work :)

Re: Realtime.txt and mysql

Posted: Fri 17 Feb 2012 8:23 pm
by mspec
Thanks Steve, I really am a novice to this and my code shows it lol, Thanks to the help of somebody else its now inserting the correct date for 2012 and not 2018 lol.

Re: Realtime.txt and mysql

Posted: Sun 19 Feb 2012 6:15 am
by mspec
Ok so far so good with over 2k lines of data inserted into the database. I thought I would like to start playing around with something a bit better in the way of graphs and set my sights on Highchart, Its taken me all day to figure it out mainly because I have no idea what I am doing. Finally succeeded in producing what I wanted.
I guess this is just the start, with a data base at your finger tips you could pull out and use what ever data you wanted as long as you knew how.

Here is the Highchart, http://mspec.no-ip.org/spline.php

Re: Realtime.txt and mysql

Posted: Sun 19 Feb 2012 5:26 pm
by beelzebubs
Looking nice, really nice :clap: *thumbs up*