On database interface libraries for Ada

On database interface libraries for Ada

[Ludovic Brenta]

A recent discussion on the AWS users' mailing list made me realize
that there exist many, many different libraries for interfacing Ada
programs to various database engines. I even learned about a couple
that I was not yet aware of.

I think it would be very nice to consolidate all the information
available on all these libraries in one place, so that programmers
know about them and can choose wisely. It seems to me that the best
place for such a discussion is the existing page on the "Ada
Programming" wikibook:

http://en.wikibooks.org/wiki/Ada_Programming/Libraries/Database

This page was very incomplete, listing only GNADE, APQ and GWindows
with links to their home pages but no other information. I have edited
this page to provide more information in a table. The information
there is still incomplete; please add your favourite database
interface library to the page for better visibility and correct the
information as you deem necessary. Also feel free to add notes and
details outside the table.

Thanks for your help.

--
Ludovic Brenta.

Re: On database interface libraries for Ada

[Ludovic Brenta]

I wrote on comp.lang.ada:
> http://en.wikibooks.org/wiki/Ada_Programming/Libraries/Database

Side note: since my changes have not yet been "sighted" (whatever that
means), you must click on "View draft" on the top-right corner of the
page to see the most recent version.

--
Ludovic Brenta.

Re: On database interface libraries for Ada

[Tero Koskinen]

On Thu, 29 Apr 2010 06:41:32 -0700 (PDT) Ludovic Brenta wrote:
> A recent discussion on the AWS users' mailing list made me realize
> that there exist many, many different libraries for interfacing Ada
> programs to various database engines. I even learned about a couple
> that I was not yet aware of.
> 
> I think it would be very nice to consolidate all the information
> available on all these libraries in one place, so that programmers
> know about them and can choose wisely. It seems to me that the best
> place for such a discussion is the existing page on the "Ada
> Programming" wikibook:
> 
> http://en.wikibooks.org/wiki/Ada_Programming/Libraries/Database

Another place which lists various database bindings/libraries is
AdaCommons wiki:
http://www.adacommons.org/Category:Database

> --
> Ludovic Brenta.

-- 
Tero Koskinen - http://iki.fi/tero.koskinen/

Re: On database interface libraries for Ada

[xavier grave]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 29/04/2010 15:41, Ludovic Brenta a �crit :
> A recent discussion on the AWS users' mailing list made me realize
> that there exist many, many different libraries for interfacing Ada
> programs to various database engines. I even learned about a couple
> that I was not yet aware of.
> 
> I think it would be very nice to consolidate all the information
> available on all these libraries in one place, so that programmers
> know about them and can choose wisely. It seems to me that the best
> place for such a discussion is the existing page on the "Ada
> Programming" wikibook:
> 
> http://en.wikibooks.org/wiki/Ada_Programming/Libraries/Database

Thanks Ludovic for this URL and the information it contains.
I'm working with sqlite3 now, I'll be glad to have a more complete
binding to it using SQLite3-Ada than the very poor one I have developed
for my needs (it only uses blob).

> This page was very incomplete, listing only GNADE, APQ and GWindows
> with links to their home pages but no other information. I have edited
> this page to provide more information in a table. The information
> there is still incomplete; please add your favourite database
> interface library to the page for better visibility and correct the
> information as you deem necessary. Also feel free to add notes and
> details outside the table.
> 
> Thanks for your help.
> 
> --
> Ludovic Brenta.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkvafSkACgkQVIZi0A5BZF6lFACeLaBai+J9mTgZj8EWUlOYuQ/q
wygAn2/Bu/ir5gRJcFXXuQXQCaKjetuB
=LFVS
-----END PGP SIGNATURE-----

Re: On database interface libraries for Ada

[Dmitry A. Kazakov]

On Fri, 30 Apr 2010 08:48:10 +0200, xavier grave wrote:

> I'm working with sqlite3 now, I'll be glad to have a more complete
> binding to it using SQLite3-Ada than the very poor one I have developed
> for my needs (it only uses blob).

I have SQLite3 bindings (middle thickness) in the Simple Components:

http://www.dmitry-kazakov.de/ada/components.htm#SQLite

It is more than blobs, but not all SQLite.

P.S. GNADE has SQLite bindings as well. I didn't use them because I wanted
to be able to put the amalgation directly into the project, the only
sensible use of SQLite, IMO.

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

Re: On database interface libraries for Ada

[Ludovic Brenta]

Dmitry A. Kazakov wrote on comp.lang.ada:
> On Fri, 30 Apr 2010 08:48:10 +0200, xavier grave wrote:
>> I'm working with sqlite3 now, I'll be glad to have a more complete
>> binding to it using SQLite3-Ada than the very poor one I have developed
>> for my needs (it only uses blob).
>
> I have SQLite3 bindings (middle thickness) in the Simple Components:
>
> http://www.dmitry-kazakov.de/ada/components.htm#SQLite
>
> It is more than blobs, but not all SQLite.
>
> P.S. GNADE has SQLite bindings as well. I didn't use them because I wanted
> to be able to put the amalgation directly into the project, the only
> sensible use of SQLite, IMO.

It would be nice if you would add the relevant information to the wiki
page for future reference. This should not take you more time than
writing your post did. Also explaining the differences between the 4
different bindings to SQLite (5 with yours) would help.

--
Ludovic Brenta.

Re: On database interface libraries for Ada

[Dmitry A. Kazakov]

On Fri, 30 Apr 2010 02:28:44 -0700 (PDT), Ludovic Brenta wrote:

> Also explaining the differences between the 4
> different bindings to SQLite (5 with yours) would help.

OK

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

Re: On database interface libraries for Ada

[Dmitry A. Kazakov]

On Thu, 29 Apr 2010 06:41:32 -0700 (PDT), Ludovic Brenta wrote:

> http://en.wikibooks.org/wiki/Ada_Programming/Libraries/Database

What about a separate section for embedded / single file data bases e.g.
SQLite, Berkeley etc? From my point of view it is a quite different topic
from the bindings to/as DBMS clients.

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

Re: On database interface libraries for Ada

[Ludovic Brenta]

Dmitry A. Kazakov wrote:
> On Thu, 29 Apr 2010 06:41:32 -0700 (PDT), Ludovic Brenta wrote:
>> http://en.wikibooks.org/wiki/Ada_Programming/Libraries/Database
>
> What about a separate section for embedded / single file data bases e.g.
> SQLite, Berkeley etc? From my point of view it is a quite different topic
> from the bindings to/as DBMS clients.

On the one hand I think that's a valid distinction.  On the other,
such a split would lead to duplicate information since, for example,
GNADE, QtAda and gnatcoll support both embedded and client-server
databases.  Also, this is a property of the target database engine,
not necessarily of the Ada binding.  Maybe adding a note that SQLite
is in-process (linked either statically or dynamically) would be
sufficient.  (I do not know of a Berkeley DB binding, yet...)

--
Ludovic Brenta.

Re: On database interface libraries for Ada

[Dmitry A. Kazakov]

On Fri, 30 Apr 2010 03:31:33 -0700 (PDT), Ludovic Brenta wrote:

>  (I do not know of a Berkeley DB binding, yet...)

I remember that somebody announced it. (Before I did SQLite, I tried to
find any information about these bindings, but failed. Then I considered to
do it by myself, but was horrified by its interface. So in the end I
decided in favor of SQLite.)

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