python and Postgresq

Krishnakant hackingkk at gmail.com
Mon Nov 23 06:20:04 EST 2009


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.

Happy hacking.
Krishnakant.





More information about the Python-list mailing list