search

fukamachi / cl-dbi

Database independent interface for Common Lisp
205 stars 28 forks source link

CL-MSSQL #27

Open daveloyall opened 8 years ago

daveloyall commented 8 years ago

What would need to happen before "MS SQL Server" could be added to this list https://github.com/fukamachi/cl-dbi#databases ?

daveloyall commented 8 years ago

This exists: https://github.com/archimag/cl-mssql/

You'll note that it depends on a third-party tool, FreeTDS, which runs only on Linux (and maybe other *nix platforms).

I'm mentioning this as a comment, not as part of the question, since there may be some superior path to follow that I am unaware of. :)

eudoxia0 commented 8 years ago

Both the Python and Ruby MSSQL interface libraries use FreeTDS, so I'm guessing it's a fairly standard thing and most people who have ot use MSSQL won't complain about that dependency.

The obvious next step is to write a dbi driver that wraps the functionality provided by cl-mssql. There is some documentation in the Quickdocs page.

fchurca commented 8 years ago

Trying to load cl-mssql without FreeTDS installed results in quickload choking on CFFI and the missing libsybdb.so, so adding cl-mssql as a dependency may not be pretty if the user doesn't actually need mssql support. The functionality could be added either in cl-mssql, making it depend on cl-dbi, or in a third library depending on both. FreeTDS actually connects to Sybase too, so I suspect this could either give Sybase support too or at least make it easier.