Which PostgreSQL adapter to use?

[Hussein B]

Hey,
Which Adapter to use with PostgreSQL:
PyPgSQL, psycopg or PyGreSQL?
Thanks.

[Thomas Guettler]

Hussein B schrieb:

Hey,
Which Adapter to use with PostgreSQL:
PyPgSQL, psycopg or PyGreSQL?
Thanks.

I think psycopg2 is a good choice. Never tried anything else.

Thomas

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de

[D'Arcy J.M. Cain]

On Tue, 04 Nov 2008 17:13:43 +0100
Thomas Guettler <[e-mail]:

Hussein B schrieb:

Hey,
Which Adapter to use with PostgreSQL:
PyPgSQL, psycopg or PyGreSQL?
Thanks.

I think psycopg2 is a good choice. Never tried anything else.

PyGreSQL 4.0 is currently in beta and should be released shortly. Here
is the changelog so far.

- Dropped support for Python below 2.3 and PostgreSQL below 7.2
- Added new method to get parameter settings.
- Added row_factory as suggested by Simon Pamies.
- Separated between mandatory and additional type objects.
- Added keyword args to insert, update and delete methods.
- Added exception handling for direct copy.
- Release the GIL while making a connection
(as suggested by Peter Schuller).
- If available, use decimal.Decimal for numeric types.
- Allow DB wrapper to be used with DB-API 2 connections
(as suggested by Chris Hilton).
- Made private attributes of DB wrapper accessible.

http://www.PyGreSQL.org/

--
D'Arcy J.M. Cain <da***@druid.net | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
[phone] (DoD#0082) (eNTP) | what's for dinner.

[Ben Finney]

Hussein B <hu********@gmail.comwrites:

Which Adapter to use with PostgreSQL:
PyPgSQL, psycopg or PyGreSQL?

I have found the best overall interface for working with an RDBMS in
Python is SQLAlchemy <URL:http://www.sqlalchemy.org/>.

To use SQLAlchemy with PostgreSQL requires psycopg2. So that's what I
use. I've never had to interface directly with it; I use SQLAlchemy
which is both more abstract *and* more expressive.

--
\ “We demand rigidly defined areas of doubt and uncertainty!� |
`\ —Vroomfondel, _The Hitch-Hiker's Guide To The Galaxy_, Douglas |
_o__) Adams |
Ben Finney