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