Thank you all for your advice.

I will investigate the CSV option. Currently, the script reads and writes CSV files and does it pretty well. This has been an excellent option since (as it was pointed out) it requires nothing from the Web server. However, people now want to be able to use their databases.

Of course it would be cleaner to have one way of doing things rather than a CSV way and a DBI way. Unfortunately, performance will dictate whether or not I replace the current machinery for reading and writing CSV files.

Thank you also for recommending some databases. However, other than CSV, I am not planning to implement any particular database but instead a framework where people can configure my script to make use of whatever database they have installed on their Web server. I think DBI will be very good at this.

I'm proceeding with DBI and will sort out the installation issues for DBI and the various database drivers. I will be finding out if it's better to include lots of drivers with my program or have webmasters download and install drivers themselves, avoiding any possible licensing problems.

Thanks again,

Richard

In reply to Re: To DBI or not to DBI by rzward
in thread To DBI or not to DBI by rzward

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.