#1
  1. Normal Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Malaysia
    Posts
    14
    Rep Power
    0

    Question how to connect postgre database by using perl?


    anyone know how to use perl/cgi to connect to postgre database and i'm new user of postgre how do i going to start using postgre plz give me some advice.
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    Look for info on Perl DBI, which is the standard object-oriented database module for Perl (can be found at cpan.org). Most modern Unix/Linux servers have DBI installed by default, though. (try typing 'perldoc DBI')

    Then, all you need is the specific database package for PostgreSQL, which you can find among all the others at http://www.perl.com/CPAN-local/modules/by-module/DBD/. The current latest version is http://www.perl.com/CPAN-local/modul...Pg-1.22.tar.gz
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  4. #3
  5. Normal Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Malaysia
    Posts
    14
    Rep Power
    0
    do u means PostgreSQL is under DBI?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    373
    Rep Power
    12
    Originally posted by sorcecold
    do u means PostgreSQL is under DBI?
    a piece of the DBI module includes the functions to access postgreSQL from a perl program. PostgreSQL itseslf has to be running on the computer; it's just a library

    rycamor says (try typing 'perldoc DBI') you should be ok; are you using *nix or windows?
  8. #5
  9. Normal Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Malaysia
    Posts
    14
    Rep Power
    0
    i'm using unix

IMN logo majestic logo threadwatch logo seochat tools logo