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

Dear monks, I am new in Perl programming and Linux but not database. I have Internet Information Server, postgreSQL 8.0.3 and Perl ActiveStates 5.6.1 installed on Windows XP Pro. Can anybody guide me in setting up/installing Perl to work together with postgreSQL? I would apreciate your great help cause I am in great need of help for a school project. Regards, Zeratul
  • Comment on Need help in Perl and postgreSQL instalation on Win32 to work together

Replies are listed 'Best First'.
Re: Need help in Perl and postgreSQL instalation on Win32 to work together
by punkish (Priest) on Jun 13, 2005 at 22:25 UTC
    first, DBI, then, DBD::Pg.
    --

    when small people start casting long shadows, it is time to go to bed
      Hi,
      I downloaded those two packages:

      DBI-1.48.tar and
      DBD-Pg-1.42.tar.

      Could you tell me plase how to install them on Windows for perl 5.6.1.?

      Regards,
      Zeratul

        Try DBD-PgPP, it's a bit old though, so I don't know how well it will play with PG 8.0+

        install DBD-PgPP

        Walking the road to enlightenment... I found a penguin and a camel on the way.....
        Fancy a yourname@perl.me.uk? Just ask!!!
        You are going about it the wrong way, esp. on Windows. Some Perl modules are pure-perl, and like the perl scripts you might write, they are just plain text. Installing them is just a matter of copying them into the correct directories, easily achieved by

        perl Makefile.PL make sudo make install

        Other modules, however, have C/C++ code in them, and need to be compiled. Since most all Win boxes do not have a compiler, you need to download pre-compiled versions. Use ppm, your perl package manager (Win equivalent of cpan), install modules on Windows.

        Now, ActiveState's ppm point's to ActiveState's ppm repositories, which do not have all the modules compiled and ready. You might have to hunt down specific ones (Randy Kobes archive at theory.uwinnipeg.edu seems to have most). Then you have to point your ppm to that repository.

        Read the ppm help.

        --

        when small people start casting long shadows, it is time to go to bed
