Python, PostgreSQL, What next?

[Thomas Bartkus]

On Fri, 01 Dec 2006 23:04:37 -0800, vbgunz wrote:

> Hello all,
> 
> I've studied Python and studied PostgreSQL. What is the absolute next
> best step to take to merge these two finely together? I've heard of
> SQLAlchemy and some others but before I dive in, I would really like
> the opinion of those who tried it and other toolkits.
> 
> My main concern is, I would like to completely work with a database
> from Python. What would you suggest I look into?

Let me venture that the biggest problem most people seem to have is that
they endure great pain just to avoid learning SQL. SQL is a complete
programming language in and of itself with a breadth and depth that most
people miss.  And it covers much terrain missed by Python. Which is a good
thing because SQL and Python are perfect together.  With this language mix
you've got darn near everything licked.

Get SQL in your head and all you will need would be the db-api interface
with Postgres that Frederick Lundh pointed you to.  All you want to do is
throw SQL commands at Postgres and recover result sets into Python.

It's a cinch.
Thomas Bartkus