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 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-11 10:07:10 PST Path: archiver1.google.com!news2.google.com!news.maxwell.syr.edu!cyclone.bc.net!news.uunet.ca!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail From: "Warren W. Gay VE3WWG" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.lang.ada Subject: Re: AWS -> Ada -> MySql References: <7ad345db.0311110802.1db25166@posting.google.com> In-Reply-To: <7ad345db.0311110802.1db25166@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <0l9sb.7368$fB3.462108@news20.bellglobal.com> Date: Tue, 11 Nov 2003 12:52:33 -0500 NNTP-Posting-Host: 198.96.223.163 X-Complaints-To: abuse@sympatico.ca X-Trace: news20.bellglobal.com 1068573116 198.96.223.163 (Tue, 11 Nov 2003 12:51:56 EST) NNTP-Posting-Date: Tue, 11 Nov 2003 12:51:56 EST Organization: Bell Sympatico Xref: archiver1.google.com comp.lang.ada:2365 Date: 2003-11-11T12:52:33-05:00 List-Id: 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. -- Warren W. Gay VE3WWG http://home.cogeco.ca/~ve3wwg