Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: upload logged data

by NetWallah (Abbot)
on Sep 30, 2012 at 15:02 UTC ( #996509=note: print w/replies, xml ) Need Help??

in reply to upload logged data

How about double-logging:
Log to the local SQLite database, AND create an incrementing log file containing SQL statements.

A separate process (Either local, or on-request from the server) can periodically ship the incrementing file to the server, and delete them.

The server can apply the received logs and maintain the equivalent of a replicated database, to generate charts.

This has the advantage of being scalable for multiple logging sources, for centralized data processing (I'm an old-time mainframe guy).

             I hope life isn't a big joke, because I don't get it.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://996509]
[james28909]: so if you subtracting as you loop, be aware that you will eventually be subtracting into a past month, or year <.<
[james28909]: dontcha love it!
[james28909]: Today would be scalar localtime. Yesterday would be scalar localtime - 1. sunday - monday would variate scalar localtime - ?
[james28909]: oops s/sunday - monday/sunday - saturday/
[james28909]: my mind is blown haha
[james28909]: hmm, i haz idea!

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2017-04-29 03:57 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (531 votes). Check out past polls.