python and Postgresq

Diez B. Roggisch deets at nospam.web.de
Mon Nov 23 06:37:36 EST 2009


Krishnakant wrote:

> On Mon, 2009-11-23 at 11:22 +0100, Diez B. Roggisch wrote:
>> Andy dixon wrote:
>> 
>> > Hi,
>> > 
>> > Does anyone have a link to, or can provide an example script for using
>> > python-pgsql (http://pypi.python.org/pypi/python-pgsql/) or if someone
>> > can recommend an alternative, that would be fantastic.
>> 
>> I'd recommend psycopg2.
>> 
>> This is an introduction:
>> 
>>  http://www.devx.com/opensource/Article/29071
>> 
>> But google yields tons more. And make sure you read the python db api 2.0
>> spec, this should give you the general idea on how to work with Python &
>> RDBMS, which is nicely abstracted away from the actual database.
> 
> Python-pgsql is a much better choice when it comes to big applications,
> specially if you are going to deal with xml-rpc.  I have found that
> python-pgsql handles integers and other such postgresql datatypes
> better.

Where is the connection between XMLRPC and psql? And can you elaborate on
what and how pgsql handles things better than psycopg2? 

Diez



More information about the Python-list mailing list