Hi Brett,
Sounds like a fun project.
I am not a professional programmer, but if you want to get something up
and running quickly I have 2 cents. I was playing around with a similar
project a few years ago. I made a website called
www.bookmonkey.com.au as an online exchange of used books. It never
went anywhere but it is still running and (believe it or not) people
occasionally use it.
My thoughts:
1. find a template / sample code that is close to what you want, and
then modify it. No need to recreate the wheel, and if you are lucky you
will be able to learn from well-written code
2. mySQL programming can be overwhelming at the very beginning because
there are so many commands and permutations. There are only about 5
commands that you really need
3. To make the user experience easier, I would suggest looking at a
barcode scanner. You can get a USB barcode scanner on ebay for $30.
Your computer thinks the barcode scanner is someone typing into a
keyboard -- so there is no special code to write
4. For mind-numbing categorization that will require human input, take
a look at Amazon Mechanical Turk. It is paid crowd-sourcing of
repetitive tasks.
5. Eye-Fi wireless SD card might be helpful for automating the
picture-taking process. Put the wifi SD card into your camera, and any
photos you take are wirelessly uploaded to your computer
Cheers,
Ken