Re^2: RFC: CGI/MySQL - improving my code

Hmm, well CGI::Application is already on my list.

I intend to use HTML::Template rather than Template Toolkit - any thoughts?

I'll look into those DBI modules - I did wonder whether I should just carry on implementing DBI or whether there were useful modules that present a cleaner code-base for sql transactions (my reservations about such a module would be that it either makes too many assumptions about what you want to do, or ends up not really being much different from rolling your own sql).

BTW fixed typo - HTML::Template rather than HTML::Application iirc

Tom Melly, tom@tomandlu.co.uk

Comment on Re^2: RFC: CGI/MySQL - improving my code

Replies are listed 'Best First'.
Re^3: RFC: CGI/MySQL - improving my code by rhesa (Vicar) on Mar 27, 2006 at 13:02 UTC
I agree with dragonchild: Template Toolkit is very much worth the learning curve. I've been using HTML::Template for a long time now, but TT's dot notation alone is such an amazing feature that it's inspired Mark Stosberg and me to write HTML::Template::Pluggable to provide HTML::Template with the same feature. You can take it from me that TT's implementation is far superior.	[reply]
Re^3: RFC: CGI/MySQL - improving my code by perrin (Chancellor) on Mar 27, 2006 at 14:31 UTC
Even if you write the database objects yourself from scratch, it's still worth doing, to isolate that code from the rest of your program. You may actually want to try writing it from scratch once, just to see what's involved. In most cases you can mix your own hand-written SQL with these modules. You'll find that Rose::DB::Object provides the ability to do almost any SQL you need without resorting to that though.	[reply]