[Catalyst] Serving "static" content from DB

Ian Docherty catalyst at iandocherty.com
Sat Jun 6 11:41:35 GMT 2009


Mihai Bazon wrote:
> Hi folks,
> I'm working on a simple CMS (actually started it for learning Catalyst,
> but the goal is to be able to maintain a few websites with it).  Each
> page is stored in DB and it can have file attachments, also stored in DB
> (content is BLOB).
I may get shot down in flames for this, but I would not personally put 
page data or attachments into the DB in the first place. I would put the 
page into the filesystem and use the DB to reference the file contents. 
This would also satisfy your cache problems since you can retrieve the 
static data directly from the filesystem.

> When serving an attachment, instead of always retrieving it from DB I
> want to save them in a cache directory.  So the first time a file is
> requested, it will be fetched from DB, saved in cache, then I want the
> Web server to do the job as if it were a static file.  With plain
> ModPerl, I would do it like this:
>   $r->filename($path_to_saved_file);
>   # plus some more hacks if it runs after PerlMapToStorageHandler
>   return Apache2::Const::DECLINED;
> I expect something similar will work with Catalyst using the ModPerl2
> engine, but I was wondering if I can do something that would work well
> with the development server and FastCGI as well.
> Thanks for any hints.
> -Mihai
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/

More information about the Catalyst mailing list