From: Joel VanderWerf <vjoel@...>
Date: 2009-02-13T08:17:34+09:00
Subject: Re: SQLite as a Log?

James Gray wrote:
> In a current project we're discussing using SQLite for all application 
> logging.
> 
> This is a heavy multiprocessing environment, which was one of our 
> reasons for considering it.  We also love the idea of structured queries 
> helping us debug issues:  show me any logged errors between these times.
> 
> The minus of course is a slight loss in transparency.  For example, you 
> can't just tail a log file when you want.
> 
> Anyway, I would love to hear from anyone who has done this.  Did you 
> like it?  What were the downsides I am missing?
> 
> Thanks in advance for any information you can provide.
> 
> James Edward Gray II

IIRC one writer blocks the entire sqlite db. You could avoid this using 
a gatekeeper server for writing to the log.

Re tailing log files: I avoid that anyway, even with file logging, 
because it doesn't know about log rotation. The alternative I've found 
helpful is to set up a drb service that lets a process listen for log 
entries.

-- 
       vjoel : Joel VanderWerf : path berkeley edu : 510 665 3407