BE as a digital image repository
Posted: Tue May 08, 2007 8:14 am
I just spend about half a day searching the web and versiontracker for an appropriate database solution to start building a digital image collection which allows one to associate information at a greater level of detail with each image than iPhoto and a better way of querying this information to retrieve particular images. This is supposed to be a long-term solution, which basically should hold most of the digital images on my computer, research-related in the first place, but also personal photos meant for long-term storage.
I looked at Scribe, Filemaker itself, Devon Think and a couple of open-source solutions (none of which, however, appears to be developed systematically enough to trust one's data to it without having having programming skills oneself). In the end the conclusion I appear to arrive at, is that Bookends probably is the best suited solution.
- It allows for the level of detail I want to associate to each image
- It would allow automatic generation of captions to illustrations in articles through the combination of a citation and a custom format.
- It allows for quick visual browsing of the images by having the info drawer open in list view.
- It would allow me to leave the images themselves in one location on the hard disk, thus making it possible to reach out to them from various applications, saving Finder comments to the files to query this information through Spotlight and applications which rely on this, and entering keywords in Preview.
The possible drawbacks of using BE for this purpose appear to be:
- the necessity to create a record for each image at an individual basis.
- the lack of a possibility to import the metadata of an image file
In addition, there are two things I would like to clarify:
a) is it possible to insert attached images into a citation alongside the information contained in the database fields?
b) Suppose that in a dark future I will (have to) stop using BE - would there be a way of exporting the information contained in the database fields in association with the filenames of the files attached to the references in a format which could be imported into other database applications?
I looked at Scribe, Filemaker itself, Devon Think and a couple of open-source solutions (none of which, however, appears to be developed systematically enough to trust one's data to it without having having programming skills oneself). In the end the conclusion I appear to arrive at, is that Bookends probably is the best suited solution.
- It allows for the level of detail I want to associate to each image
- It would allow automatic generation of captions to illustrations in articles through the combination of a citation and a custom format.
- It allows for quick visual browsing of the images by having the info drawer open in list view.
- It would allow me to leave the images themselves in one location on the hard disk, thus making it possible to reach out to them from various applications, saving Finder comments to the files to query this information through Spotlight and applications which rely on this, and entering keywords in Preview.
The possible drawbacks of using BE for this purpose appear to be:
- the necessity to create a record for each image at an individual basis.
- the lack of a possibility to import the metadata of an image file
In addition, there are two things I would like to clarify:
a) is it possible to insert attached images into a citation alongside the information contained in the database fields?
b) Suppose that in a dark future I will (have to) stop using BE - would there be a way of exporting the information contained in the database fields in association with the filenames of the files attached to the references in a format which could be imported into other database applications?