Re: CLSQL-USQL

Marcus Pearce <[email protected]> Mon, 5 Apr 2004 11:19:21 +0100 (BST)
Newsgroups gmane.lisp.clsql.general,gmane.lisp.uncommon-sql
Message-ID <[email protected]>
> > I personally think that the loop extensions are nice to have. Given
> > SBCL's relation to CMUCL it shouldn't be too hard to make the
> > extensions available there. Also, there is my code (which I myself got
> > from Xanalys support) for a LispWorks loop extension in Paul Foley's
> > BerkeleyDB package. This could be used as a basis for LW. So we'd have
> > four implementation covered already.

I kept the loop extension for precisely that reason: it is nice to have on
cmucl/scl and hopefully can be extended to other lisp implementations.
Also, for what its worth, it is in the CommonSQL API.

> I think as CLSQL grows and people want to use the most advanced features
> available in their platforms, there may be more feature fragmentation
> due to the differences in SQL backends.

I would like to think that the various RDBMS would gradually converge
towards conformity with the SQL standard which would help combat feature
fragmentation.

> Or, like the recently added SQLite backend, which doesn't support views
> or transactions.

The SQLite backend does support views and transactions. MySQL doesn't
support views (at least in Version 4) and I couldn't get transactions
working properly -- everything seems to just autocommit. It probably needs
some configuration but I don't really use MySQL so I didn't spend too much
time trying to figure this out.

Cheers,
Marcus