On Fri, Feb 13, 2009 at 08:27:42AM +0900, Tim Pease wrote:
>
> 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.

I'll have to take a look at that and possibly do something similar with
Amalgalite.  Maybe an Amalgalite Appender?  That might also fill what James is
thinking about.

enjoy,

-jeremy



-- 
========================================================================
 Jeremy Hinegardner                              jeremy / hinegardner.org