[DB-SIG] py-postgresql-0.8 for Python 3 Released: Was pg_proboscis

[James Pye]

I'm pleased to announce the release of py-postgresql 0.8. This release  
marks months of work porting the 2.x code to Python 3 and making  
numerous improvements. py-postgresql is a port of pg_proboscis-1.0 and  
other projects under the "pg/python project umbrella". This release  
simplifies the project structure by combining the smaller projects  
into one easy-to-manage package.


	http://python.projects.postgresql.org


Documentation:
   http://python.projects.postgresql.org/docs/0.8
Source:
   http://python.projects.postgresql.org/files/py- 
postgresql-0.8.0.tar.gz
Win32 Installer:
   http://python.projects.postgresql.org/files/py-postgresql-0.8.0.win32-py30.exe


Features:

* BSD/MIT/PSF Licensed.

* Documentation. =)

* Pure-Python + C optimizations. No need for libpq.

* Prepared Statement driven interface/native APIs. (DB-API 2.0 is here  
too ;)
  (PG-API, [Was: "pg_greentrunk"])

* Scrollable cursors with configurable direction for paging.

* COPY support. [iter(db.prepare("COPY table TO STDOUT"))]

* Windows support. We love you too. ;)

* pg_python quick console.
  $ pg_python -h localhost -> Gives a Python prompt with a connection  
bound to `db`.

* Support for most PostgreSQL types. (datetime.*, numeric->decimal,  
and more)

* Composite Types and Arrays. Fully structured for easy access.

* Row-objects returned by cursors support
  Mapping and Sequence interfaces. (row["colname"], row[0])

* Over 150 tests and counting!


Sample PG-API code via pg_python:

$ pg_python -h localhost -U postgres -d postgres

Backslash Commands:

\?      Show this help message.
\E      Edit a file or a temporary script.
\e      Edit and Execute the file directly in the context.
\i      Execute a Python script within the interpreter's context.
\set    Configure environment variables. \set without arguments to  
show all
\x      Execute the Python command within this process.

Python 3.0.1+ (release30-maint:70204M, Mar  5 2009, 21:28:06)
Type "help", "copyright", "credits" or "license" for more information.
(ExtendedConsole)
 >>> ps = db.prepare('select 1')
 >>> ps()
[(1,)]
 >>> ps.first()
1
 >>> c = ps.declare()
 >>> c.read()
[(1,)]
 >>> c.seek(0)
 >>> c.read()
[(1,)]