Note: This solution work in Windows/DOS.

SQLite is a wonderful mini database that can be used by PHP.

I recently tried to use this because it was excellent for running it with PHP for PocketPC. It’s small and you don’t need database connections. The database is file based (extension .db) and all you have to do is point to it.

However one of the biggest problem is most PHP versions can only work with SQLite version 2. You can “Invalid format” if you run PHP and try to read SQLite version 3 database. There are some solutions out there to fix it like installing the correct PHP extensions but it didn’t work for me.

I was still adamant in using SQlite and since version 2 and 3 does not have important difference for me I didn’t mind working with SQLite 2.

This is an easy way to convert one db version to another.

Eg: to convert say, “authentication.db” which is version 3 to version 2. You do this:-

The advantage now is that I can develope programs on the PC working with the SQLite database and transfer the PHP files as well as the DB (converted of course) into the Pocket PC once done. That’s just too cool and convenient

Files needed:-