Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old November 23rd, 2005, 01:09 AM
Tom Allison
Guest
 
Posts: n/a
Default perl access

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

  #2  
Old November 23rd, 2005, 01:09 AM
Joshua D. Drake
Guest
 
Posts: n/a
Default Re: perl access

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:
[color=blue]
> 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[/color]



--
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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

  #3  
Old November 23rd, 2005, 01:09 AM
Joshua D. Drake
Guest
 
Posts: n/a
Default Re: perl access

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:
[color=blue]
> 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[/color]



--
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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

  #4  
Old November 23rd, 2005, 01:10 AM
Greg Sabino Mullane
Guest
 
Posts: n/a
Default Re: perl access


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

[color=blue]
> I'm used to using the DBI modules in perl.
> The online docs mention DBD as expiremental.[/color]

Please let us know which docs you were looking at so we can remedy this.
[color=blue]
> I'm thinking of sticking with DBI, unless there's some
> compelling reason to do otherwise.[/color]

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-----

iD8DBQFAz4DBvJuQZxSWSsgRAjj0AKCh3OVbrqgX2ZVxbEs79W JXzufuFgCgwmak
o7r4m4+qa1rGmeRgVQx7lFQ=
=7xIS
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

  #5  
Old November 23rd, 2005, 01:10 AM
Greg Sabino Mullane
Guest
 
Posts: n/a
Default Re: perl access


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

[color=blue]
> I'm used to using the DBI modules in perl.
> The online docs mention DBD as expiremental.[/color]

Please let us know which docs you were looking at so we can remedy this.
[color=blue]
> I'm thinking of sticking with DBI, unless there's some
> compelling reason to do otherwise.[/color]

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-----

iD8DBQFAz4DBvJuQZxSWSsgRAjj0AKCh3OVbrqgX2ZVxbEs79W JXzufuFgCgwmak
o7r4m4+qa1rGmeRgVQx7lFQ=
=7xIS
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

  #6  
Old November 23rd, 2005, 01:10 AM
Tom Allison
Guest
 
Posts: n/a
Default Re: perl access

Greg Sabino Mullane wrote:[color=blue]
>
>[color=green]
>>I'm used to using the DBI modules in perl.
>>The online docs mention DBD as expiremental.[/color]
>
>
> Please let us know which docs you were looking at so we can remedy this.
>[/color]

"experimental module DBD::PgSPI"

http://www.postgresql.org/docs/7.4/s...-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.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

  #7  
Old November 23rd, 2005, 01:10 AM
Tom Allison
Guest
 
Posts: n/a
Default Re: perl access

Greg Sabino Mullane wrote:[color=blue]
>
>[color=green]
>>I'm used to using the DBI modules in perl.
>>The online docs mention DBD as expiremental.[/color]
>
>
> Please let us know which docs you were looking at so we can remedy this.
>[/color]

"experimental module DBD::PgSPI"

http://www.postgresql.org/docs/7.4/s...-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.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

  #8  
Old November 23rd, 2005, 01:10 AM
Doug McNaught
Guest
 
Posts: n/a
Default Re: perl access

Tom Allison <tallison@tacocat.net> writes:
[color=blue]
> Greg Sabino Mullane wrote:[color=green]
>>[color=darkred]
>>>I'm used to using the DBI modules in perl.
>>>The online docs mention DBD as expiremental.[/color]
>> Please let us know which docs you were looking at so we can remedy
>> this.
>>[/color]
>
> "experimental module DBD::PgSPI"[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

  #9  
Old November 23rd, 2005, 01:10 AM
Doug McNaught
Guest
 
Posts: n/a
Default Re: perl access

Tom Allison <tallison@tacocat.net> writes:
[color=blue]
> Greg Sabino Mullane wrote:[color=green]
>>[color=darkred]
>>>I'm used to using the DBI modules in perl.
>>>The online docs mention DBD as expiremental.[/color]
>> Please let us know which docs you were looking at so we can remedy
>> this.
>>[/color]
>
> "experimental module DBD::PgSPI"[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles