Re: [CDBI] Class::DBI::Loader question

[prev] [thread] [next] [Date index for 2004/10/12]

From: Perrin Harkins
Subject: Re: [CDBI] Class::DBI::Loader question
Date: 04:12 on 12 Oct 2004
Kingsley Kerce wrote:
>  > Would it be kind of nice it it dumped "Class::DBI" code (ie the table and
>  > column declarations to a file for each table?  I think that may be handy for me
>  > but am not sure yet. Anyone written code to make it do that?
> 
> I've also wanted this, but such a dump would probably best be taken at
> least one step farther, to a lower level, such that the dump contains
> the results of all your table(), columns(), has_many(), has_a(),
> might_have(), etc., calls.

You would be better off doing this with SQL::Translator.  It can 
generate Class::DBI code for you as well.

> Some will argue "just use mod_perl and set things up once", but
> mod_perl isn't a viable option for everyone.

With cheap virtual servers, it should be, but that's beside the point.

> Has anyone opinions on whether the startup time for loading such a
> CDBI dump would be significantly faster than the equivalent
> CDBI::Loader calls?

It would definitely be faster to load the generated code because it 
would skip multiple database queries.  Using CDBI::Loader outside of a 
persistent environment sounds like a bad idea to me.

- Perrin

(message missing)

domain cross talk...?
Michael Jensen 06:47 on 06 Oct 2004

Re: domain cross talk...?
William McKee 14:41 on 06 Oct 2004

Re: domain cross talk...?
Perrin Harkins 14:47 on 06 Oct 2004

Re: domain cross talk...?
William McKee 14:51 on 06 Oct 2004

Re: domain cross talk...?
Perrin Harkins 15:06 on 06 Oct 2004

Re: domain cross talk...?
William McKee 15:32 on 06 Oct 2004

Re: domain cross talk...?
Perrin Harkins 15:36 on 06 Oct 2004

Re: domain cross talk...?
Michael Jensen 16:03 on 06 Oct 2004

Re: domain cross talk...?
Michael Jensen 16:16 on 06 Oct 2004

Re: domain cross talk...?
Perrin Harkins 16:27 on 06 Oct 2004

Re: domain cross talk...?
Carl Johnstone 23:17 on 06 Oct 2004

Re: domain cross talk...?
William McKee 15:53 on 06 Oct 2004

Re: domain cross talk...?
merlyn (Randal L. Schwartz) 16:17 on 06 Oct 2004

Re: domain cross talk...?
Perrin Harkins 16:31 on 06 Oct 2004

[CDBI] Class::DBI::Loader question
Peter Speltz 00:31 on 12 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Kingsley Kerce 02:57 on 12 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Perrin Harkins 04:12 on 12 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Kingsley Kerce 18:43 on 12 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Clayton L. Scott 17:08 on 12 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Peter Speltz 17:32 on 12 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Perrin Harkins 18:58 on 12 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Kingsley Kerce 14:26 on 14 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Perrin Harkins 15:17 on 14 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Tony Bowden 15:39 on 14 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Kingsley Kerce 14:26 on 14 Oct 2004

Re: [CDBI] Class::DBI::Loader question
Tim Bunce 16:22 on 14 Oct 2004

Re: [CDBI] Class::DBI::Loader question
merlyn (Randal L. Schwartz) 17:24 on 14 Oct 2004

Generated at 11:34 on 01 Dec 2004 by mariachi v0.52