[RDBO] dbh caching

2007-04-12 Thread Bill Moseley
Ok, I just have to ask. What are people doing for dbh caching? I know this comes up often: http://thread.gmane.org/gmane.comp.lang.perl.modules.dbi.rose-db-object/1138/focus=1140 Apache::DBI is mentioned, but, unless I'm mistaken, is limited to mod_perl environments. Can just save $DBH loc

Re: [RDBO] dbh caching

2007-04-12 Thread Peter Karman
Bill Moseley scribbled on 4/12/07 9:11 PM: > Ok, I just have to ask. What are people doing for dbh caching? > I know this comes up often: > > > http://thread.gmane.org/gmane.comp.lang.perl.modules.dbi.rose-db-object/1138/focus=1140 > here's my (admittedly buggy) code for doing this. It c

Re: [RDBO] dbh caching

2007-04-12 Thread John Siracusa
On 4/12/07 10:11 PM, Bill Moseley wrote: > Ok, I just have to ask. What are people doing for dbh caching? > I know this comes up often: > > http://thread.gmane.org/gmane.comp.lang.perl.modules.dbi.rose-db-object/1138/f > ocus=1140 > > [...] I'm also still trying to understand the point of a n

Re: [RDBO] dbh caching

2007-04-12 Thread Bill Moseley
On Thu, Apr 12, 2007 at 10:54:36PM -0400, John Siracusa wrote: > Keep in mind that if you replace My::Product in that post with > My::DB::Object, which is a common base class for all your RDBO-derived > objects, then you effectively get one connection shared by all objects from > all tables. Dunno

Re: [RDBO] dbh caching

2007-04-12 Thread Perrin Harkins
On 4/12/07, Bill Moseley <[EMAIL PROTECTED]> wrote: > Speaking of transactions -- anyone ever asked for nested transaction > support? We had a semi-long discussion about that a few weeks back, which you can find in the archives. > > > What about using Ima::DBI? Would that stomp on RDB? You'd pr

Re: [RDBO] dbh caching

2007-04-12 Thread Perrin Harkins
On 4/12/07, Peter Karman <[EMAIL PROTECTED]> wrote: > here's my (admittedly buggy) code for doing this. It caches a single dbh for > each unique RDB registry entry combination of domain.type.dsn. I know that it > breaks under mod_perl -- anyone spot why? (the error I get is from Pg: > "prepared >

Re: [RDBO] dbh caching

2007-04-12 Thread Bill Moseley
On Thu, Apr 12, 2007 at 11:59:55PM -0400, Perrin Harkins wrote: > On 4/12/07, Bill Moseley <[EMAIL PROTECTED]> wrote: > > Speaking of transactions -- anyone ever asked for nested transaction > > support? > > We had a semi-long discussion about that a few weeks back, which you > can find in the arc