Photograph databases

[kevin_i_orourke]

I'm looking for a database system for storing information about photographs. I started writing my own using MySQL and Perl but I keep losing interest and I could really do with something that works now.

Does anyone out there know of anything like this? I don't want one of the many web album generators, most of the photos haven't been scanned in and may never be (it takes so long to scan slides). The database has to be able to handle thousands of photos, my current database has about 3000 slides in it.

There seem to be lots of applications for storing details of CDs, DVDs, videos, etc. I can't find any for photos!

[OdinsDream]

That's the thing... they store details about the items...not the items themselves.

You'd store the actual files in your standard filesystem, and the mySQL database would only reference the filename, and perhaps a file ID or something. Using this method, you'd create the anchor tags on the webpage that reference the location of the actual image file.

[kevin_i_orourke]

[seang]

I share your desire for such a beast!! I've resorted to a stonking great spreadsheet to record such details, but it's far from ideal... I've scanned a couple of thousand family photos (slides, negatives, prints,... took AGES!) an would love a better way to reference them...

Oh well, I guess worth watching this thread to see if some bod comes up with something.

Cheers,
Sean

PS Kevin - Your last name is not so very different from my own!!

[B_F_Skinner]

What about the Gnome Photo Collector?

I haven't tried this, but the screen shots look good.

Here it is

http://www.gnome.org/softwaremap/projects/gphotocoll/

[B_F_Skinner]

posted above, but didn't bump for some reason...

[pjp]

[Matje]

If interested, I could write a quick php-script for this, but there are many allready available (google all the way)

I myself use one I created for my site which reads al the directorys in a certain dir, names the foto-albums after the name of the dir, and places all the files in the dir into the album. This could easily be upgraded to creating a comment of the filename. Filesize, format, ... can be extracted on the fly by php

[B_F_Skinner]

no, I edited to try to bump it because it didn't bump the first time. I waited a while and it still didn't bump, so I posted again.

As for the script, I'd be interested in seeing it here if it weren't too long, else a link would be fine.

Thanks all.

[kevin_i_orourke]

Gnome Photo Collector looks good, I'll have to give it a try.

The PHP suggestion wouldn't really work. I don't have image files for all of the photos (ever tried scanning 3000+ slides?), so scanning directories and extracting information is a non-starter.

I used to use a Microsoft Access database for this, but now I've moved to Linux that's no longer an option.

[fmalabre]

[doug-x07]

Ok this is probably not the easiest solution to your request and involves the steepest learning curve. Oracle database handle binary large objects blobs natively in their databases in a similar (but not identical way) to other datatypes. You just load up you photographs then handle them with plain sql. It really is the best solution available, but its up to you if you want to take the effort of installing, administering and learning the beast. Maybe that is not what you are after, but the outlay is worth it as it scales beautifully and can be adapted to any use you want. Just wanted to let you know the possibility exists.
_________________
#! /usr/bin/perl
if( @first != $succeed ) {
post { $question->forum && eval '$answers' };
try { $again } catch { $problem && $resolve };
bless $posters; }

[pilla]

A little bit too overkill for me =) I use pixie to make web galleries with thumbnails. Then, I edit the HTML to add information about each picture.

[Tiganu]

[fmalabre]