Python, PostgreSQL, What next?

[jim-on-linux]

Before commiting to a RDBMS take a look at Gadfly. 

Depending on what you need a RDB for,
(light duty), or (heavy duty) take a look at 
gadfly.  Gadfly is made from all python code.

Use stardard SQL statements like Select, Create 
and Drop Tables, etc. 

Newest version GadflyB5 
http://gadfly.sourceforge.net/

jim-on-linux
http://www.inqvista.com




On Saturday 02 December 2006 11:33, Thomas Bartkus 
wrote:
> 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