* Re: Addressing MySQL from Ada
2013-06-10 0:27 Addressing MySQL from Ada Rick
@ 2013-06-10 5:05 ` J-P. Rosen
2013-06-10 7:23 ` Dmitry A. Kazakov
` (3 subsequent siblings)
4 siblings, 0 replies; 6+ messages in thread
From: J-P. Rosen @ 2013-06-10 5:05 UTC (permalink / raw)
Le 10/06/2013 02:27, Rick a écrit :
> I am in the planning stages of a new project which will involve Ada
> code and a MySQL database. I have never tried accessing a relational
> database from Ada and I am looking for something like "Addressing
> MySQL from Ada for Dummies".
>
> Does anyone know of a suitable document or book I might try?
I have used MySQL in one of my project. How I did it is described in the
paper "Experiences in developing a typical web/database application",
that you can fetch from http://www.adalog.fr/publica2.htm
HTH
--
J-P. Rosen
Adalog
2 rue du Docteur Lombard, 92441 Issy-les-Moulineaux CEDEX
Tel: +33 1 45 29 21 52, Fax: +33 1 45 29 25 00
http://www.adalog.fr
^ permalink raw reply [flat|nested] 6+ messages in thread* Re: Addressing MySQL from Ada
2013-06-10 0:27 Addressing MySQL from Ada Rick
2013-06-10 5:05 ` J-P. Rosen
@ 2013-06-10 7:23 ` Dmitry A. Kazakov
2013-06-10 9:54 ` ake.ragnar.dahlgren
` (2 subsequent siblings)
4 siblings, 0 replies; 6+ messages in thread
From: Dmitry A. Kazakov @ 2013-06-10 7:23 UTC (permalink / raw)
On Sun, 9 Jun 2013 17:27:08 -0700 (PDT), Rick wrote:
> I am in the planning stages of a new project which will involve Ada code
> and a MySQL database. I have never tried accessing a relational database
> from Ada and I am looking for something like "Addressing MySQL from Ada
> for Dummies".
There is nothing special in MySQL. It is a relational DB as any other
interfaced through SQL.
I would suggest using ODBC rather than MySQL client bindings. You never
know if you stay with a specific RDBMS or switch to another. There are
plenty of RDBMS available. ODBC makes it portable (up to the SQL
statements, of course).
> Does anyone know of a suitable document or book I might try?
I don't know. It is pretty straightforward. You create environment, make a
connection, prepare a statement, bind parameters, execute it, fetch
results. Repeat.
You need to know SQL and its specifics for given DBMS. Ada's part is rather
trivial.
--
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de
^ permalink raw reply [flat|nested] 6+ messages in thread* Re: Addressing MySQL from Ada
2013-06-10 0:27 Addressing MySQL from Ada Rick
2013-06-10 5:05 ` J-P. Rosen
2013-06-10 7:23 ` Dmitry A. Kazakov
@ 2013-06-10 9:54 ` ake.ragnar.dahlgren
2013-06-10 18:42 ` J Kimball
2013-06-10 22:23 ` Rick
4 siblings, 0 replies; 6+ messages in thread
From: ake.ragnar.dahlgren @ 2013-06-10 9:54 UTC (permalink / raw)
Den måndagen den 10:e juni 2013 kl. 02:27:08 UTC+2 skrev Rick:
> I am in the planning stages of a new project which will involve Ada code and a MySQL database. I have never tried accessing a relational database from Ada and I am looking for something like "Addressing MySQL from Ada for Dummies". Does anyone know of a suitable document or book I might try? Thanks
Dear Rick,
May you could consider using GNATColl:
http://libre.adacore.com/tools/gnat-component-collection/
If you finally decide to use postgresql it might be good to read:
http://ada-dk.org/2010/12/getting-gnatcoll-gpl-2010-to-connect-to-postgresql/
Best regards,
Åke Ragnar Dahlgren
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Addressing MySQL from Ada
2013-06-10 0:27 Addressing MySQL from Ada Rick
` (2 preceding siblings ...)
2013-06-10 9:54 ` ake.ragnar.dahlgren
@ 2013-06-10 18:42 ` J Kimball
2013-06-10 22:23 ` Rick
4 siblings, 0 replies; 6+ messages in thread
From: J Kimball @ 2013-06-10 18:42 UTC (permalink / raw)
On 06/09/2013 07:27 PM, Rick wrote:
> I am in the planning stages of a new project which will involve Ada code and a MySQL database. I have never tried accessing a relational database from Ada and I am looking for something like "Addressing MySQL from Ada for Dummies".
>
> Does anyone know of a suitable document or book I might try?
> Thanks
>
There are also MySQL backends to the KOW Framework found on Github and
http://kow.com.br which took APQ and revised it substantially. APQ is
also available, but is pretty bare-bones if you ask me. Matreshka may
also provide MySQL support.
^ permalink raw reply [flat|nested] 6+ messages in thread* Re: Addressing MySQL from Ada
2013-06-10 0:27 Addressing MySQL from Ada Rick
` (3 preceding siblings ...)
2013-06-10 18:42 ` J Kimball
@ 2013-06-10 22:23 ` Rick
4 siblings, 0 replies; 6+ messages in thread
From: Rick @ 2013-06-10 22:23 UTC (permalink / raw)
Thanks for the help, folks.
That'll give me something to work on.
^ permalink raw reply [flat|nested] 6+ messages in thread