This is more of a general design question than a perl question, so let me apologize in advance for my breach of monkly etiquette.

I've been working on a system for the web based delivery and management of academic course materials. The system itself is perl/cgi.pm based and stores the course materials in a MySQL database. The course materials are, for the most part, text with a bit of embedded markup. The system takes the course materials and generates HTML for output. Any non-text element such as an embedded graphic or sound is stored outside of the database in the file system. I am currently in the process of writing a new version of the system to use mod_perl to enhance performance and to clean up a rather messy database design. I've been toying with the idea of storing images and sounds in the database rather than the file system. My problem is that I'm really not sure this is a good idea? Does anybody have any experience with this kind of setup? If so, are there any issues (performance, security, etc.) I should be aware of before I begin?

----
Coyote

In reply to Is it a good idea to store images in a RDBMS? by Coyote

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.