comment on

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):

ID Number	Filename	Description	Location	Date	Time of Day	Weather	Int/Ext
1	pdrm0001.jpg	Shot of Bozorth Hall entrance	Bozorth Hall	2002-09-15	Afternoon	Cloudy	Exterior

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.

I have 25MB of SQL storage on the webserver
Easily updateable, searchable
Reliable, wouldn't be a homerolled solution

I have absolutely no idea how to start the thing, and know just enough to search the database (any suggestions for a good Perl/SQL tutorial?)
Not sure how easy I could back it up, or modify it on my machine and upload it

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 could start this today and get it mostly done without needing to learn something new
I could set it up on my machine and upload it after I know it works

Could easily get out of hand
All information is not in one place

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
newrisedesigns.com

In reply to Choosing a database for a new project by newrisedesigns

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Keep It Simple, Stupid
	PerlMonks