According to Gallery 2.3 README.html file (see URL) SQLite 3.x backend is currently supported by Gallery. Although it's marked as experimental it seems to be working well on my machine (amd64 hardened). It would be nice to include sqlite3 USE flag, so it is possible to use SQLite3 backend as well. In my case I had to recompile PHP with pdo USE flag to get SQLite 3.x backend working. Reproducible: Always
Marcin, have you tried to use that? It's still considered experimental by upstream but how it's in reality?
I use it on hardened amd64 without any problems and in general I'm very satisfied after migration from Gallery 1.5.x to 2.3.x. I played a bit with administration interface and everything worked nicely, so personally I don't see problems with it although it might not work that well under higher load etc.
Great. Could you confirm that this is all required changes in gallery ebuild: --- /usr/portage/www-apps/gallery/gallery-2.3.ebuild 2008-12-07 01:28:43.000000000 +0300 +++ gallery-2.3.ebuild 2009-01-08 13:23:06.000000000 +0300 @@ -10,7 +10,7 @@ LICENSE="GPL-2" KEYWORDS="alpha amd64 hppa ppc ppc64 sparc x86" -IUSE="ffmpeg gd imagemagick mysql netpbm postgres raw unzip zip" +IUSE="ffmpeg gd imagemagick mysql netpbm postgres raw sqlite unzip zip" RDEPEND="raw? ( >=media-gfx/dcraw-8.03 ) ffmpeg? ( >=media-video/ffmpeg-0.4.9_p20051216 ) @@ -32,6 +32,7 @@ local php_flags="pcre session" use mysql && php_flags="${php_flags} mysql" use postgres && php_flags="${php_flags} postgres" + use sqlite && php_flags="${php_flags} pdo" if ! PHPCHECKNODIE="yes" require_php_with_use ${php_flags} || \ ( use gd && ! PHPCHECKNODIE="yes" require_php_with_any_use gd gd-external ) ; then As I read documentation it states that pdo is required feature in php to run gallery with sqlite.
Shouldn't this be sqlite3 instead of sqlite ? mac g2data # file gallery2.db gallery2.db: SQLite 3.x database mac g2data # grep sqlite /usr/portage/profiles/use.desc sqlite - Adds support for sqlite - embedded sql database sqlite3 - Adds support for sqlite3 - embedded sql database The pdo use flag I discovered rather through "experimental" way (look at my initial request) and that's correct. I will try your patch when I get back home..
Patch looks fine except that you forgot to add sqlite3 to confutils_require_any statement. Except that things work fine.
Ok, I've added sqlite support in gallery-2.3-r1. Thank you for report, tests and feedback. (In reply to comment #4) > Shouldn't this be sqlite3 instead of sqlite ? There was a discussion on -dev http://archives.gentoo.org/gentoo-dev/msg_0c226045dfc232677efa1fe89ae3b96a.xml If package uses both, sqlite-2 and sqlite-3, then use sqlite3 useflag, but probably it's better to drop sqlite-2 support completely. Any way here we only mean sqlite support and thus we'll use sqlite USE flag.