When writing programs for the net that need to access external data I generally lean towards storing that data in a database of some sort. There are lots of reasons for this, namely security and the fact that it is easier to deal with multiple access of the database - there is no need to manually lock files, etc.

There are a large number of databases that will work on both linux and NT, MySql works well, so - or so I have heard - does Postgress SQL and both have the added advantage of being free ;) Oracle will happily work on both platforms as well. If all of the above seem too complex for your task there is always the old comma-seperated database, accessed via DBI::CSV.

DBI is my interface of choice, both for it's stability and flexibility and becase it provides an easy way to standardise calls to databases across networks, operating systems and even database types. Some access methods you could choose are DBI::mySql DBI::Oracle and DBI::ODBC although the last will requre that you have installed the ODBC driver onto linux.

All calls to the database then are made as the webserver's user and will happily access data providing that user has access rights to the database and can be nade very secure by the use of passwords and storing the database files themselves in a non-web accessable location.

Hope this helps!

$japh->{'Caillte'} = $me;

In reply to Re: Web-based configuration and secure data storage by Caillte
in thread Web-based configuration and secure data storage by dash2

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.