Introduction to SQLite

Like other database extensions SQLite allows creation of persistent connections that eliminate the connection initialization overhead.


<?php
$db = sqlite_popen("/path/to/database", 0666, $error)
    or die("Failed to connect because: ".$error);
?>

Caution

• Can result in undefined behavior if the database is rebuilt (Ex. VACUUM).

• May cause problems in environments with a small open file handle limit.

• Decreases reliability if certain tuning options are used.