2011/9/27 Patrick Proniewski <pat...@patpro.net>:
> I'm facing a challenging problem. I want to log some data into an SQLite3 DB. > Data come from a system command (iostat) in an endless steam, one row every X > seconds: Take a look at a utility called dstat. I've twiddled with the source and have its output go to a .csv. Basically, I've done what you want to do, except with Oracle. The plan then is to cron (or within Oracle - use the db scheduler) a job that copies the data into the database - then at certain times delete down the .csv file so that you're not continually rejecting records already in the db. I have implemented this with Oracle - need to do a bit of work - but it's part of what I believe *_should_* be easy - i.e. put basic system metrics directly into a database so that such data can be analysed over a long period, rather than "Oh, what did iostat say yesterday?". When I have it fully working with Oracle (XE 10), I plan to get it working with SQLite - it should be reasonably easy using .csv and cron jobs. Paul... -- Hmmm.... a "life": wonder where I can download one of those? lineh...@tcd.ie Mob: 00 353 86 864 5772 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users