Re: Ada and PostgreSQL

["Alex R. Mosteo" <devnull@mailinator.com>]

Maciej Sobczak wrote:

> Hi,
> 
> I must have been quite a pain for you recently with my questions and
> nit-picking ;-), but at the end I have finished my exercise and built a
> *very* simple Ada client library for PostgreSQL.
> You can find it here:
> 
> http://msobczak.com/prog/bin/pgAda.tar.gz
> 
> Please consider it as a starting point for what should be a *true*
> database library, but there are also chances that in simpler projects it
> might be exactly what is needed.
> 
> Your comments are of course welcome.

Have you taken a look at GNADE postgresql binding? It has some points in
common to yours; it is more limited in some aspects (transactions and query
parameters).

I'd look into making transactions in such a way that declaring it in some
scope provides automatic operation, e.g.:

declare
   T : Transaction (Db'Access); -- Automatic start of transaction 
                                -- via Initialize
begin
   Query (.... T); -- Automatic rollback on failure here
end;               -- Automatic commit on Finalize

I'm doing it with a wrapper over Gnu.Db.Postgresql and it is quite handy.

In any case is nice to see more support for this database.