Perl to Postyrgess

Cheburashka has asked for the wisdom of the Perl Monks concerning the following question:

I need to connect to a postrgres database with perl.

a. Is the only way to do so using DBI? My system
administrator is on vocation so I don't think I can install
a driver for to weeks (don't have the superuser access), so
is there any other way?

b. Is it true that the latest verion of Perl has DBI
support built in? I have version 5.004_04.

c. If DBI is the only choice where can I get the latest
driver?

Thanx a lot,

Cheb

Comment on Perl to Postyrgess

Replies are listed 'Best First'.
Re: Perl to Postyrgess by httptech (Chaplain) on Jun 24, 2000 at 21:29 UTC
There are alternate PostgreSQL interface modules such as Pg, Postgres and PgSQL. They are all modules like DBI, so there's no advantage in terms of being able to install without being superuser. But you don't need to be superuser, just install the modules into your own account and use the 'use lib' directive to point perl to your additional libraries. I don't think DBI is built into any version of Perl, especially 5.004_04 which is fairly dated. You can get all the above modules and the DBI drivers from CPAN.	[reply]
Re: Perl to Postyrgess by mdillon (Priest) on Jun 24, 2000 at 21:29 UTC
no, DBI is not the only way. there is also a Perl interface to PostgreSQL that comes as part of the PostgreSQL distribution called Pg. if it was not installed by your administrator, you'll have a harder time installing it than DBI/DBD::Pg. try running `perl -MPg` to see if you have the Pg module installed. as for not being able to install DBI because you are not root, you should see How do I keep my own module/library directory?. no version of Perl has DBI built-in (except perhaps a specific port).	[reply]
Re: Perl to Postyrgess by JanneVee (Friar) on Jun 24, 2000 at 21:24 UTC
a. Nope. There is a native module. But I would recommend to use the DBI. You get a more general knowledge it becomes easier to convert to a different database b. This I don't know... Looking down on the floor in shame c. No it is not the only choice, but here you can find the info http://www.symbolstone.org/technology/perl/DBI/index.html Note: It is PostgreSQL* you can find it on http://www.postgresql.org/ ;)*	[reply]
Re: Perl to Postyrgess by davorg (Chancellor) on Jun 25, 2000 at 13:26 UTC
DBI isn't a standard part of Perl yet. To install it you'll to get DBI and also DBD::Postgres (both available on CPAN). You don't necessarily need your sysadmin in order to get this stuff installed. It is possible to install private copies of modules. See perlman:perlmodinstall for details. -- <http://www.dave.org.uk> European Perl Conference - Sept 22/24 2000 <http://www.yapc.org/Europe/>	[reply]
RE: Perl to Postyrgess by jjhorner (Hermit) on Jun 26, 2000 at 06:01 UTC
As for 'a', try this: `% perl Makefile.PL LIB=/home/joseph/perllib` [download] The above comes from Item 41* of Effective Perl Programming by our own merlyn and Joseph N. Hall.* J. J. Horner Linux, Perl, Apache, Stronghold, Unix jhorner@knoxlug.org http://www.knoxlug.org/	[reply] [d/l]

Back to Seekers of Perl Wisdom