I want to store my data as much as possible as flat file texts in a MySQL database

While you can store flat files as unstructured blobs in a database, if there is any structure in them, you should break the data up into "normal" tables with individual columns. Otherwise you will not be able to query this data in interesting ways, and a database is not giving you much over normal file system storage (except maybe easy remote accessiblity, but do you need that?).

Part of my website is quite static (About me, CV, online presentation of my thesis), other parts should be dynamically served (blog, literature database, CGI frontend for a webapplication I wrote)

I do not think you have to consider static rendering unless

Otherwise, managing static pages is not worth the extra head-ache. You have that CPU, so use it.
Of course, you have to be able to produce any given page in less than, say, three seconds. But if, for example, a page needs data that takes more than that to produce, you should periodically refresh a cache with that data and produce a dynamic HTML page from that (static) data, instead of producing a completely static HTML page. Once you have all the data for your page, formatting it into HTML is not going to take any significant amount of time.

In reply to Re: How to start making a database driven website with separation of content from style. by Thilosophy
in thread How to start making a database driven website with separation of content from style. by BioGeek

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.