Re: Lispworks and Oracle

Kevin Rosenberg <[email protected]> writes:

> Adam DiCarlo wrote:
> > > I took the CMUCL-based oracle backed from USQL and have put in into
> > I'm kinda suprised to hear that.  I thought the only linking you ever
> > did in CLSQL etc was using UFFI.  I guess not.
> 
> I should clarify about "ready to go". I've put the files in the right
> place, renamed the packages to fit the CLSQL scheme, and wrote an .asd
> file for loading. Just the CMUCL FFI code needs to be ported to
> FFI. But, I've never tested the code. Your initial impression is
> right.

Ok.  Warning to the wise then.  Even our code is somewhat broken,
because for every Oracle platform and release, there seems to be a
different set of their nearly infinite libraries and shared libraries
and objects that need to be loaded.  It's most annoying.  (I hate you
Ellison.)

> The next things that I'll be adding to CLSQL, besides DB2 support, is
> table locking, parameterized SQL queries, and perhaps reworking of
> transactions. Right now that work is occurring under contract, I hope
> that the institution will allow me to release those changes as
> open-source.

I surely hope so.  In the future you might wanna make this a condition
of employment contracts, if you can afford to.

> That'd be great if USQL one day supported CLSQL as a backend. As I
> wrote before, I've done work in separting out a CLSQL-BASE package
> designed for such a purpose.

Yes. Just FYI, over at onShoreD we're gearing up for another major
release of our proprietary flagship project, which is also the
milestone we're waiting for in terms of releasing new versions of
IMHO, USQL, ODCL, and LocalTime.  Wish us luck.

-- 
...Adam Di Carlo..<[email protected]>...<URL:http://www.onshored.com/>