From: Tim Pease <tim.pease@...>
Date: 2009-02-13T08:27:42+09:00
Subject: Re: SQLite as a Log?


On Feb 12, 2009, at 3:59 PM, 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.
>

Have you looked into using CouchDB as the logging destination instead?

I've started a branch of my logging gem that allows you to do this,  
but I've had to table it due to other obligations.

The goal is to just dump everything to CouchDB with some mnemonics on  
the messages. Then you create views to see all messages for a given  
application. All error messages in the past week, etc.

Blessings,
TwP