This isn't a simple problem, but one suggestion about a factor that you seem to be ignoring.

What are you using for version control? There are many kinds of problems you need to deal with, and security is only one of them.

Personally I would suggest having the data and some local configuration nowhere near your cgi-bin for the simple reason that it is nice to have your cgi-bin under the control of CVS, and you don't want to check all of your data files into CVS! Likewise it is good to have the possibility of per user configuration information safely out of CVS.

A lot of schemes are possible, but the simple step of using some versioning scheme on important files saves many headaches, makes it much easier for developers to work in close cooperation. Just remember to commit and update early and often...

In reply to RE (tilly) 1: Organization Redux by tilly
in thread Organization Redux by footpad

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.