Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re: upload logged data

by NetWallah (Canon)
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]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2018-06-19 00:08 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (111 votes). Check out past polls.