sqlite (v2.x) != sqlite3 (v3.x)
$ sqlite3 temp.db3 "BEGIN TRANSACTION; CREATE TABLE blah (id INTEGER NOT NULL); COMMIT;"
$ sqlite3 temp.db3 ".dump"
BEGIN TRANSACTION;
CREATE TABLE blah (id INTEGER NOT NULL);
COMMIT;
$ sqlite temp.db3 ".dump"
Unable to open database "temp.db3": file is encrypted or is not a database
sqlite3 adds support for many things that were missing from sqlite, but would slow down sqlite. So you want a fast simple database, use sqlite. You want a kindah fast database with some extras use sqlite3.
EDIT --
Reverse the above; sqlite3 test.db ".dump" on a sqlite db will spit out
BEGIN TRANSACTION;
COMMIT;
Regadless of how much or what kind of data you have in the database.
EDIT --
Well I've managed to get a sqlite3 database to be created... But "CREATE TABLE X(Y);" never get's commited... even if I call $db->start_transaction() before $db->query() and $db->end_transaction() after the query... This is all done with the install.php script, in a clear punbb install (no mod or databases, etc...).
Anyone one know of an alternative to the php5-sqlite3 mod? I've hurd PDO might work with some effort?
echo "deadram"; echo; fortune;