I have that for my soft and it works fine.
I also have a swap mecanism to update the sqlite file : the daemon gets the
sqlite file's name from a filemapped into memory.
When a new file has been generated, another batch updates the filemap with the
new sqlite file's name.
The daemon sees the file name has changed (with no I/O since it is mapped into
memory) , kills the SQLIte connection and opens a new one.
Best Regards.
Renaud> Date: Tue, 18 Dec 2007 14:27:28 -0800> From: [EMAIL PROTECTED]> To:
[email protected]> Subject: [sqlite] sqlite in a daemon> > Hello,> > I am
considering writing a daemon that would keep the sqlite connection opened
forever (at least in the "daemon" sense of forever). Is it a good idea? Any
experience you could share about that kind of design?> Thanks> > > > >
____________________________________________________________________________________>
Looking for last minute shopping deals? > Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
