From: James Gray <james@...>
Date: 2009-02-13T07:59:53+09:00
Subject: SQLite as a Log?

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