Re: [web2py] SQLite lock (using DAL in a module)

@Jesse SQLite has to be seen as a signle file storage. If you open in one process all other processes have to wait until the first process releases lock ownership. The best way to do that, is to put commit or rollback at the end of every access on the db. The code you posted does a single commit

Re: [web2py] SQLite lock (using DAL in a module)

(i´m not an expert here but i faced the same problem) I moved to postgresql and no more database locks. sqlite does not allow to have scheduler and your code writting to the database at the same , or at least that was my understanding... Regards António 2017-02-03 14:01 GMT+00:00 Jesse Hunt :

[web2py] SQLite lock (using DAL in a module)

Good afternoon all, I am experiencing issues while trying to perform operations using my DAL from a module. I recently moved code from the default controller to a module for better coding practices. The code was running previous to the move, but now I experience an error ( database is locked