Something that hasn't been mentioned thus far but I think bears mentioning about (3): If you rely on flat files to store data, then you've got to worry about file locking; that is, two CGI processes fighting over or otherwise munging a flat file in a very bad way because each doesn't know the other is doing something to the data.

Frankly, it's easier just to learn about how to put together a simple database than to deal with all the issues that arise from working from flat files. (By easier, I mean maybe not to get the thing running at first depending on your level of familiarity with databases, but over the life of the project, in terms of maintenance and upgrades etc., the time savings will be considerable.)

I'll reiterate what the earlier poster said for emphasis: Only good things will come of learning SQL and some basic database skills. You'll use them over and over (and over and over ...) again in your career. Furthermore, with the advent of high-quality open source databases (I have used MySQL quite extensively for things that don't require the big iron approach of Oracle and am very impressed), your learning curve is not very steep, the learning environment is free and very easy to install (based on my experience with Linux), and the production environment is super-cheap (assuming you're a good citizen and donate a few hundred bucks to the open source group :-).

Hope this helps!

In reply to Re: General Guidence by Starky
in thread General Guidence by Legg83

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.