Yep, I'm nearing the end of a help desk project to be located at supportsql.com, the helpdesk is fully OO with custom modules such as a template parser, SQL module, tar module, dumper module and much more...its around 1.2MB in size and 2.8MB including images.

It has been tested with mod_perl 1.26 and works well (v. quick)....it requires Apache::DBI for persistent database connections.

The template parser is very advanced allowing great flexibility when retrieving things from the database...eg...

my $arrayref = $sth->fetchall_arrayref({});

...I just need to put:

<%loop tag_name%> <%endloop%>

...into my template and pass $arrayref into my parser and all the output is produced dynamically.

Inside that loop I can put any html or mysql column names and the output is dynamically generated.