Docunext Technology

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.