From: Eric de Groot
Subject: CLISP+SQL??
Date: Mon, 14 May 2001 02:07:50 +0000
Message-ID: <W5HL6.11098$vf6.1211709@news1.rdc1.sdca.home.com>

Does anyone know if there are any libs for CLISP to work with MySQL?  CMUCL
has UncommonSQL.  If nothing else would it be possible to port UncommonSQL
to CLISP?  Thanks.

-Eric

From: Craig Brozefsky
Subject: Re: CLISP+SQL??
Date: Mon, 14 May 2001 06:33:50 +0000
Message-ID: <87k83kfnht.fsf@piracy.red-bean.com>

"Eric de Groot" <············@ericdegroot.com> writes:

> Does anyone know if there are any libs for CLISP to work with MySQL?  CMUCL
> has UncommonSQL.  If nothing else would it be possible to port UncommonSQL
> to CLISP?  Thanks.

I see no reason why it would not be possible, but I am not intimately
familiar with CLISP.  Your major issues are going to be the foreign
language interface, and the CLOS implementation.  USQL uses the FLI to
itnerface with the database drivers for MySQL, PostgreSQL and Oracle.
It implements it's object->relational mapping system using the Meta
Object Protocol.

I don't imagine the FLI part being too much of a pain, since I haven't
heard anything bad about CLISPs FLI.  The MOP part is something I know
less about with regards to CLISP.  The MOP parts of USQL have been
ported to LispWorks already and there were only minor changes needed.
Also, if the MOP part really presents a problem for you, you can skip
it entirely and just use the functional interface to SQL, including
the embedded SQL syntax.  This means no def-view-class and the like.

I would love to see a CLISP port of USQL, and can offer some guidance
if you can get a good chunk of the work done. 8)

-- 
Craig Brozefsky                             <·····@red-bean.com>
                                  http://www.red-bean.com/~craig 
In the rich man's house there is nowhere to spit but in his face
					             -- Diogenes