CL and databases

[jim@gdstech.grumman.com (Jim Eilbert)]

   Date: Wed, 25 Sep 91 09:53:03 +0200
   From: <@nrb.be@mcsun.EU.net>
   X-Vms-Mail-To: NRBV01::UUCP%"BEL0139@APPLELINK.APPLE.COM", NRBV01::UUCP%"INFO-MCL@CAMBRIDGE.APPLE.COM", NRBV01::UUCP%"INFO-MCL@CAMBRIDGE.APPLE.COM"

   Date: Wed, 25 Sep 91 09:49+0100
   From: Vincent Keunen <keunen@milou.nrb.be>
   Subject: CL and databases
   To: INFO-MCL@CAMBRIDGE.APPLE.COM
   cc: uucp%"BEL0139@applelink.apple.com"@nrbv01
   Message-ID: <19910925084901.2.KEUNEN@milou.nrb.be>

   There's been some talk here and there about lisp and databases.  Is
   there a summary or additional comments about that subject somewhere?

   I'd be particularly interested in knowing if anybody has written an
   interface between lisp and a RDBMS, preferably SQL based.  Is there any
   connection between CLOS objects and database data (I know the two
   languages don't have the same expressive power), is there lisp code
   generating SQL requests, etc...

   Please answer to keunen@nrb.be

   Thank you for your help

   Vincent Keunen


************************************

I've run ORACLE from MCL using the foreign function interface.
Essentially, you have to make up a Lisp procedure that calls a C
function for each SQL query you want to make.  This is not a relation
database in Lisp, but it works.

There are a number of object-oriented databases implemented in CLOS. These
databases can support query languages, but they have rather different
properties from standard relational databases.

			Jim Eilbert