March 17, 2011
sqlite pdo write lock problem solved
When using PHP and PDO to access an sqlite dababase, and when you do a "select *" using the $handle->query($sqlcmd), you must use "foreach" to read all the select results before you can issue the next "query" or "exec" call. Otherwise, the database will be locked.
Posted by Tiebing at 3/17/2011