By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,587 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,587 IT Pros & Developers. It's quick & easy.

Which PostgreSQL adapter to use?

P: n/a
Hey,
Which Adapter to use with PostgreSQL:
PyPgSQL, psycopg or PyGreSQL?
Thanks.
Nov 4 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 4 '08 #2

P: n/a
On Tue, 04 Nov 2008 17:13:43 +0100
Thomas Guettler <hv@tbz-pariv.dewrote:
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
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
Nov 4 '08 #3

P: n/a
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
Nov 4 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.