Re: Saving history
- I am doing all of this on a 466 MHz IBM thinkpad with 512 meg ram and
16 Gb Hard drive, just so you have an idea of my dedicated system. My
server is actually running IIS (Webserver) not this laptop, as the
laptop is only running WUHU and MYSQL exclusively and the server
"talks" to MYSQL on the laptop for weather data.
--- In email@example.com, "larrymyers312000"
> Personally, I have been using MySQL to store my data, works like a
> champ and I can store as much data as I want, of course I will need to
> stop storing it I am sure, as the hard drive will become full, but
> until then I will keep it going.
> I am currently storing entries every 8 secs using a cheat I figured
> out, where I have a template that generates a csv file by throwing the
> fields of interest seperated by commas. Then I use PHP to extract the
> data from the MySQL DB, which is a little bit tedious right now, as I
> need to still make the pages to do the work for me but I am getting
> there. I have just made my webpages AJAX enabled so the 8 second
> updates are showing up close to real time which is really neat.
> I am really liking this way of storing the data but since I work with
> MySQL everyday it is a viable alternative for me.
> I still need to figure out PHP a bit better, but am progressing fast.
> I also need to complete the new code changes and add some more fields
> but I am getting to it too.
> --- In firstname.lastname@example.org, "Brian" <yahoo@> wrote:
> > I'm curious how everyone saves their weather history (if they do). I
> > finally got a system devoted solely to my station and so I want to
> > jump into the deep end.
> > Granted, WU does a pretty good job of doing it, but I've been wanting
> > to maintain my records on my own system. This way I can hopefully
> > "manipulate" the data in various ways as I see fit.
> > I currently am saving a copy of basically all the extended data in a
> > text file which saves throughout the day, then starts a new one the
> > next day. Therefore, I'm going to be accumulating a number of text
> > files with all my data, and not really a game plan for how to use it.
> > I'm thinking Excel is not sufficient for this amount of data, so I was
> > thinking an Access database. Thoughts?
> > Once I figure out where to put it, I need to figure out how to get it
> > there. Any thoughts and suggestions on this? Any ways for
> > automatically getting the text file to import into the database? (I
> > know, I'm demanding)
> > Love to hear your thoughts!
> > Thanks,
> > Brian
> > CW6873