I use a simple key/value configuration table for site wide things such as webmaster email addresses. I find it hard to imagine site wide configuration data with a more complicated structure than key/value pairs that shouldn't be in a specific table of its own. Can you give examples of the sort of site wide configuration data that is problematic?

If the configuration data only applies to part of the site it should be handled by the code that manages that part of the site and should either store the configuration in existing relevant tables, or should add configuration tables specific to the site area as required. It may be useful to write a base class that does most of the common heavy lifting for managing configuration data then provide site area specific derived classes as required.

True laziness is hard work

In reply to Re: mapping complex structures to mysql tables by GrandFather
in thread mapping complex structures to mysql tables by niubi

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.