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

From: "P(dot) Christeas" <xrg(at)linux(dot)gr>
To: Manlio Perillo <manlio(dot)perillo(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [RFC] ideas for a new Python DBAPI driver (was Re: libpq test suite)
Date: 2013-02-17 22:55:34
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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:

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2013-02-17 23:49:17 Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Previous Message Dimitri Fontaine 2013-02-17 21:12:57 Re: sql_drop Event Trigger