+1 notice that you can use expire_time=None to prevent cache from expiring instead of 99999999
On Jul 23, 8:24 am, Yarin <ykess...@gmail.com> wrote: > Added a slice: Application > Logginghttp://web2pyslices.com/main/slices/take_slice/91 > > It covers logging to both a file and SQLite. The code is well > documented- use this instead of the previous code. Would love to get > your comments. > > @Iceberg, btw apparently the SQLite cross-thread issues weren't solved > by using the default DB after all. I added a thread-safe work around, > but suggestions are welcome. > > On Jul 22, 8:20 am, Massimo Di Pierro <mdipie...@cs.depaul.edu> wrote: > > > This is useful. I suggest making a web2py slice about this. > > > Massimo > > > On Jul 21, 2010, at 9:37 PM, Iceberg wrote: > > > > Just a quick thought. Since web2py itself already handles SQLite db > > > well under multi-thread situation, so a quick tweak to your > > > sqlitehandler.py may be putting the web2py db instance, rather than > > > a filename, to initialize your SQLiteHandler() class. > > > > Best regards, > > > Iceberg, 2010-Jul-22, 10:28(AM), Thu > > > > ----------------------- Original Message ----------------------- > > > From: Yarin <ykess...@gmail.com> > > > To: web2py-users <web2py@googlegroups.com> > > > Cc: johann.scheibelho...@easytouch-edv.com, mdipie...@cs.depaul.edu > > > , iceb...@21cn.com > > > Date: Wed, 21 Jul 2010 19:15:55 -0700 (PDT) > > > Subject: SQLite Logging > > > ------------------- > > > >> I'd like to elicit some help in putting together a SQLite-based > > >> logging solution for web2py. > > > >> Logging to a file was covered earlier in this forum (See "Global > > >> logging to file"): > > >>http://groups.google.com/group/web2py/browse_thread/thread/e20d0bd2e5... > > >> log.py: > > >>https://sites.google.com/site/ykessler/main/log.py > > > >> I've written a SQLite logging handler: > > >>https://sites.google.com/site/ykessler/main/sqlitehandler.py > > > >> However, although the SQLite handler works great in normal Python > > >> environments, it errors out with the global logging solution because > > >> the logger emits on multiple threads, and SQLite objects are > > >> restricted to the thread they're created on. > > > >> Any ideas on how to sync these two solutions?
