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...@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 -- http://mail.python.org/mailman/listinfo/python-list
