I have an ipod touch.
And I jailbroke it. (Worked like it says on the box, incidentally)
And I have Apache + PHP working.
And I have WordPress 2.2.2 for Sqllite on it.
But alas, writes to the database aren’t happening.
(I installed it on a Real Computer and put the .db file it created on to my iPod; and WordPress is able to read data from it A-OK. It just isn’t writing to it. The permissions on the .db file are 777; same for the folder its in. I’ve also tried renaming it to .sqlitedb which matches some of the other sqlite databases that the iPod uses, but that made no difference either.)
Halp?
i’d recommend giving my version of wordpress for sqlite a try. it’s tested on wp2.3.1 and 2.4-bleeding.
it does require php5 and pdo and pdo_sqlite to be enabled.
the database is created by the application, so this should avoid permissions problems.
you can find my version at rathercurious.net/pdo-for-wordpress
Good luck
Justin
You’ll probably find that its endian specific, ie.. not portable to other architectures. You’ll want to dump the data, then re-import it to a local SQLITE database tow ork correctly.