I've been creating a database-backed website, (MySQL/Perl/HTML::Template) but for various reasons, its content is now pretty stable, and doesn't need to be sourced from the DB 99% of the time. Presumably the site will run more quickly if it's just flat pages.

So I'm thinking, I could just grab the whole site, maybe with wget or something, then re-sync the local copy to the website.

Of course, that will be the point where I discover that 23 of the 10,000 pages are wrong. If I hadn't done the above, the solution is to fix the data in the DB and ... nothing. The site is now correct again for the next person who browses it.

So, is there some kind of solution to this problem in Perl, Apache, etc?

The ideal state of the website is flat, until I notice a mistake, at which point I correct the mistake, "un-flatten" the problem files, render them and "re-flatten" them.


($_='kkvvttuu bbooppuuiiffss qqffssmm iibbddllffss')
=~y~b-v~a-z~s; print

In reply to Flat Website From Database Website by Cody Pendant

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.