Re: Ada & Postgresql

[Marius Amado Alves <amado.alves@netcabo.pt>]

GNADE vs. Pgsql.

Pgsql is a simple Ada binding to Postgres.
GNADE is a very big [1] Ada library encompassing various database 
systems (Postgres, MySQL, etc.) and protocols (ODBC).
Pick the proper thing for you application. Use Pgsql when you simply 
want to bind to Postgres and don't need ODBC.

Now comparing oranges with oranges, i.e. considering the Postgres 
binding of GNADE, Gnu.Db.Postgres, vs. Pgsql.

As noted, Gnu.Db.Postgres has a leak in the connection area. But has 
controlled queries that automatically reclaim memory on finalization. 
Pgsql has no leaks per se, but in its current version the types are not 
controlled, so the user has to reclaim memory him self. Pick you poison.

However, I think the main difference is in the style of the Ada spec. 
Unfortunately I'm not able to look at Gnu.Db.Postgres right now [2], but 
from what I recall from my examination of the landscape some time ago, 
which has probably included Gnu.Db.Postgres, they are much longer and 
harder to use than Pgsql.

[1] The RPM has 6M, but I don't know what's in it. See note 2.

[2] The Sourceforge site seems to only provide RPM files. How do I read 
this in my Windows XP laptop? Also, when I click the version number on 
the site (hoping to browse the files), I get XML garbage.