Re: [clisp-list] Any interest in a native Oracle interface for CLISP?

[Edi W. <ed...@ag...>]

This is not meant to lower CLISP in any way but if your major concern
is a native Oracle interface why don't you use CMUCL with UncommonSQL
<http://ww.telent.net/cliki/UncommonSQL>? This basically is the
vendor independent layer you are looking for.

(CLSQL <http://clsql.med-info.com/> is even more "neutral" because it
is based on UFFI but it currently doesn't support Oracle AFAIK. UFFI
support for CLISP and integration of CLSQL with UncommonSQL is in the
works - see the mailing list archives - but it's not there yet.)

Of course, you could also buy the LispWorks Enterprise Edition
<http://www.xanalys.com/software_tools/products/lwl.html> which comes
with the "original" CommonSQL and full support.

Just my EUR 0.02,
Edi.



"John K. Hinsdale" <hi...@al...> writes:

> Hi, I'm just getting back into Lisp after a very long hiatus (OK, I
> took the Scheme course from Sussman in 1981) and I'm trying to get
> Lisp adopted at my organization.  The catch is we have to deal w/ a
> lot of data in Oracle and while I've settled on CLISP as the preferred
> Lisp, I don't see an Oracle interface for CLISP.
> 
> So, I'm considering writing a *native* Oracle interface, similar to
> what seems to be there for Postgres now.  I searched the list archives
> and it doesn't seem that anyone is working on such a beast.
> 
> I've got a lot of experience w/ programming Oracle's "C" client
> libraries, and read over the documents on building add-ons to CLISP,
> and frankly it doesn't look like too hard a thing for me to do.
> 
> I'm very likely going to do it for my own use, but I am interested to
> know if anyone else would like to:
> 
> 	- use this module to get to Oracle databases from CLISP
> 
> 	- help test it on platforms other than mine (Intel/Linux)
> 
> Would you please get back to me if you are so interested?
> 
> In return you may have to answer some Lisp questions from me as I work
> to scrape the rust off :0
> 
> [N.B.: I have seen suggestions for a socket-level interface to an
> Oracle server ... this is not too great as to get decent performance
> one really has to load the Oracle client libraries directly into the
> process running his program.  The Java people found this out the hard
> way with their socket-based "thin client" which was S-L-O-W.]
> 
> Assuming all this works out, it may be good to start thinking of a
> vendor-independent layer that factors out commonalities among, say
> Postgres, Oracle, Syabase, etc... much as the perl folks have done
> with the "DBI" and "DBD" interfaces.  But CLISP seems a ways away from
> that.
> 
> ---
> John Hinsdale, Alma Mater Software, Inc., Tarrytown, NY 10591-3710 USA
> hi...@al... | http://www.alma.com/staff/hin | +1 914 631 4690
> 
> 
> -------------------------------------------------------
> Sponsored by:
> ThinkGeek at http://www.ThinkGeek.com/
> _______________________________________________
> clisp-list mailing list
> cli...@li...
> https://lists.sourceforge.net/lists/listinfo/clisp-list