Python + PostgreSQL

2009-03-17 Thread Lobo
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?.

Your help is greatly appreciated - thanks !

Carlos
--
http://mail.python.org/mailman/listinfo/python-list


Re: Python + PostgreSQL

2009-03-17 Thread 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  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


Smalltalk-like Python IDE ?

2009-03-18 Thread Lobo
Hi,

My experience has been with Smalltalk using Object databases.

I would very much appreciate your recommendations on a Python IDE
closest to the Smalltalk 'image' environment, with class browsers,
implementors/senders, inspectors, debuggers, etc.

I am planning to use the following technologies for my new project
(based on input from others users here):

+ Python 2.6
+ PostgreSQL 8.3 (+ pgAdmin III 1.10)
+ SQLAlchemy 0.5.2 (+ psycopg2)
+ Elixir 0.6.1

Does the above look right?, or are there any incompatibilities among
versions?, or would you recommend to add/remove/change things (except
Python+PostreSQL, which is a must in my project)?.

Btw I will be developing on Windows XP and Vista, and I hope there are
Windows installers for all of the above - sorry but I'm not used to
compile packages and such.

If you can also let me know some hints to ease my transition from
Smalltalk to Python, that would be great.

Thanks a lot,

   Carlos
--
http://mail.python.org/mailman/listinfo/python-list