[cgiapp] Combining DBIx::Simple and CGI::Session

[Ron Savage]

Hi Ron

On Wed, 2008-10-01 at 12:33 +1000, Ron Savage wrote:
> Hi Folks
> 
> The docs for DBIx::Simple cleary warn about using the dbh() method to
> get the db handle for use outside DBIx::Simple.
> 
> And yet, with CGI::Session, if I pass in a handle (returned from
> DBIx::Simple or otherwise), I know CGI::Session will be doing queries
> whenever it feels like it.
> 
> So, what to people do?
> 
> Use 2 handles, 1 via DBIx::Simple for all normal queries, and 1 via DBI
> just for use with CGI::Session?

Actually, another possibility is to use 2 DBIx::Simple-based handles,
one for all normal queries, and one to pass to CGI::Session but not ever
use via DBIx::Simple.

Recommendations?

-- 
Ron Savage
ron at savage.net.au
http://savage.net.au/index.html