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 autolearn=ham
	autolearn_force=no version=3.4.4
X-Google-Thread: 103376,bf02c238a92156a3
X-Google-Attributes: gid103376,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news1.google.com!news1.google.com!proxad.net!proxad.net!npeer.de.kpn-eurorings.net!news.uni-stuttgart.de!carbon.eu.sun.com!btnet-feed5!btnet!news.btopenworld.com!not-for-mail
From: Martin Dowie <martin.dowie@btopenworld.com>
Newsgroups: comp.lang.ada
Subject: Re: Windows Ada database support.
Date: Sun, 28 Nov 2004 14:38:49 +0000 (UTC)
Organization: BT Openworld
Message-ID: <cocnto$h08$1@hercules.btinternet.com>
References: <1pfbqtrpc3y3v$.1j9ia6xrmr4pc$.dlg@40tude.net>
 <2004112719465816807%david@bottoncom>
 <1wgmsz9nqhzhm.8k6e3o359925$.dlg@40tude.net> <ud5xyqnks.fsf@obry.net>
 <37sspx71yo3v.x8x09ens9mfk.dlg@40tude.net>
NNTP-Posting-Host: host81-152-56-142.range81-152.btcentralplus.com
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: hercules.btinternet.com 1101652729 17416 81.152.56.142 (28 Nov 2004
 14:38:49 GMT)
X-Complaints-To: news-complaints@lists.btinternet.com
NNTP-Posting-Date: Sun, 28 Nov 2004 14:38:49 +0000 (UTC)
In-Reply-To: <37sspx71yo3v.x8x09ens9mfk.dlg@40tude.net>
X-Accept-Language: en-us, en
User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103)
Xref: g2news1.google.com comp.lang.ada:6584
Date: 2004-11-28T14:38:49+00:00
List-Id: <comp.lang.ada>

Dmitry A. Kazakov wrote:
> For one of my projects I even have implemented thick OO-ish bindings to
> ODBC via GNADE, but I am not satisfied with ODBC. Not just because of
> performance, which is awful. The very design of ODBC is something. It
> abstracts SQL, but you still have to use SQL. So it takes the worst of two
> worlds. Do you know, how to query via ODBC, if the data base supports
> "PRIMARY KEY" in "CREATE TABLE"? The number of questions like that is
> countless. The idea, ask how it spelt and tune the application in
> accordance, is just idiotic. Ada's way(tm) is: I want "type X is range
> 1..100", go, do what should be done.
> 
> So in my view ODBC as an implementation (one of), yes of course, but as the
> template for the standard, God save us!


For my degree I wrote a abstraction of a relational database in SML/NJ. 
It could be converted to Ada fairly simply - is that the sort of thing 
you mean? e.g.

package Relations is
    type Relation is private;
    ...
    procedure Union (X, Y : Relation; Result : out Relation);
    --  etc
end Relations;