It seems that you've thought this through enough that your ideas sound solid enough to me. Interacting with DBMS is no big deal in Perl, especially using DBI. Indeed Programming the Perl DBI is a fantastic book for a Perl user who is wanting/needing to learn how to interact with a database. I used this book on my first database/perl project and it was easy to use as a learning tool and as a reference later on.

As far as traps go, the only thing I would take time to consider is the use of MySQL as your database of choice. I personally use MySQL for home projects, but it does have some features that are lacking in other production-quality DBMSs. In general, people recommend Postgres as a more stable and more powerful database system. Depending on how many users, how frequently they'll be interacting with the database, etc.... you may want to look into using Postgres instead, or at least benchmarking the too with some sort of simulation to find out which one better suites your needs.

Cheers,
~CS

In reply to Re: First Perl DB integration project by CubicSpline
in thread First Perl DB integration project by ajt

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.