With the help of Zend’s developer zone, I made my first SQLite script:

#!/usr/local/bin/php";    print_r($row);    /* each result looks something like this    Array    (        [0] => 1        [id] => 1        [1] => Ilia        [name] => Ilia    )*/}?>

So far, I’m pretty excited about using sqlite. I was concerned about the foreign keys, but I just found this. You can create the equivalent of foreign key constraints with triggers, and triggers are supported by SQLite, Postgres, and MySQL!

Following on that minor progress, I added basic SQLite support to the pdo datasource in nexista.