Message-ID: <478E3900.8080604@presicient.com>
Date: Wed, 16 Jan 2008 09:04:00 -0800
From: Dean Arnold <darnold@presicient.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
To: Greg Sabino Mullane <greg@turnstep.com>
CC: dbd-pg@perl.org, dbi-users@perl.org, pgsql-interfaces@postgresql.org
Subject: Re: DBD::Pg 2.0.0 release candidate available for testing
References: <7cb6a1dbe44fe3aabdaabee954b79bd1@biglumber.com>
In-Reply-To: <7cb6a1dbe44fe3aabdaabee954b79bd1@biglumber.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
> 
> 
> The first release candidate for the new version of DBD::Pg is 
> now available for testing. This is a very major change from the 
> current version (1.49), so if you are using DBD::Pg, it is highly 
> recommended you test it out early and thoroughly, so we can iron 
> out any problems before the final release.
> 
> Among the major changes are:
> 
> * Full support for arrays: Perl arrays are transformed to Postgres 
> arrays automatically, and vice-versa.

I presume this is "array type stored in a column", not "array for bulk loading" ?

Does Pg support native array binding of tuples yet ? The docs could be
a bit confusing. E.g., I'm not certain what "Supported by this driver as proposed by DBI."
means ? You may want to clarify that bit, and the difference
between "bind array to a column" vs. "binding an array of parameters")

Esp., does the COPY IN support native array binding (not the DBI default iterator) ?


> 
> * Asynchronous queries, which let's you start a query, go off and do 
> other things, and check back to see if it has finished, and fetch the 
> data when you are ready to. This also allows you to cancel running queries.
> 

Groovy! I'll have to give this a go w/ DBIx::Threaded's async
wrappers.

BTW: Do you have any examples that are "smarter" about
testing ready() ? I.e., grab the Pg socket, do a select() or poll(),
and only call ready() when there's activity on the socket ?
I've implemented a driver-specific function in DBD::Teradata to
do that internally (essentially, a select() for $dbh's + other filehandles).
Might be something to consider for Pg (I'd suggest support
at the DBI layer, except some drivers (e.g., ODBC) may not have access
to the underlying communication channel.

Great work!
Dean Arnold
Presicient Corp.