Hmmm, 1000 records. That is a rather small database. It is large on a Pc scale, but small on a business scale which most of the SQL drivers and technology are targetting.

I once developed a module called Lady /TM to manage small persistent data indexes for a website. The use of the indexes came out of realizing that precomputed cache's can be time-saving. Actually they were crucial to the success of the project.

With Lady /TM there is compatibility with EZDB (which you could also use.) EZDB is at EZPERL.com. It is a flatfile database manager that you can use online. This means you can set it up via FTP access in a remote CGI bin and use the WWW to manage your live data. Lady /TM has no interface like EZDB. EZDB requires that you setup templates for display and entry. With Lady /TM I write scripts that need fast access to site-related data in prototyping. Lots of site data is purged, keeping the datafiles small.

Like a flatfile, Lady /TM keeps a header of the top line. Something like:

pkey|index|value1*~*value2*~*value3*~*value4*~*value5*~*|blank|

The table methods let you grab the string values from a hash after it is initialized. Processing the string is easily done with conventional flatfile processing methods.

With enough interest, I will develop the needed code to allow creation of forms, designating the index and the order of the rest of the fields and values within the flatfile record.

Lady /TM was posted to this forum under the Utilities scripts.

-Steeeeeve

In reply to Re: Flat File Database by Steeeeeve
in thread Flat File Database by Yoda

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.