You might want to just try it out with some test pages.

Benchmark the differences between serving static images (with the paths determined from information stored in the database) and images straight out of the database.

Besides the performance differences, you also need to consider how to put the images in safely. If I make the assumption that the course materials will be maintained through webforms, you have to remember you will need to deal with getting the content in as well as getting it out.

Some other gotcha's might be not being able to use certain sql calls depending upon the database (older mysql wouldn't allow groupby with blob or text fields for example).

Personally I would give it a test though, it is an interesting exercise, and under the right circumstances a nifty way to handle certain problems. For example, one site I maintain has little images of authors that I keep in the database...they are used on several sites concurrently. Keeping them in the database means I don't have to worry about having common directories, and whenever they add new sites, the author bio section is plug and play easy. I had to compromise and not allow the client to put the images in themselves (to check sizing and for security), but they can handle the rest of the info through a web form.

EEjack

In reply to Re: Is it a good idea to store images in a RDBMS? by eejack
in thread 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.