Alex King just released Photos 4.0 (formerly known as Gallery). It’s a web-based photo database for storing, cataloging, and retrieving photos, but NOT for publishing web galleries. It can import photos by the folder or one at a time, and stores a thumbnail of each image.
It’s designed for “Anyone who is comfortable installing and configuring PHP & MySQL and wants to manage their digital photos.”
The new version adds compatibility with more browsers (Safari, Mozilla, Phoenix, and Camino), confirmation messages, storage of additional EXIF information, range searches on EXIF data, enhanced Quick Entry, and other improvements. Photos is free (donations requested) for Mac OS X, Linux/Unix, and Windows using Apache, PHP, and MySQL.