From: Jeremy Hinegardner Date: 2009-02-14T00:50:40+09:00 Subject: Re: SQLite as a Log? 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