I've used Gallery2 and miniGal in the past (both of which are great), but when I was beginning to redesign the Team 228 website for the 2007 season I couldn't find any existing PHP/MySQL software to do what I want, so I wrote my own. Basically I wanted to convert some of the best features from Gallery2 and CD-Media into one package, and so far here's the result:
www.team228.org/media/pictures/
Currently, the software I wrote:
- Splits all the pictures into corresponding years
- Splits each year into individual galleries
- Allows unlimited (from 1 to 1 zillion) photos per gallery
- Has full support for tagging (by Administrators only)
- Has full searching support
- Has full slideshow support for all pictures, all pictures from a specific year, and all pictures from a specific gallery
- It also automatically updates the homepage, and eventually the sitemap as well.
- It features an easy-to-use Administrator CMS for managing gallery content.
- It was also designed to be very 'modular', so I can use many of the same class structures to do a document/white paper 'gallery' or a video/multimedia 'gallery' as well.

Writing those thousands of lines of PHP code certainly took a while, but the final product was certainly worth it.
