Introduction to SQLite


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

    $result = sqlite_unbuffered_query("SELECT * FROM tbl", $db);
    /* OR */
    $result = sqlite_unbuffered_query($db, "SELECT * FROM tbl");
?>


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

    $db->unbuffered_query("SELECT * FROM tbl");
?>

• 15-30% performance increase depending on the number of rows fetched.

• Data is available right away, don't need to wait for all data to be pre-fetched.

• Lower memory utilization.

• Can only move forward one row at a time.