I'll second or even third the recommendations put forth so far, and suggest going to an RDBMS. The extra effort involved in writing an SQL query is definitely worth the effort, both in reliability, ease of use, and most of all user experience.

For simple things like what you are doing, I'm sure that some of the DB Abstraction modules will do everything you need and more.

I used for the first time SQLite.pm the other day for a quick and dirty keyed table for fast insert and lookups, and it is blazingly fast, fully ACID compliant (I think?) and best of all is all in one self-contained module.

It's definitely worth trying out, and easier for small projects than setting up a mysql/postrges instance to deal with one small transaction.

In reply to Re: Append to a busy flat-file db without leaving customer in lurch by hubb0r
in thread Append to a busy flat-file db without leaving customer in lurch by davebaker

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.