From: Jeff Davis <jdavis-list@...>
Date: 2005-01-30T11:48:48+09:00
Subject: postgres module

The primary module for accessing a PostgreSQL database seems to be the 
'postgres' module on RAA.

However, the last release was in '03, and it seems like the module could 
use a little improvement. Also, it never hit that 1.0 mark, so I suppose 
the author doesn't think it's quite done either.

I am interested in writing a new postgresql module, is that a good idea? 
Is there another project underway? To other users of the postgres 
module, is there anything the current one doesn't quite do?

I had a few basic ideas about what I'd like it to do, if anyone has any 
comments please let me know.

First, I'd like to make it possible to execute queries in a more 
ruby-like way, for instance:

pg.exec("select * from my_table") do |rec|
     puts "#{rec['name']} #{rec['occupation']}"
end

Of course it would raise an exception if something went wrong. Also, I 
could make the iterator a method of the result object, rather than 
turning exec into an iterator.

Also, there just seem to be some things missing from the 'postgres' 
module, like getnotify(), asynchronous queries, etc.

Regards,
	Jeff Davis