I am guessing you are _not_ an expert programmer. I have nothing against reinventing the wheel, if you know what are you doing. My guess is this is not your case. So, my advice will be to use some standard module.

For database based on flat files, you may want to check DBD::CSV and DBD::File. They implement all features you are aware now, and then some more. Available on CPAN mirror near you, or on search.cpan.org.

And remember, hardly anybody will ever want to use your database, if it is not compliant with DBI standard.

It is good for you having ambition, but IMO less ambitious project will better serve your goal to learn perl. If I have time to spare, I'll go for i.e. Daft text adventure project, which is BTW also using (existing free) database.

Hubris might be a virtue for a perl programmer - but not always. There are situations, where perl monks is better served by being humble and learn from experts. It's your call to decide what is better for you. Just my $0.02.

pmas

To make errors is human. But to make million errors per second, you need a computer.

In reply to Re: The Never-ending Database by pmas
in thread The Never-ending Database by psypete

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.