[Catalyst] Mason + DBI + Catalyst?

[Daniel Carrera]

Andrew Rodland wrote:
> The 
> info you need on how things get glued together is in perldoc 
> Catalyst::View::Mason and perldoc Catalyst::Model::DBI.

I didn't know about Catalyst::View::Mason, thanks. Btw, this is related 
to the point of my post, it is hard to RTFM if you don't know where the 
FM is. Or rather, the FM I knew of was about TT rather than Mason.


> And incidentally, you're wrong about DBIC. As soon as you get into queries for 
> related tables, DBIC will be reducing the amount of code you need to write 
> (and the number of potential screwups) tenfold.

I hesitate to make predictions like this. I don't know DBIC, and you 
don't know my queries. I know that I find SQL no harder than Perl, and 
that I appreciate being able to experiment with queries with phpMyAdmin. 
So I can't help but wonder if it really makes sense to use a Perl module 
to write the SQL for me rather than write the SQL directly. How would 
you tell DBIC to use a sub query or to use a temporary table? Is it hard?

Daniel.