Skip site navigation (1) Skip section navigation (2)

Re: Stuff for 2.4.1

From: David Blewett <david(at)dawninglight(dot)net>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
Cc: harald(at)2ndquadrant(dot)com, psycopg(at)postgresql(dot)org
Subject: Re: Stuff for 2.4.1
Date: 2011-03-27 17:23:56
Message-ID: AANLkTimdk7En6xx2h7fYH5y+S0sotjVv=vyw2TAPD=5b@mail.gmail.com (view raw or flat)
Thread:
Lists: psycopg
On Sun, Mar 27, 2011 at 9:46 AM, Daniele Varrazzo
<daniele(dot)varrazzo(at)gmail(dot)com> wrote:
> On Sun, Mar 27, 2011 at 12:51 PM, Harald Armin Massa
> <harald(at)2ndquadrant(dot)com> wrote:
>> Are you really sure that psycopg2 should go the road of having own
>> parsers in addition to libpq-s routines? As much as I am happy about
>> the robustness when having other libpqs, and about the performance
>> benefit, as much I fear to have some new areas for possible bugs -
>> especially security-relevant things like SQL-injections.
>
> The will to stick as much as possible to the libpq functions has been
> the reason I had not written the above parser before (releasing
> 2.4.0). Unfortunately the bytea problem has proven trickier to handle
> for many psycopg users. I've changed my mind as I think psycopg has
> the responsibility to provide a set of feature in a robust way, and if
> the libpq is just not reliable for bytea parsing (for me the hex
> format should have been backported to the the client libraries of the
> previous versions) I think we have to provide a solution, not just to
> propagate the problem.

I think I agree with Harald here. In my opinion, this shouldn't be
done at the driver level. There never has been a guarantee from the
database side that applications compiled against older libpq will be
able to communicate with newer versions. Emulating this in the driver
only propagates this mis-conception. What has been the problem in the
past? Maybe the documentation should be improved so that people are
sure to build against the appropriate version of libpq for the version
of the server they intend to communicate with?

-- 
Thanks,

David Blewett

In response to

Responses

psycopg by date

Next:From: Karsten HilbertDate: 2011-03-27 17:40:46
Subject: Re: Stuff for 2.4.1
Previous:From: Daniele VarrazzoDate: 2011-03-27 13:46:39
Subject: Re: Stuff for 2.4.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group