Differences between revisions 3 and 4
Revision 3 as of 2002-08-02 13:04:50
Size: 2548
Editor: mail
Comment:
Revision 4 as of 2002-08-02 16:27:51
Size: 2543
Editor: mail
Comment:
Deletions are marked like this. Additions are marked like this.
Line 90: Line 90:
 * Supports many languagse for writing server-side procedures and definining new aggregates: Python, C, Perl, Tcl, PL/PgSQL, ...  * Supports many languages for writing server-side functions/procedures and aggregates: Python, C, Perl, Tcl, PL/PgSQL, ...

TableOfContents

Masthead

URL

http://www.postgresql.org/

licence
BSD-like
platforms
Unix, win32 (Cygwin); a native win32 port is in the works

DB API 2.0 Drivers

PyGresQL

URL

http://www.druid.net/pygresql/

licence
BSD-like
platforms
Unix, win32
Python versions
1.5.2 thru 2.2

Extensions to DB API

  • Alternative old nonstandard PostgreSQL interface

Comments

PoPy

URL

http://popy.sourceforge.net

licence
GPL
platforms
Unix
Python versions

Extensions to DB API

Comments

psycopg

URL

http://initd.org/Software/psycopg

licence
GPL
platforms
Unix, win32 (beta)
Python versions

Extensions to DB API

  • dictfetchone(), dictfetchmany(), dictfechall() methods on the cursor object; these will return dictionaries instead of tuples, so you can access rows by name instead of by index

Comments

  • Written for heavily multithreaded applications in mind.

pyPgSQL

URL

http://pypgsql.sourceforge.net

licence
BSD-like
platforms
Unix, win32
Python versions
2.0 thru 2.2

Extensions to DB API

  • The fetch methods on cursors return an instances of PgResultSet, which you can use to access rows by index (like in DB-API), dictionary-like or with attributes. This feature can be turned off for a slight performance boost.

  • Support for PostgreSQL notifications in the low-level API.

Comments

Other Drivers

driver name

URL
licence
platforms
Python versions

Programming Model

Comments

Supported Python Applications

Pros

  • Good compliance with SQL standards
  • Supports many SQL features
    • Foreign keys
    • Implements all SQL99 join types: inner join, left, right, full outer join, natural join
    • Subqueries
    • UNION and UNION ALL, INTERSECT and EXCEPT
    • Views
    • Triggers
  • Support for international character sets, multibyte character encodings, Unicode
  • Supports many languages for writing server-side functions/procedures and aggregates: Python, C, Perl, Tcl, PL/PgSQL, ...
  • ACID compliant
  • Support for rollback
  • Serializable transaction isolation
  • Multi-Version Concurrency Control (MVCC) for highly scalable concurrent applications

Cons

  • No native Windows version (yet), but there is a Cygwin version.

PostgreSQL (last edited 2021-03-31 06:49:56 by TonyLocke)

Unable to edit the page? See the FrontPage for instructions.