[Python-Dev] BLOBs in Pg (original) (raw)
Sylvain Thénault sylvain.thenault at logilab.fr
Fri Apr 10 09:49:00 CEST 2009
- Previous message: [Python-Dev] BLOBs in Pg
- Next message: [Python-Dev] BLOBs in Pg (was: email package Bytes vs Unicode)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Python-Dev] BLOBs in Pg
- Next message: [Python-Dev] BLOBs in Pg (was: email package Bytes vs Unicode)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]