Re: [RFC] ideas for a new Python DBAPI driver (was Re: libpq test suite)

On Thursday 14 February 2013, Manlio Perillo wrote:
> Il 14/02/2013 14:06, Albe Laurenz ha scritto:
> > Manlio Perillo wrote:
> >> Sorry for the question, but where can I find the libpq test suite?
> >> I can not find it in the PostgreSQL sources; it seems that there are
> >> only some examples, in src/test/examples.
> >
> For my Python DBAPI2 PostgreSQL driver I plan the following optimizations:
>
> 1) always use PQsendQueryParams functions.
>
> This will avoid having to escape parameters, as it is done in
> psycopg2
> (IMHO it still use simple query protocol for compatibility purpose)
>
> 2) when the driver detects a Python string is being sent to the
> database, use binary format.
>
> As a special case, this will avoid having to use PQescapeByteaConn
> when sending binary string (e.g. byte strings in Python 3.x)
> ....

Perhaps you could also see some attempt I'd made to support binary protocol
inside psycopg2, some time ago:

https://github.com/xrg/psycopg/tree/execparams2

--
Say NO to spam and viruses. Stop using Microsoft Windows!