On Mar 17, 2009, at 10:57 PM, Lobo wrote:
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?.
You can, but as you observed you'll be running a patched version of
psycopg2. If this is the only extension module library you think
you'll need in your project, then running Python 3.x is fine.
Otherwise you might run into surprises when you find that there's a
lot fewer extensions available for 3.x than for 2.x. That's changing,
but it seems to be the state of the Python world today.
Case in point -- you said your project is a Web project, yes? Then
whatever Web framework you use will need to have been ported to 3.x.
At this point, I don't know if any of the major ones have been.
I know that as a new user you'd like to start using the latest &
greatest version of Python so that you don't put your project in a
position where you know you'll have to upgrade at some point in the
future, but that's probably your best course of action at the moment.
Good luck
Philip
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
--
http://mail.python.org/mailman/listinfo/python-list
