Re: Windows Ada database support.

["Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>]

On Sun, 28 Nov 2004 14:38:49 +0000 (UTC), Martin Dowie wrote:

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

Yes, though I am not sure whether a relational view is the best way of
abstraction. But an abstraction should be.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de