From: Ken Bloom <kbloom@...>
Date: 2009-02-13T09:08:45+09:00
Subject: Re: SQLite as a Log?

On Thu, 12 Feb 2009 17:59:53 -0500, James Gray wrote:

> In a current project we're discussing using SQLite for all application
> logging.

Consider a concurrent RDBMS instead if you can deploy it in your 
environment.

If you want to tail the log, then it shouldn't be too hard to write a 
script to do it. For a project I run, to look at the last 15 log entries, 
I have a shell function:

atlog () 
{ 
    $sql atman -t -e 'select * from atman_log order by time desc limit 15'
}

(Where $sql starts with "mysql" and then adds login information)

If you want to do continuous monitoring, you could use a loop (maybe 
write a ruby script) that checks every 2 seconds or something, and 
selects all of the log entries that are more recent than the last check.


-- 
Chanoch (Ken) Bloom. PhD candidate. Linguistic Cognition Laboratory.
Department of Computer Science. Illinois Institute of Technology.
http://www.iit.edu/~kbloom1/