What I've done for a simple photo database is create a small file called and .iif (photo1.jpg has a photo1.iif). The file is XML and has a format includes descriptions locations, etc..I like the separate files because its easier to edit them and they will work with my slideshow viewer when I'm done with it.

I tag my photos on a local webserver, which creates the files. Then When I upload the files to my real live web server I can load the xml .iifs into the database. I actually stuff the whole xml .iif file into one field of the database so its easy to search.

There are some downsides. Filename changing is hard. Having data in 2 places is ackward and you have to go through all the files to see if there were any changes to the files that aren't in the database. Also the data part of the file isn't usefull when its in a text field.

This system works for me

In reply to Re: Multimedia DB. Perl in the backend. by acomjean
in thread Multimedia DB. Perl in the backend. by amonroy

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.