On 8/6/16, Rob Willett <rob.sql...@robertwillett.com> wrote: > > What we have now found is that when we are running the analytics query > in one Perl process, we can no longer UPDATE the main database through > another Perl process. We are getting “database is locked” errors.
Doing "PRAGMA journal_mode=WAL;" on your database (just once, perhaps from a command-line shell) will fix this for you. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users