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=-2.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM, MAILING_LIST_MULTI autolearn=unavailable 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!proxad.net!usenet-fr.net!enst.fr!melchior!cuivre.fr.eu.org!melchior.frmug.org!not-for-mail From: Marius Amado Alves Newsgroups: comp.lang.ada Subject: Re: Ada & Postgresql Date: Mon, 06 Sep 2004 12:36:09 +0100 Organization: Cuivre, Argent, Or Message-ID: References: <2prmojFo9eo1U1@uni-berlin.de> <2q2m4sFqobhgU1@uni-berlin.de> <2q2nvhFq4qqdU1@uni-berlin.de> <2q2r9tFqihj7U1@uni-berlin.de> NNTP-Posting-Host: lovelace.ada-france.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: melchior.cuivre.fr.eu.org 1094470565 99613 212.85.156.195 (6 Sep 2004 11:36:05 GMT) X-Complaints-To: usenet@melchior.cuivre.fr.eu.org NNTP-Posting-Date: Mon, 6 Sep 2004 11:36:05 +0000 (UTC) To: comp.lang.ada@ada-france.org Return-Path: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en In-Reply-To: <2q2r9tFqihj7U1@uni-berlin.de> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at ada-france.org X-BeenThere: comp.lang.ada@ada-france.org X-Mailman-Version: 2.1.4 Precedence: list List-Id: "Gateway to the comp.lang.ada Usenet newsgroup" List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Xref: g2news1.google.com comp.lang.ada:3367 Date: 2004-09-06T12:36:09+01:00 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.