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.