Thanks, I hope it works, I hate to use MySQL for this project. Pardon my ignorance but the example at hand below is for C, any ideas on how to set for Bash and PHP ? Or better yet globally for sqlite3
int sqlite3_busy_timeout(sqlite3*, int ms); On Mon, Oct 20, 2014 at 2:00 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users