Python, PostgreSQL, What next?

[vbgunz]

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?

Thank you for your time!

 

[Armin]

I've studied Python and studied PostgreSQL. Good.

What is the absolute next best step to take to merge these two finely
together? I've heard of

Just download psycopg2. Python and PostgreSQL are a match made in heavan.

Make your connection,
do querys,
get data,
earn profits.

Object-Relational-Mappers are to direct SQL as phone sex is to the real
thing.

Harald

 

[patkinson]

Hi,
Look at DJANGO ;-)
http://www.djangoproject.com/
http://www.djangobook.com/

Regards
Peter Atkinson



vbgunz ha escrito:

 

[Fredrik Lundh]

I've studied Python and studied PostgreSQL. What is the absolute next
best step to take to merge these two finely together?

the db-api interface:

http://www.python.org/dev/peps/pep-0249/

db-api compliant postgresql adapters:

http://www.pygresql.org/
http://www.initd.org/

higher-level interfaces for postgresql and other db-api compliant drivers:

http://www.sqlobject.org/
http://www.sqlalchemy.org/
http://www.djangoproject.com/documentation/db_api/
etc.

</F>

 

[Thomas Bartkus]

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

 

[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

 

[vbgunz]

I need to thank you all for your suggestions and recommendations. I am
ultimately aiming to work in Python, PostgreSQL and Django and this
link http://www.sqlalchemy.org/news.myt#item_3 sort of made my day

I really appreciate all of your feedback and will go through Fredrik's
links as soon as I get the chance. I thank you all again, I appreciate
it very much!