With the help of Zend's developer zone, I made my first SQLite script:
#!/usr/local/bin/php
if(!is_file("db.sqlite")) { $db = new SQLiteDatabase("db.sqlite"); $db = sqlite_open("db.sqlite");
sqlite_query($db , "CREATE TABLE foo (id INTEGER PRIMARY KEY, name CHAR(255))");
sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia')");
sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia2')");
sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia3')");
exit;}$db = sqlite_open("db.sqlite");$result = sqlite_query($db, "SELECT * FROM foo");// iterate through the retrieved rows
while ($row = sqlite_fetch_array($result)) { echo ""; 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.
