[Python-Dev] BLOBs in Pg
sylvain.thenault at logilab.fr
Fri Apr 10 09:49:00 CEST 2009
On 09 avril 14:05, Steve Holden wrote:
> Oleg Broytmann wrote:
> > On Thu, Apr 09, 2009 at 01:14:21PM -0400, Tony Nelson wrote:
> >> I use MySQL, but sort of intend to learn PostgreSQL. I didn't know that
> >> PostgreSQL has no real support for BLOBs.
> > I think it has - BYTEA data type.
> But the Python DB adapters appears to require some fairly hairy escaping
> of the data to make it usable with the cursor execute() method. IMHO you
> shouldn't have to escape data that is passed for insertion via a
> parameterized query.
can't you simply use dbmodule.Binary to do the job?
Sylvain Thénault LOGILAB, Paris (France)
Formations Python, Debian, Méth. Agiles: http://www.logilab.fr/formations
Développement logiciel sur mesure: http://www.logilab.fr/services
CubicWeb, the semantic web framework: http://www.cubicweb.org
More information about the Python-Dev