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=-0.3 required=5.0 tests=BAYES_00,
	REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!news.eternal-september.org!mx05.eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Newsgroups: comp.lang.ada
Subject: Re: Addressing MySQL from Ada
Date: Mon, 10 Jun 2013 09:23:01 +0200
Organization: cbb software GmbH
Message-ID: <2mdbcjrjtw3c.1sh1f056tzyfn$.dlg@40tude.net>
References: <7d8f3913-99de-4502-8aa2-208c2b36ca5f@googlegroups.com>
Reply-To: mailbox@dmitry-kazakov.de
NNTP-Posting-Host: IenaDxMXK2hi7fvYcb+MlQ.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
User-Agent: 40tude_Dialog/2.0.15.1
X-Notice: Filtered by postfilter v. 0.8.2
Xref: news.eternal-september.org comp.lang.ada:15723
Date: 2013-06-10T09:23:01+02:00
List-Id: <comp.lang.ada>

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