Re: Need help in Perl and postgreSQL instalation on Win32 to work together
by ghenry (Vicar) on Jun 13, 2005 at 22:24 UTC

    Run:

    ppm search DBI

    Look for one with pg in it for PostgreSQL, and then install it via:

    ppm install DBI-pg

    Or are you looking for programming help/documentation?

    HTH.

    Walking the road to enlightenment... I found a penguin and a camel on the way.....
    Fancy a yourname@perl.me.uk? Just ask!!!
      Hi,
      When I run: ppm search DBI I get

      --------- BEGIN ------------

      Packages available from http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/PPMServer:
      Apache-DBI 0.89 Initiate a persistent database connection
      Apache-DBILogin 2 authenticates and authorizes via a DBI connection
      ApacheDBI 0.88 Authentication and Authorization via Perl's DBI
      Class-DBI-ToSax 0.05 turn database objects to SAX events
      DBI 1.48 Database independent interface for Perl
      DBI-Wrap 1.00 An object oriented wrapper around DBI.
      DBIx-Abstract 1.003 DBI SQL abstraction
      DBIx-AbstractStatement 0.09 SQL command kept together with the bindings
      DBIx-AnyDBD 2.01 DBD independant class
      DBIx-BLOB-Handle 0.2 Read Database Large Object Binaries from file
      handles DBIx-BabelKit 1.07 Universal Multilingual Code Table Interface
      DBIx-Browse 2.09 Perl extension to browse tables.
      DBIx-CGI 0.06 Easy to Use DBI interface for CGI scripts
      DBIx-CGITables 0.001 Easy DB access from a CGI
      DBIx-Chart 0.01 DBI extension for Rendering Charts and Graphs
      DBIx-CodeKit 1.07 Universal Code Table Interface
      DBIx-Composer 1.00 Composes and runs SQL statements.
      DBIx-ContextualFetch 1.02 Add contextual fetches to DBI
      DBIx-Copy 0.02 For copying database content from one db to
      another
      DBIx-Cursor 0.14 Perl extension for easy DBI-access to a single
      table.
      DBIx-DBCluster 0.01 Distribute load among mirrored database servers
      DBIx-DBSchema 0.21 Database-independent schema objects
      DBIx-DWIW 0.32 Robust and simple DBI wrapper to Do What I Want
      (DWIW)
      DBIx-DataSource 0.02 Database-independant create and drop functions
      DBIx-Dump 0.04 Perl extension for dumping database (DBI) data
      into a variety of formats.
      DBIx-Ease 0.07 less-code DBI interactions for all drivers
      DBIx-Easy 0.15 Easy to Use DBI interface
      DBIx-FetchLoop 0.41 Fetch with change detection a
      nd aggregates DBIx-FileSystem 1.07 Manage tables like a filesystem
      DBIx-Formatter 0.01 Module to perform report generation via query
      DBI
      DBIx-HTML-ClientDB 1.03 Convert SQL into a JavaScript database
      DBIx-HTML-LinkedMenus 1.05 Convert SQL to 2 linked HTML popup menus
      DBIx-HTML-PopupRadio 1.08 Convert db data to HTML popup menu or radio
      group
      DBIx-HTMLTable 0.23 Make a HTML table from DBI query output.
      DBIx-HTMLinterface 0.11 Class for creating a CGI interface to a database
      DBIx-Hash2Table 1.03 Save a hash into a database table
      DBIx-MySQLSequence 0.1 Emulate sequences in MySQL.
      DBIx-OracleLogin 0.02 takes a string and splits out individual login
      information (user id, Oracle sid, and password)
      to be used in a DBI->connect() statement when
      connecting to an Oracle database.
      DBIx-Pager 0.02 SQL paging helper.
      DBIx-Password 1.8 Allows you to create a global password file for
      DB passwords
      DBIx-Portable 0.01 Framework for RDBMS-generic apps and schemas
      DBIx-Profile 1 DBI query profiler Version 1.0
      DBIx-Record 0.10 Middle tier system for representing database
      records as objects.
      DBIx-Renderer 0.01 talk SQL by using Perl data structures
      DBIx-SQLEngine 0.008 Extends DBI with high-level operations
      DBIx-Sequence 1.4 A simple SQL92 ID generator
      DBIx-ShowCaller 0.80 adds a Perl caller info to the SQL command
      DBIx-SpatialKey 0.031 Perl module for the management of spatial keys.
      DBIx-Table 0.04 Class used to represent DBI database tables.
      DBIx-Table-Dup 0.03 Perl module to (return SQL to) create duplicate
      copy of table
      DBIx-Table2Hash 1.12 Read a database table into a hash
      DBIx-TableHash 1.04 Tie a hash to a mysql table + SQL utils
      DBIx-TextIndex 0.11 Perl extension for full-text searching in SQL
      databases
      DBIx-Web 0.57 Active Web Database Layer
      DBIx-Wrapper 0.16 Wrapper Module for the DBI
      DBIx-XHTML_Table 1.14 SQL query result set to XHTML table.
      DBIx-XML-DataLoader 1.1b
      DBIx-XML_RDB 0.05 Perl extension for creating XML from existing
      DBI datasources
      DBIx-YAWM 2.2.5 (Yet Annother Wrapper Module) Provides a
      simplified interface to DBI
      DBIx-glueHTML 0.20 Class for creating a CGI interface to a database
      EZDBI 0.111 Easy interface to SQL databases
      Exception-Class-DBI 0.90 DBI Exception objects
      FindBin-Real 1.03 Locate directory of original perl script
      Persistent-DBI 0.50 dist
      Tk-DBI-DBGrid 0.01 grid for browse or edit table
      Tk-DBI-Table 0.02 Megawidget to display a sql-Statement in HList.
      XML-Generator-DBI 0.03 Generate SAX events from SQL queries

      ------ END -------------------
      -- I could not find anything with DBI-pg, and when I try to install: ppm install DBI-pg I get:
      package not found.

      Could you help me please in this issue?
      Regards.