Re: Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread David E. Wheeler
On Jun 27, 2011, at 4:20 PM, Dave Morgan wrote: > What's the point of it? First of all, what Perrin said. :-) > As far as I can see the author claims to have issues with Apache::DBI and > does not > like the hidden aspect. FWIW, I am the author. > I have never experienced his "issues" and the

Re: Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread Perrin Harkins
Please calm down, folks. Apache::DBI is a module that was designed to help with porting legacy CGI applications to mod_perl. It's a valid criticism to say that the action-at-a-distance parts of it are undesirable in new mod_perl applications. Personally, I have used mostly custom caching code in

mod_perl-1.31 compilation with perl 5.14.1 fails

2011-06-27 Thread Gregory Coleman
hello - am getting compilation errors in building older mod_perl with newer perl. Things worked as of 5.12.X, but alas, not with today's 5.14.1 eg. http://cpansearch.perl.org/src/GOZER/mod_perl-1.31/Symbol/Symbol.xs Symbol.xs: In function 'undef': Symbol.xs:33: error: invalid lvalue in assignmen

Re: Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread Dave Morgan
On 27/06/11 04:27 PM, David E. Wheeler wrote: On Jun 27, 2011, at 1:40 PM, Dave Morgan wrote: You lost me. But really, I strongly recommend against the use of Apache::DBI. Some discussion here: http://search.cpan.org/dist/DBIx-Connector/lib/DBIx/Connector.pm#Description And having read

Re: Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread David E. Wheeler
On Jun 27, 2011, at 2:17 PM, Fred Moyer wrote: >> You lost me. But really, I strongly recommend against the use of >> Apache::DBI. Some discussion here: >> http://search.cpan.org/dist/DBIx-Connector/lib/DBIx/Connector.pm#Description > > It seems like you are looking for a more feature rich db c

Re: Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread David E. Wheeler
On Jun 27, 2011, at 1:40 PM, Dave Morgan wrote: >> You lost me. But really, I strongly recommend against the use of >> Apache::DBI. Some discussion here: >> >> >> http://search.cpan.org/dist/DBIx-Connector/lib/DBIx/Connector.pm#Description >> > > And having read that, I strongly recommend a

Re: Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread Fred Moyer
On Mon, Jun 27, 2011 at 1:22 PM, David E. Wheeler wrote: > On Jun 27, 2011, at 1:13 PM, Fred Moyer wrote: > >> Wow, that's obnoxious: >> >> 1237   if ($INC{'Apache/DBI.pm'} && $ENV{MOD_PERL}) { >> 1238     $old_connect_via = $DBI::connect_via; >> 1239     $DBI::connect_via = 'connect'; >> 1240   }

Re: Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread Dave Morgan
On 27/06/11 02:22 PM, David E. Wheeler wrote: On Jun 27, 2011, at 1:13 PM, Fred Moyer wrote: Snip . You lost me. But really, I strongly recommend against the use of Apache::DBI. Some discussion here: http://search.cpan.org/dist/DBIx-Connector/lib/DBIx/Connector.pm#Description And

Re: Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread David E. Wheeler
On Jun 27, 2011, at 1:13 PM, Fred Moyer wrote: > Wow, that's obnoxious: > > 1237 if ($INC{'Apache/DBI.pm'} && $ENV{MOD_PERL}) { > 1238 $old_connect_via = $DBI::connect_via; > 1239 $DBI::connect_via = 'connect'; > 1240 } DBIx::Connector does the same thing. > And it is also apparentl

Apache::DBI and DBIx::Class [was Re: How do you use mod_perl for your web application?]

2011-06-27 Thread Fred Moyer
On Mon, Jun 27, 2011 at 12:53 PM, Octavian Rasnita wrote: > Here is a comment that might be helpful, because it also explains why > DBIx::Class can work with Apache::DBI (and why it is not needed): > > http://lists.scsys.co.uk/pipermail/dbix-class/2006-April/001153.html > > "" > DBIx::Class alrea

Re: How do you use mod_perl for your web application?

2011-06-27 Thread David E. Wheeler
On Jun 27, 2011, at 12:53 PM, Octavian Rasnita wrote: > DBIx::Class already manages its connections for you, and therefore it > cannot benefit from Apache::DBI under any scenario. It makes one > connection per-process, and keeps that connection persistent, > reconnecting only if the connection ap

Re: How do you use mod_perl for your web application?

2011-06-27 Thread Octavian Rasnita
Here is a comment that might be helpful, because it also explains why DBIx::Class can work with Apache::DBI (and why it is not needed): http://lists.scsys.co.uk/pipermail/dbix-class/2006-April/001153.html "" DBIx::Class already manages its connections for you, and therefore it cannot benefit fro

Re: How do you use mod_perl for your web application?

2011-06-27 Thread McCarrell, Jeff
On 6/27/11 11:44 AM, "McCarrell, Jeff" wrote: >While this may not be the last word on this subject of DBIx::Class Db conn >caching, >a cursory glance at the documentation shows: >(http://search.cpan.org/~frew/DBIx-Class-0.08192/lib/DBIx/Class/Manual/Int >r >o.pod#Connecting) > > Note that D

Re: How do you use mod_perl for your web application?

2011-06-27 Thread McCarrell, Jeff
On 6/27/11 8:37 AM, "Fred Moyer" wrote: >>DBIx::Class just does its own persistent connection and this is why it >>doesn't need Apache::DBI. > >Do you have any evidence for this claim? I've been using DBIx::Class >with Apache::DBI for several years and have never seen anything to >this effect. >

Re: How do you use mod_perl for your web application?

2011-06-27 Thread Fred Moyer
On Sun, Jun 26, 2011 at 10:55 PM, Octavian Rasnita wrote: > From: "Randolf Richardson" >> I believe Catalyst depends on DBIx::Class, which also tries to turn >> off the connection caching features provided by Apache::DBI (if I'm >> recalling correctly) -- if this is true, then it could certainly

Re: How do you use mod_perl for your web application?

2011-06-27 Thread Perrin Harkins
On Sun, Jun 26, 2011 at 5:11 PM, Randolf Richardson wrote: >        I believe Catalyst depends on DBIx::Class As Octavian said, there isn't really a connection between the two. Catalyst people often use DBIx::Class, but there's no tie at a code level. >        To be fair, I think it would be imp