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,FREEMAIL_FROM
	autolearn=ham autolearn_force=no version=3.4.4
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 103376,b7758ee808aeb9a3
X-Google-Attributes: gid103376,public
X-Google-ArrivalTime: 2003-11-25 10:10:53 PST
Path: archiver1.google.com!postnews1.google.com!not-for-mail
From: i_eat_pies@hotmail.com (Andy)
Newsgroups: comp.lang.ada
Subject: Re: AWS -> Ada -> MySql
Date: 25 Nov 2003 10:10:52 -0800
Organization: http://groups.google.com
Message-ID: <7ad345db.0311251010.22529a17@posting.google.com>
References: <7ad345db.0311110802.1db25166@posting.google.com>
 <0l9sb.7368$fB3.462108@news20.bellglobal.com>
NNTP-Posting-Host: 81.6.249.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1069783853 5343 127.0.0.1 (25 Nov 2003 18:10:53
 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 25 Nov 2003 18:10:53 +0000 (UTC)
Xref: archiver1.google.com comp.lang.ada:2931
Date: 2003-11-25T10:10:52-08:00
List-Id: <comp.lang.ada>

"Warren W. Gay VE3WWG" <ve3wwg@cogeco.ca> wrote in message news:<0l9sb.7368$fB3.462108@news20.bellglobal.com>...
> Andy wrote:
> > I am looking to create a MySql database connecting to an Ada program
> > capable of administering the database, which in turn will be hosted
> > using Ada Web Server.
> > 
> > Is this even possible?
> > 
> > The MySql database is not a problem to create, but currently i am
> > struggling to figure how the Ada can control the database. Has anyone
> > had any success in this field?
> 
> What do you mean by "Ada can control the database?"  If you are
> talking about a client program in Ada using a MySQL database, then
> you can use the APQ library (see prominent link on my home page
> below). APQ makes it very simple to do SQL queries on a PostgreSQL
> and/or MySQL database in natural Ada terms, without any
> source code preprocessing. I would think that this would be a
> trivial thing to do from the "Ada Web Server".
> 
> If instead you are speaking about _administering_ a MySQL database
> from an Ada program, then you'll need to look elsewhere. APQ presently
> only performs "client" related functions, not administration/server
> functions.


excellent thank you, i'm looking at the GNADE project, but am also
interested in other ways such as yours, thanks for highlighting it to
me.  I'll go have a look at it.
andy.