|Just another Perl shrine|
Choosing a database for a new projectby newrisedesigns (Curate)
|on Oct 15, 2002 at 20:26 UTC||Need Help??|
newrisedesigns has asked for the
wisdom of the Perl Monks concerning the following question:
I began a side project this past week which involves taking pictures of my college campus and having the pictures online.
I plan on having a lot (at least 1000) and would like to have some sort of search method on the pictures. I'd like to use some sort of database, either mySQL or Berkeley_DB (both of which are on my webserver) that can be easily searched using one or more criteria to return relevant photos.
My table looks like this (although more columns may be added):
What methods could I use to store this information, and have it easily accessible to the public through a CGI script?
I have two ideas currently, and would welcome any other data storage suggestions
One: Use mySQL to construct a database with the following information.
Two: Use a few Berkeley_DBs to make each category. (One DB called Weather.db, which has key value pairs of ID_Number => Weather_Condition)
I would really like to learn mySQL, however I'd like this project to get off the ground soon. I might not have 1000 pictures yet, but I'd like people to see the work in progress.
Any suggestions or votes on which why this should be done would be most greatly appreciated.
John J Reiser