[Catalyst] connecting to a remote sqlite

Matt S Trout dbix-class at trout.me.uk
Sun Oct 14 17:37:55 GMT 2007


On Sat, Oct 13, 2007 at 12:07:54PM +0000, rahed wrote:
> On 10/12/07, Matt S Trout <dbix-class at trout.me.uk> 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 mysql or postgres.
> >
> > Trying to use DBD::Proxy for this is a -heinous- hack and almost certainly
> > not going to work (::Proxy is kinda limited, it doesn't supply half the DBI
> > API ... really, don't try this. I've just about made it work, once, but it
> > was far far FAR too painful for words)
> 
> Thank you, now I know I needn't to try further.
> 
> This was only an attempt to contact my production sqlite from a
> development box. I disliked to copy the db from one box to another when
> wanted to retrieve actual data.

Use a read-only NFS mount or something then.

... dear god, I just recommended NFS as a less hacky solution to something.
Kill me now.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/



More information about the Catalyst mailing list