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
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
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/>