Well, the filesystem gives you hierarchy and an RDBMS can give you the tagging you need. To start, I would mock this up with a CGI that has access to a predefined set of folders. You can get a quick tagging system going by making the md5sum of the file be the key in a single table sqlitedb and create entries like (md5sum,tag) each time a tag is applied to a file. there are a million good directory strategies, research them. For thumb presentation try mirroring the full size photos from the top of the tree like: root->photos and root->thumbs, so when someone clicks the thumb, just change the root. this is just a start but i think you'll see how easy it can be. the hardest part will be presentation. you might also want to look at INTERCHANGE, since it is good at cataloguing, you might get most of the functionality you need there.


humbly,
novitiate

"...goodnight you princes of main(e)"  --The Cider House Rules

In reply to Re: Photo Database Application by novitiate
in thread Photo Database Application by Limbic~Region

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.