I'm at the beginning of refreshing/cleaning one of my CPAN modules Chess::PGN::EPD which among other things requires a light weight database for some of it's functions. At the moment I'm using DB_File, but I'm completely open to other possibilities— mostly what I want is to impact my users as little as possible yet maintain functionality.

As a picture of the amount of information involved (not much by today's standards) here is what shows in a dos box:

C:\>dir
 Volume in drive C has no label.
 Volume Serial Number is 7C88-9BEB

 Directory of C:\Users\hsmyers\Perl_Dev\Chess PAUSE\PGN\Chess-PGN-EPD-
+0.23\CSV

10/02/2010  09:44 AM    <DIR>          .
10/02/2010  09:44 AM    <DIR>          ..
04/02/2002  08:12 PM           196,290 ECO.txt
04/02/2002  07:39 PM            90,173 NIC.txt
04/02/2002  08:12 PM           467,540 Opening.txt
               3 File(s)        754,003 bytes
               2 Dir(s)  58,299,342,848 bytes free

C:\>wc *.txt
  2786  11138 196290 ECO.txt
  1247   6231  90173 NIC.txt
  4661  34709 467540 Opening.txt
  8694  52078 754003 total

[download]

I'm not particularly hung up on difficulty of interface, but I do want reasonable response time for queries. I'm just beginning to think about the following:

So the question becomes 'What are your suggestions?'

--hsm

"Never try to teach a pig to sing...it wastes your time and it annoys the pig."

In reply to Least impact DB for CPAN modules by hsmyers

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.