From: Matt Williams <matt@...>
Date: 2009-02-13T13:46:58+09:00
Subject: Re: SQLite as a Log?

On Fri, 2009-02-13 at 12:22 +0900, James Gray wrote:
> On Feb 12, 2009, at 8:26 PM, Matt Williams wrote:
> 
> > On Fri, 2009-02-13 at 07:59 +0900, James Gray wrote:
> >> In a current project we're discussing using SQLite for all  
> >> application
> >> logging.
> >
> > Have you considered splunk?  That way you can do queries and event
> > correlation easily.
> >
> > They have a community version which allows you to collect 500MB of  
> > logs
> > a day...
> 
> 
> I need a local solution.  Thanks for the idea though.
> 

I saw you wanted to keep it light, so yeah, it is probably not the best
solution.
However, you can log to a local database -- as I understand it, that's
what we're doing at work...

Another option would be to use syslog & batch load (every N minutes)
into sqlite....

Good Luck!

Matt