Re: contrib: hack for psycopg2 performance

Karsten Hilbert <[email protected]> Wed, 12 May 2010 14:52:27 +0200
Newsgroups gmane.comp.python.db.psycopg.devel
Message-ID <[email protected]>
On Wed, May 12, 2010 at 01:26:53PM +0100, Daniele Varrazzo wrote:

> > Because *Params offers a quantitative advantage (speed) and
> > a qualitative advantage (*ridding* oneself of SQL injection).
> 
> Do we have a measure of the speed advantage?

Not really (beyond the one the OP posted). Common
(PostgreSQL) wisdom holds that it is advantageous when
dealing with significant amounts of truly binary data (such
as bytea) - which I am (medical documents).

> About ridding of the SQL injection, I think psycopg is already doing
> its best by trusting the libpq. It there was a problem - a bug, a
> weakness - we obviously should look for a solution, but it doesn't
> seem we are in this situation.

Again, I was talking about a difference in quality of safety
(cannot happen) rather than quantity (is unlikely to
happen).

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346