Re: CFFI module

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> Fri, 6 Jan 2006 10:51:24 -0700
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
Brad Anderson wrote:
> Will you accept a CFFI-based module for CL-SQL??  I am having some luck connecting to MS SQL Server via
> SWIG-generated CFFI bindings for FreeTDS.  I have a long way to go for it to be a full-fledged CL-SQL module,
> but am willing to give it a whirl, if you would accept.

No, I don't want to add another dependency to CLSQL.  You might have
noticed that I've actually copied functions from my KMRCL library into
CLSQL so that CLSQL wouldn't have to depends to KMRCL.

Hopefully it wouldn't be hard to hand-translate CFFI bindings to
UFFI. Since I don't know CFFI, I don't know how hard it would
be. Further, given that I don't know CFFI and do obviously know UFFI
intimately, I wouldn't be able to properly support those bindings
long-term.

I like FreeTDS fine. I used it back in 1997-99 when I had data in a
SQL Server, but I haven't used MS SQL Server since then. However,
support for MS SQL Server has recently been added to CLSQL using the
ODBC backend.  While I realize there's some advantage to native
bindings, I suspect Microsoft has quite heavily optimized their ODBC
driver for MSSQL.  Still, if you'd like to contrib a FreeTDS backend
using UFFI, I'd certainly consider it for inclusion.

Kevin