On 18 Oct 2014, at 1:32pm, Ali Jawad <alijaw...@gmail.com> wrote: > I do have one sqlite DB, with multiple dbs, and multiple scripts writing to > those tables, at one time only one script writes to one table, I.e. there > is no simultaneous read/write access to one table at one time. However, I > am getting DB locked errors, did I misunderstand Sqlite3 ? Is the lock per > DB or per table ?
The lock is per database. You're bound to get locks occasionally if you don't set a timeout. Set yourself a timeout using <https://www.sqlite.org/c3ref/busy_timeout.html> or the PRAGMA. Set it to something like 1 minute. Does the problem go away ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users