Re: Ada & Postgresql

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

Marius Amado Alves wrote:
> 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.

The leak in Gnade is probably safe to ignore as long you know it exists. 
If you only use a connection during the app lifetime you're safe. 
Otherwise you have a 48 byte penalty for each one. It is very easy to 
patch, btw, so it is not really a deterrent.

> 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.

This may have changed, since my inspection of Gnade shows an almost 
equal simplicity between it and Pgsql. One call to connect, one call 
with the textual SQL query, and a result type accessible by indexes.

The ODBC thin binding is another kind of beast, as already noted.

> [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.

Check the source distribution, it has .tgz file and furthermore it 
includes the examples, which the linux binary (don't know about the 
windows one) one doesn't.

Or take this link

http://sourceforge.net/project/showfiles.php?group_id=23045&package_id=19410

to reach the binary installable for windows.