Caching db-generated pages

[pgosse]

Hi all. I'm looking for a bit of information on caching of db-generated pages. I've found a myriad of articles and posts on the topic, but none which fully explains what I'm looking for.

I'm working on a content management system which is backended with PostgreSQL 7.3, and in addition to storing page content in the database, we're also going to have image / pdf / doc files stored as BLOBs rather than on the filesystem for security purposes.

What I'm wondering is what is the best way to cache pages which are frequently requested and delievered via the database, and which also includes images which are pulled from the database?

For example, the site homepage always has a picture on it, which will change every couple of days. What I'd like is to enable something such that upon the initial request (by any user) of the homepage with a new pic, after the page is delievered to the user the server somehow caches it and the cached copy will be delievered until a newer version is implemented.

Similarly, there will be many pages whose content will not change very often, so I'd like to have said pages cached for significantly longer periods of time.

Does anyone have any ideas on what the best way is to achieve this?

Thanks in advance,
Pablo

 

[nidash]

essentially you would want client side caching which anyway is enabled isntit, for ie or any other client your pages would be delivered as plain html, which it should cache anyways, correct me if i am wrong.

cheers
nida