Introduction to SQLite


<?php    // Procedural Approach
    $db = sqlite_open("/path/to/database");

    // timeout is set in microseconds 
    // (1/1000 of a second)
    sqlite_busy_timeout($db, 1000);
?>


<?php    // OO Approach
    $db = new sqlite_db("/path/to/database");

    $db->busy_timeout(1000);
?>

• Default timeout is 60 seconds.

• Prevents pile-up of processes waiting for a lock to be released.