Postgres::Handler Builds upon DBD::Pg for advanced CGI web apps
Download

Postgres::Handler Ranking & Summary

Postgres::Handler Tags

Perl module cgi Postgres Postgres handler

Postgres::Handler Description

Builds upon DBD::Pg for advanced CGI web apps Postgres::Handler is a Perl module that builds upon the foundation set by DBI and DBD::Pg to create a superset of methods for tying together some of the basic interface concepts of DB management when used in a web server environment. Postgres::Handler is meant to build upon the strengths of DBD::Pg and DBI and add common usability features for a variety of Internet applications.Postgres::Handler encapsulates error message handling, information message handling, simple caching of requests through a complete iteration of a server CGI request. You will also find some key elements that hook the CGI class to the DBI class to simplify data IO to & from web forms and dynamic pages.SYNOPSIS # Instantiate Object # use Postgres::Handler; my $DB = Postgres::Handler->new(dbname=>'products',dbuser=>'postgres',dbpass=>'pgpassword'); # Retrieve Data & List Records # $DB->PrepLEX('SELECT * FROM products'); while ($item=$DB->GetRecord()) { print "$item->{PROD_ID} $item->{PROD_TITLE} $item->{PROD_QTY} "; } # Add / Update Record based on CGI Form # assuming objCGI is an instatiated CGI object # if the CGI param 'prod_id' is set we update # if it is not set we add # my %cgimap; foreach ('prod_id','prod_title','prod_qty') { $cgimap{$_} = $_; } $DB->AddUpdate( CGI=>$objCGI , CGIKEY=>'prod_id', TABLE=>'products', DBKEY=>'prod_id', hrCGIMAP=>\%cgimap ); Requirements: · Perl · CGI::Carp · CGI::Utils · Class::Struct · DBD::Pg · DBI What's New in This Release: · Fixed problem with SetDH database handle management.

Postgres::Handler Related Software