On Wed, Aug 10, 2011 at 10:35 PM, Wenbo Zhao <wbz...@travelsky.com> wrote:
> Hi guys, > I want a readonly connection wait for locked database instead of error > return immediately. > The question is equivalence to how to let a reaonly connection have > busy_handler triggered > when the database is locked. > In my practice, the readonly connection will fail when db locked and > busy_handler does not work. > > If you set "PRAGMA journal_mode=WAL" then readers will never be blocked. > Thanks. > > -- > > Best Regards, > ZHAO, Wenbo > > ======================= > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users