Question though: how stable is MySQL in comparison to say, a DBM or a flat file for small (under 5000 entries) databases?

Well, that depends - mostly on the load, I'd think. With such a small db it's hard to generate enough load to really stress the system. You probably would not feel the difference at all as everything will fit in memory just nicely.

With a RDBMS you have the flexibility of the relational data model and the power of SQL. It may not be necessary in this project, but maybe in the next one. I found PostgreSQL Tutorial to be a fairly good introduction to SQL.

Is it realistic to think that I could set up a system that allows them to add, edit, and remove records with a web interface and not have to be there to maintain it?

If you set up any system - especially a database - it is bound to require maintenance. Something can always go wrong, and eventually will.

Here's one (a bit old) article which I found enlightning: MySQL and PostgreSQL Compared by Tim Perdue; and here's another: Why Not MySQL? by Ben Adida.

--
sligi

In reply to Re: Re: Stick w/the DBMs by sligi
in thread Question about properly laying out a database by Stamp_Guy

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.