SQLite support

sbillard

I am interested in finding someone with knowledge of SQLite implementation to collaborate on adding SQLite support to Zenphoto.

Requirements:
You will need a test installation of Zenphoto on a server with SQLite and PHP with PDO_SQLite support configured.

There is a "draft" handler for PDO_SQLite included in tonight's nightly build. (It may be enabled by changing the define at the beginning of setup.php.)

The current state of implementation is that things "should" work based on the documentation. However, they do not work at least on my install. The "does not work" behavior is also confusing to me. For instance when I "connect" to the database and try to create tables I get back no exceptions but the create also fails.

acrylian

I can try as well, as both my local and my live server have sqllite support. From a quick look sqllite supports a lot mysql does but lacks some refined query stuff. For example the UNION statement Zenpage uses for the CombiNews mode. But I can of course be wrong as I did not dig deeply into it, maybe it supports this as well. But if not this would either mean not using stuff Mysql provides and writing php workarounds (might not be really effective actually..)