From: Steve Long
Subject: MCL and MySQL
Date: 
Message-ID: <BC0D3221.57C6%sal6741@hotmail.com>
This is a question dealing with Macintosh Common Lisp (MCL) and MySQL:

Is anyone aware of or has anyone ever built a set of functions to

(1) Open a connection to MySQL from MCL,
(2) Close a connection to MySQL from MCL,
(3) Perform insert, update, and delete actions on an open connection,
(4) Issue a SQL select statement (string) that returns record-sets in the
form of struct instances, arrays, or lists?

Has anyone implemented such an interface in another way?

I've got MCL 4.3.1 running in the classic environment on a Mac, and MySQL
running on OS10.2.x. If such an interface is feasible, I will upgrade to the
native OS10 version of MCL.

-KBE Sherpa

From: Tyro
Subject: Re: MCL and MySQL
Date: 
Message-ID: <ff11f622.0312230712.237dbb2c@posting.google.com>
Greetings,

Since your problem is MCL-specific, I recommend sending your question
to Info-MCL Mailing List. That way you may increase the chances of
getting a quick and competent response. Take a look at
<http://www.digitool.com/contact.html#discussion-forum>.

Steve Long <·······@hotmail.com> wrote in message news:<·····················@hotmail.com>...
> This is a question dealing with Macintosh Common Lisp (MCL) and MySQL:
> 
> Is anyone aware of or has anyone ever built a set of functions to
> 
> (1) Open a connection to MySQL from MCL,
> (2) Close a connection to MySQL from MCL,
> (3) Perform insert, update, and delete actions on an open connection,
> (4) Issue a SQL select statement (string) that returns record-sets in the
> form of struct instances, arrays, or lists?
> 
> Has anyone implemented such an interface in another way?
> 
> I've got MCL 4.3.1 running in the classic environment on a Mac, and MySQL
> running on OS10.2.x. If such an interface is feasible, I will upgrade to the
> native OS10 version of MCL.
> 
> -KBE Sherpa
From: Edi Weitz
Subject: Re: MCL and MySQL
Date: 
Message-ID: <871xqvei7j.fsf@bird.agharta.de>
On Tue, 23 Dec 2003 07:51:48 GMT, Steve Long <·······@hotmail.com> wrote:

> This is a question dealing with Macintosh Common Lisp (MCL) and MySQL:
>
> Is anyone aware of or has anyone ever built a set of functions to
>
> (1) Open a connection to MySQL from MCL,
> (2) Close a connection to MySQL from MCL,
> (3) Perform insert, update, and delete actions on an open connection,
> (4) Issue a SQL select statement (string) that returns record-sets in the
> form of struct instances, arrays, or lists?
>
> Has anyone implemented such an interface in another way?
>
> I've got MCL 4.3.1 running in the classic environment on a Mac, and
> MySQL running on OS10.2.x. If such an interface is feasible, I will
> upgrade to the native OS10 version of MCL.

According to the docs, CLSQL[1] works with OpenMCL and MySQL. It is
based on UFFI[2] which has "partial" support for MCL. So you could
either use OpenMCL if that is an option or you could use UFFI/CLSQL as
a starting point and add MCL support.

Edi.

[1] <http://clsql.b9.com/>
[2] <http://uffi.b9.com/>