Thread: Driver Frustration// Perl DBI
I'm working with Postgresql to implement a DB on the Web. After discovering that Dreamweaver UD 4 does not support Posgres, even thought I'm running Postgresql through an ODBC, I went on to Perl. The latest Perl DBI interface I can find on CPAN is dated 1998 and is for PostGre95. Is there an up to date Perl DBI for Postgresql? When can I find it? (it's NOT in CPAN!). Thanks, Cheryl
Cheryl, > I'm working with Postgresql to implement a DB on the Web. > After discovering that Dreamweaver UD 4 does not support Posgres, even > thought I'm running Postgresql through an ODBC, I went on to Perl. > > The latest Perl DBI interface I can find on CPAN is dated 1998 and is for > PostGre95. > > Is there an up to date Perl DBI for Postgresql? When can I find it? (it's > NOT in CPAN!). The reccommended module for Postgres is DBD::Pg, although the outdated DBI module will work for simple queries (as I have used it extensively for simple data transfers). I'm not sure what the status of the DBD::Pg driver is; here's the project: http://gborg.postgresql.org/project/dbdpg/projdisplay.php -- -Josh Berkus Aglio Database Solutions San Francisco
Hello, On Friday 17 January 2003 22:15, Cheryl Thompson wrote: > The latest Perl DBI interface I can find on CPAN is dated 1998 and is for > PostGre95. > > Is there an up to date Perl DBI for Postgresql? When can I find it? (it's > NOT in CPAN!). Try: http://www.cpan.org/modules/by-category/07_Database_Interfaces/Pg/ I only know this because its called DBI:Pg or something on the SuSE GUI installer :o) regards, Ben.
On Fri, 17 Jan 2003, Cheryl Thompson wrote: > I'm working with Postgresql to implement a DB on the Web. > After discovering that Dreamweaver UD 4 does not support Posgres, even > thought I'm running Postgresql through an ODBC, I went on to Perl. > > The latest Perl DBI interface I can find on CPAN is dated 1998 and is for > PostGre95. > > Is there an up to date Perl DBI for Postgresql? When can I find it? (it's > NOT in CPAN!). I'm running the "unstable" version of Debian Linux, and got the DBD::Pg as a package from Debian. It says that DBD::Pg is version 1.13, and can be gotten from dbi.symbolstone.org. For the DBI package, the version number is 1.30. The home seems to be dbi.perl.org. Those 2 versions, should be pretty close to the newest available. Gord -- Matter Realisations http://www.materialisations.com/ Gordon Haverland, B.Sc. M.Eng. President 101 9504 182 St. NW Edmonton, AB, CA T5T 3A7 780/481-8019 ghaverla @ freenet.edmonton.ab.ca 780/993-1274 (alt.)
> Is there an up to date Perl DBI for Postgresql? When can I find > it? (it's > NOT in CPAN!). On the contrary: DBI: http://search.cpan.org/author/TIMB/DBI-1.32/DBI.pm (01 Dec 2002) DBD::Pg: http://search.cpan.org/author/DWHEELER/DBD-Pg-1.21/dbd-pg.pod (13 Jan 2003) Doug Gorley | douggorley@shaw.ca
On Friday 17 January 2003 02:14 pm, Cheryl Thompson wrote:
> I'm working with Postgresql to implement a DB on the Web.
> After discovering that Dreamweaver UD 4 does not support Posgres, even
> thought I'm running Postgresql through an ODBC, I went on to Perl.
>
> The latest Perl DBI interface I can find on CPAN is dated 1998 and is for
> PostGre95.
>
> Is there an up to date Perl DBI for Postgresql? When can I find it? (it's
> NOT in CPAN!).
>
> Thanks,
> Cheryl
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Hi Cheryl -
You should use DBI + DBD-Pg-1.12 module like so:
use DBI;
$dbh = DBI->connect("dbi:Pg:dbname=$database",$user,$password);
-- Doug
On Fri, Jan 17, 2003 at 04:15:21PM -0600, Cheryl Thompson wrote: > The latest Perl DBI interface I can find on CPAN is dated 1998 and is for > PostGre95. > > Is there an up to date Perl DBI for Postgresql? When can I find it? (it's > NOT in CPAN!). Yes, it is: the DBD::Pg module is in version 1.21: perl -MCPAN -e shell install DBD::Pg should install the latest version for you (presuming you have DBI installed already). -- keith kkeller@speakeasy.net public key: http://wombat.san-francisco.ca.us/kkeller/kkeller.asc alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/cgi-bin/fom
Hi Where can I find the list of the functions of pg module, for example how to insert a row to the database? Does anybody know a tutorial on perl & Postgres? Thanks Rosta ************************************ Rosta Farzan Laboratory for Adaptive Hypermedia and Assistive Technologies Department of Math and Computer Science CSU Hayward rosta@acc.csuhayward.edu (510) 885-4026 *************************************
Have a read of the documentation for the DBI and DBD::Pg modules. perldoc DBI perldoc DBD::Pg Through then you can do your insert staments / any other sql statements that you like. simran. On Wed, 2003-01-29 at 10:55, Rosta Farzan wrote: > Hi > > Where can I find the list of the functions of pg module, for example how > to insert a row to the database? > Does anybody know a tutorial on perl & Postgres? > > Thanks > Rosta > > > ************************************ > Rosta Farzan > Laboratory for Adaptive Hypermedia and Assistive Technologies > Department of Math and Computer Science CSU Hayward > rosta@acc.csuhayward.edu > (510) 885-4026 > ************************************* > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
Le Wed, Jan 29, 2003 at 03:15:46PM +1100, simran a écrit ...
> Have a read of the documentation for the DBI and DBD::Pg modules.
>
> perldoc DBI
> perldoc DBD::Pg
desmond@lievre.voute.net % perldoc -f dbi
No documentation for perl function `dbi' found
:-(
D.
--
Desmond Coughlan |'Io non mori, e non rimasi vivo'
desmond@zeouane.org
http://www.zeouane.org
Attachment
On Thu, Jan 30, 2003 at 06:04:09AM +0000, Desmond Coughlan wrote: > Le Wed, Jan 29, 2003 at 03:15:46PM +1100, simran a ?crit ... > > > Have a read of the documentation for the DBI and DBD::Pg modules. > > > > perldoc DBI > > perldoc DBD::Pg > > desmond@lievre.voute.net % perldoc -f dbi > No documentation for perl function `dbi' found That's not what the previous poster said to do. % perldoc DBI % perldoc DBD::Pg If there's still no docs, the modules aren't installed. --keith -- kkeller@speakeasy.net public key: http://wombat.san-francisco.ca.us/kkeller/kkeller.asc alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/cgi-bin/fom
You can find the same document online http://search.cpan.org/ Look for DBD::Pg or DBI --Rosta > Le Wed, Jan 29, 2003 at 03:15:46PM +1100, simran a écrit ... > >> Have a read of the documentation for the DBI and DBD::Pg modules. >> >> perldoc DBI >> perldoc DBD::Pg > > desmond@lievre.voute.net % perldoc -f dbi > No documentation for perl function `dbi' found > > :-( > > D. > > -- > Desmond Coughlan |'Io non mori, e non rimasi vivo' > desmond@zeouane.org > http://www.zeouane.org ************************************ Rosta Farzan Laboratory for Adaptive Hypermedia and Assistive Technologies Department of Math and Computer Science CSU Hayward rosta@acc.csuhayward.edu (510) 885-4026 *************************************