Errrr, I didn't.

It is a matter of scale. If the amount of data is small and the database design is simple then why not?
Least ways you can spare yourself the great overhead (and often cost) of creating a SQL database and having to support it (I've seen so many sites where whole teams of DBA's were needed to support relatively simple databases)

For under 5000 records I'm not convinced that opening a database connection squirting your SQL across the TCP socket and getting a reply back is any quicker than scanning the file. Especially if your data set has no suitable keys. Having said all that I'm quite a fan of AnyDBM_File as well

Maybe I'm just an old disillusioned DBA :-)

"We are all prompted by the same motives, all deceived by the same fallacies, all animated by hope, obstructed by danger, entangled by desire, and seduced by pleasure." - Samuel Johnson

In reply to RE: RE: editing/deleting record in flat file database by Jonathan
in thread editing/deleting record in flat file database by Anonymous Monk

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.