Gallery 1.3.x + MySQL

Sire

Joined: 2002-08-28
Posts: 22
Posted: Sat, 2002-11-02 20:52

Has anyone hacked Gallery 1.3.x to use MySQL ?

 
beckett
beckett's picture

Joined: 2002-08-16
Posts: 3474
Posted: Tue, 2002-11-05 03:52

Yes. It's be called Gallery 2. :wink:
Hang in there a bit... it'll be worth the wait when it arrives (soon!), and will have many new capabilities as a result of integrating everything into a MySQL database.

 
eschamann
eschamann's picture

Joined: 2003-12-27
Posts: 2
Posted: Sat, 2003-12-27 06:57
beckett wrote:
Yes. It's be called Gallery 2. :wink:
Hang in there a bit... it'll be worth the wait when it arrives (soon!), and will have many new capabilities as a result of integrating everything into a MySQL database.

Beckett, do you know when the G2 will be available to the community ?

 
Arnaktis

Joined: 2003-12-19
Posts: 11
Posted: Sat, 2003-12-27 14:07

I've "hacked" 2 pages to use MySql. It's damn faster than G1 or G2..

The reason because G1 is slow is the function unserialize() from PHP, used every time a album is acessed. And some overhead from the file system too.

So, what I propose is.. To be a VERY powerfull gallery called G2, and a damn fast one, G1.

I have a web server on a Pentium MMX 233 w/ 256mb just to test the performance of different scripts. G2, for now, takes 1-2 secs to start loading a page. There's a lot of classes, checkings, modules, etc.. G2 is powerfull, but a bit slow.

I named my solution G2M (Gallery To Database)
If someone interested, I done a script to load the gallery into 2 tables of MySql, g2m_albums.php, g2m_view_album.php, g2m_search.php and g2m_view_photo.php.

I use my gallery just to display photos to a specific group of friends. I don't need permissions, etc, etc, to run my gallery, so these scripts are very optimized. But, if someone is willing to, we can rewrite the classes of G1 to use MySql, and where're done. Fast and easy.

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sat, 2003-12-27 15:26

@Arnatkis:
while your hacked gallery 1 is really interesting, the name "G2M" is a bad choice, it's misleading.
It's by far not based on G2, so call it gMysql or GalleryDB or something like that.
@Speed: AFAIK G2 has not gone through a first run of optimization and caching is not yet done. Of course the extreme OO approach will cost some speed, but I'm sure G2 will become a lot faster.

 
Suspicious

Joined: 2003-07-28
Posts: 20
Posted: Fri, 2004-01-09 10:55
Arnaktis wrote:
I named my solution G2M (Gallery To Database)
If someone interested, I done a script to load the gallery into 2 tables of MySql, g2m_albums.php, g2m_view_album.php, g2m_search.php and g2m_view_photo.php.

I use my gallery just to display photos to a specific group of friends. I don't need permissions, etc, etc, to run my gallery, so these scripts are very optimized. But, if someone is willing to, we can rewrite the classes of G1 to use MySql, and where're done. Fast and easy.

I'd be interested in this as well because I only use my gallery to show pictures to a single group of friends. I'm paitently waiting for G2, but my G1 gallery's getting slowly massive by the day.

 
Sire

Joined: 2002-08-28
Posts: 22
Posted: Wed, 2004-04-21 01:11

Would anyone take up the task of doing a completely Gallery 1.4.3 conversion to using MySQL ? If so, let me know what it will cost and let's do this. Thanks.

 
Arnaktis

Joined: 2003-12-19
Posts: 11
Posted: Wed, 2004-04-21 01:17

I'm up.. But, how about incorporate MySql into existing gallery code? Like having 2 include dirs... What do u think about it?