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":