CLSQL uses Defsystem to compile and load its components. Defsystem is included in the CLOCC collection. The version in the pre-packaged distribution is rather old and may not function well. The version in CVS tree tree works quite well. For convenience, a copy of the latest Defsystem at the FTP site of CLSQL.
CLSQL uses UFFI as a Foreign Function Interface (FFI) to support multiple ANSI Common Lisp implementations.
You can download UFFI from its FTP site. There are zip files for Microsoft Windows systems and gzipped tar files for other systems.
The implementations that support CLSQL is governed by the supported implementations of UFFI. The following implementations are supported:
AllegroCL v6.1 on Redhat Linux 7.2, FreeBSD 4.5, and Microsoft Windows XP.
Lispworks v4.2 on Redhat Linux 7.2 and Microsoft Windows XP.
CMUCL 18d-pre on Redhat Linux 7.2, FreeBSD 4.5, and Solaris 2.8.
Currently, CLSQL supports the following databases:
MySQL v3.23.49.
PostgreSQL v7.2 with both direct API and TCP socket connections.
Allegro's ODBC interface (AODBC) using iODBC ODBC manager.