Re: Python, PostgreSQL, What next?

2006-12-02 Thread 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
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python, PostgreSQL, What next?

2006-12-02 Thread patkinson
Hi,
Look at DJANGO;-)
http://www.djangoproject.com/
http://www.djangobook.com/

Regards
Peter Atkinson



vbgunz ha escrito:

 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!

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


Re: Python, PostgreSQL, What next?

2006-12-02 Thread Fredrik Lundh
vbgunz wrote:

 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

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


Re: Python, PostgreSQL, What next?

2006-12-02 Thread 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



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


Re: Python, PostgreSQL, What next?

2006-12-02 Thread 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
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python, PostgreSQL, What next?

2006-12-02 Thread 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!

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


Python, PostgreSQL, What next?

2006-12-01 Thread 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!

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


Re: Python, PostgreSQL, What next?

2006-12-01 Thread Godson

On 1 Dec 2006 23:04:37 -0800, vbgunz [EMAIL PROTECTED] 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?

Thank you for your time!

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



I am using psycopg 1.1.21 for interacting with postgresql, which proved to
be good for my need i guess django and  zope  also using psycopg for doing
things with postgresql, to get started with that, The following links could
be useful

http://initd.org/pub/software/psycopg/dbapi20programming.pdf


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

Godson Gera
http://godson.auroinfo.com
-- 
http://mail.python.org/mailman/listinfo/python-list