Re: [Catalyst] connecting to a remote sqlite

2007-10-14 Thread Matt S Trout
On Sat, Oct 13, 2007 at 12:07:54PM +, rahed wrote: > On 10/12/07, Matt S Trout <[EMAIL PROTECTED]> wrote: > > On Fri, Oct 12, 2007 at 11:50:01AM +0200, rahed wrote: > > > Without prefetch, there is no error. Is it possible (and which way) to > > > retrieve data from a remote db via proxy with C

Re: [Catalyst] connecting to a remote sqlite

2007-10-13 Thread rahed
On 10/12/07, Matt S Trout <[EMAIL PROTECTED]> wrote: > On Fri, Oct 12, 2007 at 11:50:01AM +0200, rahed wrote: > > Without prefetch, there is no error. Is it possible (and which way) to > > retrieve data from a remote db via proxy with Catalyst? > > Yes, use a database that's network capable like my

Re: [Catalyst] connecting to a remote sqlite

2007-10-12 Thread Matt S Trout
On Fri, Oct 12, 2007 at 11:50:01AM +0200, rahed wrote: > Without prefetch, there is no error. Is it possible (and which way) to > retrieve data from a remote db via proxy with Catalyst? Yes, use a database that's network capable like mysql or postgres. Trying to use DBD::Proxy for this is a -hein

[Catalyst] connecting to a remote sqlite

2007-10-12 Thread rahed
Hello, I connect to a local sqlite db. The data is being retrieved roughly like this: my $rs = $c->model('MyAppDB::Table1')->search( undef, { prefetch=>{ 'rel1'=>{'rel2'=>['table4','table5'] } },