From: Dean Arnold <darnold@presicient.com>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: dbd-pg@perl.org
Cc: dbi-users@perl.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: DBD::Pg 2.0.0 release candidate available for testing
Date: Wed, 16 Jan 2008 09:04:00 -0800
Message-ID: <478E3900.8080604@presicient.com> (raw)
In-Reply-To: <7cb6a1dbe44fe3aabdaabee954b79bd1@biglumber.com>
References: <7cb6a1dbe44fe3aabdaabee954b79bd1@biglumber.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: darnold@presicient.com, greg@turnstep.com, dbd-pg@perl.org, dbi-users@perl.org
Subject: Re: DBD::Pg 2.0.0 release candidate available for testing
In-Reply-To: <478E3900.8080604@presicient.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox