LinPHA is an easy to use, multilingual, flexible photo/image archive/album/gallery written in PHP. It uses a SQL database to store information about your pictures. It comes with a HTML based installer, so you don't need experience in setting up SQL
iidcapi provides a standardized interface to control an IEEE1394, IIDC compliant digital camera
UPDATE This version of the software is very out of date and will be replaced by a much smaller UI along with much more optimizations like the use of Directx. Almost complete, just need to research Lame OGG and FLAC encoders before it is finished!