| Author | Thread |
|
|
05/07/2003 11:54:29 AM · #1 |
I'm thinking about developing a database designed to keep track of photos. Other than the database being able to read EXIF data from the files, and the option of printing at various sizes, what else would you like to have in a photography database?
Thanks,
Adam
|
|
|
|
05/07/2003 11:59:47 AM · #2 |
1 ~ Ability to sort on EXIF date.
2 ~ Thumbnail generator
3 ~ Easy way to copy "keepers" to a seperate folder.
4 ~ Possibly the ability to rotate 90degrees (Easily)
That's all I can think of for now :)
Message edited by author 2003-05-07 12:00:21.
|
|
|
|
05/07/2003 12:01:21 PM · #3 |
| I like the ability to tag photos that some software has so that it's possible to sort by different categories...ie. all pet photos, all flower photos, all kid photos...and to be able to tag a photo multiple ways. |
|
|
|
05/07/2003 12:02:08 PM · #4 |
Ability to sort on all EXIF fields (I've used this in the past to find all close focused images, or all shot at particular aperture/ shutter combinations etc)
CD/ DVD backup/archiving support/ index generation/ html indexing automation
Support for a variety of RAW file formats
fuzzy searching on topics/ titles
an easy way to apply categories to pictures (this is the main lack with most databases)
Support for 100,000 pictures or so, probably more with resonable performance
Message edited by author 2003-05-07 12:03:01. |
|
|
|
05/07/2003 12:45:59 PM · #5 |
A means of adding keywords that doesn't require four or five mouse clicks before you start typing - would only need to be a text box and an enter buttton.
Ed
|
|
|
|
05/07/2003 01:10:21 PM · #6 |
My camera produces a text file containing the EXIF data, so using by 4D i wrote a database to import this data, I have added field allowing me to categories the pictures, so I can find all the photos of say "landscapes" very easy.
I was thinking of importing the photos but the database would grow very very fast.
"Support for 100,000 pictures or so, probably more with resonable performance" 100,000 x 1.5megs = 150GB need a very very large hard drive.
just my 2 cents
T
|
|
|
|
05/07/2003 01:13:59 PM · #7 |
The user should have the ability to add categories for sorting and include extra search phrases.
I am also working on a database with a friend of mine and our favorite feature up to now is the user system. It will have the button "I am on this photo". That way your friends can help sorting and you can search for photos of groups of people.
The main problem yet to be solved is how are we going to keep the exif data for photos we change in photoshop.
2 choices:
a) load all originals to database and save exif data on the server side. Change the photo and replace the original with the photoshoped one.
b) use a client side program to collect all exif data and image names into a textfile which is uploaded with the photos.
both seem tidious ... any suggestions?
Message edited by author 2003-05-07 13:15:11.
|
|
|
|
05/07/2003 01:16:54 PM · #8 |
a rating field attached to each image where you could enter a rating, such as a "1" or "2"... or nothing, and later be able to sort all of the images by this rating. With this you could have view the 1's or all the 2's at the same time. Photoshop has a rating field but I think it only works on a folder at a time, not sure if it works on subfolders.
|
|
|
|
05/07/2003 02:54:59 PM · #9 |
Just thought of another...
The ability to archive to CD/DvD but to have large thumbs (small file size) stay on the hard drive... Then if you say you want it, it tells you which CD/DvD to put in...
Does that make sense?
|
|
|
|
05/07/2003 03:20:57 PM · #10 |
Originally posted by agwright:
"Support for 100,000 pictures or so, probably more with resonable performance" 100,000 x 1.5megs = 150GB need a very very large hard drive.
|
150Gb isn't that big by current standards, but yes, I'd expect a decent
database to be well integrated with an offline storage/ archiving/ recovery system. At least knowing which disks files were archived to, keeping the textual meta-data for the archived image and also probably associated thumbnail indexes. The real trick is having a database that
can process that amount of files efficiently.
btw the files a high end digi-cam produces are closer to 6-12Mb not 1.5Mb, so we are probably looking at closer to 600Gb or so
Message edited by author 2003-05-07 15:22:23. |
|
|
|
05/07/2003 03:34:01 PM · #11 |
A really valuable feature would be to integrate some sort of OCR technology that can automatically extract race numbers from the pictures.
There are a whole load of sports event photographers who would be very happy with you if you could work out something that does that ! |
|
|
|
05/07/2003 03:51:29 PM · #12 |
are we talking about a personal system or server/client system?
|
|
|
|
05/07/2003 06:33:11 PM · #13 |
Originally posted by agwright:
are we talking about a personal system or server/client system? |
Personal...right now. |
|
|
|
05/07/2003 08:23:11 PM · #14 |
So this is to be a personal software app? I have been using iView MediaPro for Mac and it does almost all of what has been mentioned. Is there nothing very adequate for windows? Or is this for something more specific in terms of photography. The above handles all multimedia files.
tracy
If nothing else...would be a good app to "cheat" off of for ideas.
|
|
|
|
05/08/2003 11:48:57 AM · #15 |
Thanks everyone for the tips...i'm going to go a way now and make this little application. I'll keep you all posted.
aj
|
|
Home -
Challenges -
Community -
League -
Photos -
Cameras -
Lenses -
Learn -
Help -
Terms of Use -
Privacy -
Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 08/28/2025 07:26:39 AM EDT.
