Python + PostgreSQL

[Lobo]

Many thanks to all for your valuable input.

I've done some research and I believe I will use (at least for now, to
make it simple) psycopg2 module to connect Python to PostgreSQL.

I am wondering whether I can jump directly to Python 3.x (instead of
using Python 2.6), depending of course on psycopg2 compatibility?.

I saw in a different post that psycopg2 does work on Python 3.x as
long as a patch is applied (by Martin v. Löwis):

http://groups.google.com/group/comp.lang.python/tree/browse_frm/thread/56b7fca444a5aa5d/4064a307dca37686?rnum=1&q=python3+postgresql&_done=%2Fgroup%2Fcomp.lang.python%2Fbrowse_frm%2Fthread%2F56b7fca444a5aa5d%2Fc4f74719f6694dce%3Flnk%3Dgst%26q%3Dpython3%2Bpostgresql%26#doc_29389da8b2b83188

Do you know where can I find this patch, and if it does fully solve
any incompatibility issues to be able to use Python 3.x without
problems?.

Or should I just use Python 2.6?.

What would you recommend?.

Many thanks again,

   Carlos

On Mar 17, 12:20 pm, Philip Semanchuk <phi... at semanchuk.com> wrote:
> On Mar 17, 2009, at 12:46 PM, Lobo wrote:
>
> > Hi,
>
> > I am new to this newsgroup (and new to Python and PostgreSQL). My
> > experience (17+ years) has been with Smalltalk (e.g. VAST) and Object
> > databases (e.g. Versant, OmniBase).
>
> > I now have a new project to develop web applications using the latest/
> > best possible versions of Python (3.x?) with PostgreSQL (8.x?, with
> > pgAdmin 1.10?).
>
> > I hope to get some hints as of what frameworks/modules to use for this
> > specific combination (Python + PostgreSQL)?, should I use django,
> > zope, web2py, psycopg module, others?, what are their pros/cons?.
>
> Hi Carlos,
> You'll find a lot of libraries and projects aren't supporting Python  
> 3.x yet. Consider (as others have suggested) working in Python 2.6 to  
> ease the transition to 3.x when you & your libs are ready.
>
> I've used Psycopg2 to talk to Postgres from Python and had great  
> success with it.
>
> As far as Django versus Zope versus web2py versus Pylons versus  
> TurboGears versus...  Well, there's enough flamewar material in there  
> to power New York for centuries. They've all got their strengths and  
> weaknesses. I know which I prefer but my needs and preferences are my  
> own and only you know yours.
>
> One thing I will note is that Zope's database is an object hierarchy  
> which sounds like a familiar tool for you, so that might ease your  
> transition into the Python world.
>
> Good luck
> Philip