Thread: perl access

perl access

From
Tom Allison
Date:
I'm used to using the DBI modules in perl.
The online docs mention DBD as expiremental.

I'm thinking of sticking with DBI, unless there's some compelling reason
to do otherwise.


Re: perl access

From
"Joshua D. Drake"
Date:
Hello,

I do not believe that to be the case. DBD::SPI is experimental but DBD:
Pg is quite stable
and I believe DBD is a requirement that works WITH DBI.

Sincerely,

Joshua D. Drake


Tom Allison wrote:

> I'm used to using the DBI modules in perl.
> The online docs mention DBD as expiremental.
>
> I'm thinking of sticking with DBI, unless there's some compelling
> reason to do otherwise.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly



--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


Re: perl access

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I'm used to using the DBI modules in perl.
> The online docs mention DBD as expiremental.

Please let us know which docs you were looking at so we can remedy this.

> I'm thinking of sticking with DBI, unless there's some
> compelling reason to do otherwise.

Nope. The CVS version of DBD::Pg even has support for server-side
prepare statments and SQLSTATE codes: it's active and mature,
not experimental.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200406151905

-----BEGIN PGP SIGNATURE-----

iD8DBQFAz4DBvJuQZxSWSsgRAjj0AKCh3OVbrqgX2ZVxbEs79WJXzufuFgCgwmak
o7r4m4+qa1rGmeRgVQx7lFQ=
=7xIS
-----END PGP SIGNATURE-----



Re: perl access

From
Tom Allison
Date:
Greg Sabino Mullane wrote:
>
>
>>I'm used to using the DBI modules in perl.
>>The online docs mention DBD as expiremental.
>
>
> Please let us know which docs you were looking at so we can remedy this.
>

"experimental module DBD::PgSPI"

http://www.postgresql.org/docs/7.4/static/plperl-database.html


39.3. Database Access from PL/Perl

Access to the database itself from your Perl function can be done via an
experimental module DBD::PgSPI (also available at CPAN mirror sites).
This module makes available a DBI-compliant database-handle named
$pg_dbh that can be used to perform queries with normal DBI syntax.


Re: perl access

From
Doug McNaught
Date:
Tom Allison <tallison@tacocat.net> writes:

> Greg Sabino Mullane wrote:
>>
>>>I'm used to using the DBI modules in perl.
>>>The online docs mention DBD as expiremental.
>>  Please let us know which docs you were looking at so we can remedy
>> this.
>>
>
> "experimental module DBD::PgSPI"

That's for doing database queries inside Postgres stored procedures
that are written in Perl (in other words, Perl code that's running
inside the database server).  For regular client access (e.g. web
applications), the DBD::Pg module is well-tested and stable, as
Greg said.

-Doug