So below is my original post on StackOverflow. Since I got no answers there I started looking around and found this site. I am pretty much a "photo newbie" . . . given this is a photo specific site it occurs to me my approach might be completely wrong. Surely, photo experts need to attach tags and categories to pictures by the 100s or even 1000s . . . what is the best way to approach what I am trying to do here?
So my concept was simple, but so far my iPhone and iPad are refusing to cooperate:
I have several hundred boxes that the family keeps searching through. My thought was to take a picture of the contents of each box, then search through the pictures to find things and go directly to the box that has the item.
My first thought was to create a database with AirTable or such, but that is a pain and uploads my images to their server. Then it occurred to me that there is MetaData on these pictures, perhaps I could tag the photo with the box number that way. However, while there do seem to be some free format fields in the metadata, editing those fields has proven to be a challenge. I have yet to find a good editing program. For instance Metapho seems to be pretty close, but the paid version which says it can edit the MetaData, but can only edit JPG files . . . the iPhone pictures are not JPG.
My other thought was to use the iPhone "Markup" feature and write directly on the image, but that interface is not very convenient and has problems with fonts "washing out" depending on the colors the text happens to appear over.
It seems like this should be easy, but so far I haven't found a convenient way to do this. In essence I want to make a database of images joined to a database of tags . . . any suggestions on how to do this easily?
As a side note, phase II of this project would be to add a contents list to the metadata and then be able to pull up pictures by searching the tags in the metadata . . . so far, I don't see how to get the iPhone to select pictures based on metadata tags . . .