From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM autolearn=ham autolearn_force=no version=3.4.4 X-Google-Thread: 103376,2efc07c562a92932 X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!not-for-mail From: "Alex R. Mosteo" Newsgroups: comp.lang.ada Subject: Re: Ada & Postgresql Date: Mon, 06 Sep 2004 14:56:36 +0200 Message-ID: <2q351cFqc2k5U1@uni-berlin.de> References: <2prmojFo9eo1U1@uni-berlin.de> <2q2m4sFqobhgU1@uni-berlin.de> <2q2nvhFq4qqdU1@uni-berlin.de> <2q2r9tFqihj7U1@uni-berlin.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news.uni-berlin.de 6QXdHPo/nu/q0khRWCivsQEtKvH+VujfVJ/qK2WWY+Ydvzm7w= User-Agent: Mozilla Thunderbird 0.7.1 (X11/20040626) X-Accept-Language: en-us, en In-Reply-To: Xref: g2news1.google.com comp.lang.ada:3375 Date: 2004-09-06T14:56:36+02:00 List-Id: 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.