#1 libpq Interface

[Anonymous]

Since Apple has decided to eliminate EOF (Enterprise
Object Foundation) from their WebObjects 5.x releases,
perhaps the Cocoa PSQL project could abstract out a
quality Cocoa PostgreSQL interface.

For those who haven't had the pleasure of using EOF,
under WebObjects 4.5 is was possible to use EOF with
Cocoa. WebObjects 5.0 is now purely Java and ObjC is no
longer supported. Desktop application developers could
use the EOF for writing database applications. EOF
offered a way to graphically map ObjC objects to RDBMS
fields, etc.

For example, release a Cocoa framework that can be used
without the Cocoa PSQL application. It could be
included along with Cocoa PSQL but have the ability to
use the framework outside of PSQL.

It should offer all the functionality that the current
libpq API provides.
It should be a Cocoa PSQL wrapper around the libpq API
just like the libpq++ API or libpqXX API (C++).
It should support asyncronous processing via
multi-threading.
It should offer transaction support.

Thought should be given to looking up the GNUStep DB
libraries as they are an attempt to mimic DBKit/EOF
functionality and provide a PostgreSQL95 interface. It
does not offer a drag and drop EOModeler however.

Some or all of GNUStep's object concepts could be
included in a framework that would make Cocoa PSQL's
job that much easier as well as providing a framework
that would benefit all Cocoa developers.

Granted this is more complex than you may have
envisioned but re-inventing the wheel is not productive.