Bug 247271 – www-apps/gallery-2.3 supports SQLite3 backend

• Product: Gentoo Linux
• Status: RESOLVED FIXED

[Description Marcin Deranek 2008-11-17 20:56:12 UTC]

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

[Comment 1 Peter Volkov (RETIRED) 2009-01-08 10:46:29 UTC]

Marcin, have you tried to use that? It's still considered experimental by upstream but how it's in reality?

[Comment 2 Marcin Deranek 2009-01-08 11:13:59 UTC]

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.

[Comment 3 Peter Volkov (RETIRED) 2009-01-08 12:38:27 UTC]

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.

[Comment 4 Marcin Deranek 2009-01-08 12:51:15 UTC]

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..

[Comment 5 Marcin Deranek 2009-01-09 23:19:10 UTC]

Patch looks fine except that you forgot to add sqlite3 to confutils_require_any statement. Except that things work fine.

[Comment 6 Peter Volkov (RETIRED) 2009-01-27 12:02:03 UTC]

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.