The real power of iterators comes through the ability to use foreach() for an extremely fast data retrieval from objects.

<pre>
<?php
$db = new sqlite_db(dirname(__FILE__)."/ip.db");

$res = $db->unbuffered_query("SELECT * FROM country_data WHERE cc_code_2='CA'", SQLITE_ASSOC);

foreach($res as $row) {
    print_r($row);
}
?>
</pre>
Output