Hi, all:
I found Apache::DB module from CPAN:
http://search.cpan.org/author/DOUGM/Apache-DB-0.06/
But how to install it?
thanks,
Regards,
Xu Qiang
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
On Wed, 13 Aug 2003, Xu, Qiang (XSSC SGP) wrote:
> Hi, all:
>
> I found Apache::DB module from CPAN:
> http://search.cpan.org/author/DOUGM/Apache-DB-0.06/
>
> But how to install it?
That's a module to aid in debugging - is that what you
were looking for? You have to compile it, which on
Win32 requires some non-trivial modifications - we
have a ppm package of it at
http://theoryx5.uwinnipeg.ca/ppmpackages/
for ActivePerl 6xx.
If instead you were looking for Apache-DBI, for database
connections, this is under $CPAN/authors/id/A/AB/ABH/;
this doesn't require a C compiler. We have a ppm package
of it at the above location, for 6xx builds, and at
http://theoryx5.uwinnipeg.ca/ppms/
for 8xx builds.
--
best regards,
randy kobes
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
Randy Kobes wrote:
> That's a module to aid in debugging - is that what you
> were looking for? You have to compile it, which on
> Win32 requires some non-trivial modifications - we
> have a ppm package of it at
> http://theoryx5.uwinnipeg.ca/ppmpackages/
> for ActivePerl 6xx.
Yes, this is what I want. I have downloaded the "Apache-DB.ppd",
"Apache-DB.tar.gz" files from that repository, and install them manually.
Thanks!
> If instead you were looking for Apache-DBI, for database
> connections, this is under $CPAN/authors/id/A/AB/ABH/;
> this doesn't require a C compiler. We have a ppm package
> of it at the above location, for 6xx builds, and at
> http://theoryx5.uwinnipeg.ca/ppms/
> for 8xx builds.
I have had installed DBI and DBD-Mysql package for 6xx builds before. Those
are for database support. But today I also found the Apache-DBI package
here. You said this is also for dababase connections? Any difference between
Apache-DBI and DBI?
thanks,
Regards,
Xu Qiang
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
Randy Kobes wrote:
> That's a module to aid in debugging - is that what you
> were looking for? You have to compile it, which on
> Win32 requires some non-trivial modifications - we
> have a ppm package of it at
> http://theoryx5.uwinnipeg.ca/ppmpackages/
> for ActivePerl 6xx.
Yes, this is what I want. I have downloaded the "Apache-DB.ppd",
"Apache-DB.tar.gz" files from that repository, and install them manually.
Thanks!
> If instead you were looking for Apache-DBI, for database
> connections, this is under $CPAN/authors/id/A/AB/ABH/;
> this doesn't require a C compiler. We have a ppm package
> of it at the above location, for 6xx builds, and at
> http://theoryx5.uwinnipeg.ca/ppms/
> for 8xx builds.
I have had installed DBI and DBD-Mysql package for 6xx builds before. Those
are for database support. But today I also found the Apache-DBI package
here. You said this is also for dababase connections? Any difference between
Apache-DBI and DBI?
thanks,
Regards,
Xu Qiang
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
On Thu, 14 Aug 2003, Xu, Qiang (XSSC SGP) wrote:
> Randy Kobes wrote:
> > That's a module to aid in debugging - is that what you
> > were looking for? You have to compile it, which on
> > Win32 requires some non-trivial modifications - we
> > have a ppm package of it at
> > http://theoryx5.uwinnipeg.ca/ppmpackages/
> > for ActivePerl 6xx.
>
> Yes, this is what I want. I have downloaded the "Apache-DB.ppd",
> "Apache-DB.tar.gz" files from that repository, and install them manually.
>
> Thanks!
Great ... I was confused about sending this to the
@lists.mysql.com addresses ...
> > If instead you were looking for Apache-DBI, for database
> > connections, this is under $CPAN/authors/id/A/AB/ABH/;
> > this doesn't require a C compiler. We have a ppm package
> > of it at the above location, for 6xx builds, and at
> > http://theoryx5.uwinnipeg.ca/ppms/
> > for 8xx builds.
>
> I have had installed DBI and DBD-Mysql package for 6xx
> builds before. Those are for database support. But today I
> also found the Apache-DBI package here. You said this is
> also for dababase connections? Any difference between
> Apache-DBI and DBI?
Apache-DBI (which requires DBI) is a module to allow
persistent database connections when run under mod_perl, so
that each invocation of a script or handler doesn't have to
establish a new connection. This is useful if you're using
the same connections over and over again (with the same
table/username/password).
--
best regards,
randy
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
Xu, Qiang (XSSC SGP) wrote:
>
> Any difference between
>Apache-DBI and DBI?
>
>
>
quite a bit, and none at all.
key to Apache-DBI is that when used in mod-perl, it works like a cache of
open DBI handles; when your cgi script runs and calls DBI->connect(@args),
it is given a reference to a previously opened and cached handle, or if
the connect @args
are different, opens a new one for you, and saves it to cache, assuming
youll be back
to use it again.
I believe your code can remain unchanged; you call DBI->connect,
not Apache::DBI->connect. But you do have to load Apache::DBI at
server startup (either directly or indirectly from a
your httpd.conf
I dunno whether it eventually closes LRU handles, or whether/how-many
additional
handles it will open if the currently available matches are busy, but im
sure some hints
are in the docs.
and caveats apply - im writing from memory /understanding, not from perldoc
>thanks,
>
>Regards,
>Xu Qiang
>
>
>
>
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
In Apache 1.x Each http process will maintain it's own connections and close
it when it goes out of scope (i.e. after Max-Requests).
I don't know how it works in Apache 2 as I'm not there yet, but I assume
each thread maintains the connection just like the processes in Apache 1
--
Mikael Östensson
VP, Communications & Technology
Images.com, Inc.
---------- Original Message -----------
From: Jim Cromie
To: "Xu, Qiang (XSSC SGP)"
Sent: Wed, 13 Aug 2003 22:26:48 -0600
Subject: Re: Apache::DB install?
> Xu, Qiang (XSSC SGP) wrote:
>
> >
> > Any difference between
> >Apache-DBI and DBI?
> >
> >
> >
> quite a bit, and none at all.
>
> key to Apache-DBI is that when used in mod-perl, it works like a
> cache of open DBI handles; when your cgi script runs and calls DBI-
> >connect(@args), it is given a reference to a previously opened and
> cached handle, or if the connect @args are different, opens a new
> one for you, and saves it to cache, assuming youll be back to use it
> again.
>
> I believe your code can remain unchanged; you call DBI->connect,
> not Apache::DBI->connect. But you do have to load Apache::DBI at
> server startup (either directly or indirectly from a
> in your httpd.conf
>
> I dunno whether it eventually closes LRU handles, or whether/how-
> many additional handles it will open if the currently available
> matches are busy, but im sure some hints are in the docs.
>
> and caveats apply - im writing from memory /understanding, not from perldoc
>
> >thanks,
> >
> >Regards,
> >Xu Qiang
> >
> >
> >
> >
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=mikaelo@sisstock.com
------- End of Original Message -------
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org