Photos

[Shane_Mc]

I have to create a database (basically) to index photos.....i.e. a photo album.

It is a fairly simple database in that all that is required is the date of the photo where it was taken etc. But the problem is the photo itself. How should I go about keeping the Photos in the database. Is there a way to actually store them in the DB or should I put in a link to where they are stored on the hard drive (they are and only ever will be on a single, stand alone PC). They are all in jpg format and so are relatively small.

I haven't even started this project yet so any suggestions are welcome and will indeed be appreciated.

 

[cpod]

I would store just the address of the jpeg file in the database.

 

[BLeslie88]

What we did...

I work for a retail company, we have 10,000's of photo's and communication problems, nothing worse then running after people for information... We used the code as the naming convention for the photo.
Example:
Luggage Piece: 9047-0128
Would be stored on z:\Test\Luggage\9047-0128
Any other code for luggage would be in this directory. If the code had no photo a photo would display N/A... We loaded photo's at run time. This was to make database work maintenance easier.....

Hope this may give you some ideas...

Regards,
Brian K Leslie