Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Andreas Marienborg
I assume you have considered adding this to your dbic-schema? If it is all to deal with the same DB, and the same structures, you might benefit from that. andreas On 4. okt. 2006, at 04.27, Daniel McBrearty wrote: basically it does some fancy processing on the db and caches the results.

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Daniel McBrearty
I have. Could do it either way, but on the whole I prefer to seperate the two. Even if I did that, I think I'd have the same question - how to get a connection without creating a new one. On 10/4/06, Andreas Marienborg [EMAIL PROTECTED] wrote: I assume you have considered adding this to your

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Daniel McBrearty
maybe I'm worrying too much about reusing the catalyst connection - I could just get a connection in new() and keep a ref to it there, and use that whenever needed. I don't know much about what goes on internally, or how much overhead each connection has with it ... On 10/4/06, Daniel McBrearty

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Matt S Trout
Daniel McBrearty wrote: I have. Could do it either way, but on the whole I prefer to seperate the two. Even if I did that, I think I'd have the same question - how to get a connection without creating a new one. $storage-dbh DO NOT CACHE THAT Grab it each time, then you benefit from all of

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Daniel McBrearty
ok. thanks. what is the magic? is its behaviour in one of the perldocs? On 10/4/06, Matt S Trout [EMAIL PROTECTED] wrote: Daniel McBrearty wrote: I have. Could do it either way, but on the whole I prefer to seperate the two. Even if I did that, I think I'd have the same question - how

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Matt S Trout
Daniel McBrearty wrote: ok. thanks. what is the magic? is its behaviour in one of the perldocs? It auto-reconnects as required etc., handles reconnection post-fork and thread spawn, that sort of thing. -- Matt S Trout Offering custom development, consultancy and support

[Catalyst] getting the db connection used by catalyst

2006-10-03 Thread Daniel McBrearty
if you have a (dbix) database, and use it as a model, you generally end up doing this : $c-model- and the database connection is handled internally. I now want to write another model which uses the db. It would be better to use the existing connection that cat has created, rather than

Re: [Catalyst] getting the db connection used by catalyst

2006-10-03 Thread Brandon Black
On 10/3/06, Daniel McBrearty [EMAIL PROTECTED] wrote: if you have a (dbix) database, and use it as a model, you generallyend up doing this :$c-model- and the database connection is handled internally.I now want to write another model which uses the db. It would be better to use the existing

Re: [Catalyst] getting the db connection used by catalyst

2006-10-03 Thread Daniel McBrearty
basically it does some fancy processing on the db and caches the results. initially, that will be it. It will present a number of convenience methods, which can be used to access either the db or cached data. There will likely be some methods to write to the db, again convenience stuff. On