rid rid - 6 months ago 33
PHP Question

SQLite 3 locking in PHP

I would like to lock an SQLite3 database, make a few queries, then unlock it. How do I do that?

rid rid
Answer

Seems like the only way to do this with PHP < 5.3.3 is to use PDO. PDO seems to set the busy timeout by default to 60 seconds (as opposed to 0 set by SQLite3), and you can also set it explicitly with $pdo->setAttribute(PDO::ATTR_TIMEOUT, $timeout) (same functionality as PHP 5.3.3's SQLite3::busyTimeout()).