Prerequisites

ASDF

CLSQL uses ASDF to compile and load its components. ASDF is included in the CCLAN collection.

UFFI

CLSQL uses UFFI as a Foreign Function Interface (FFI) to support multiple ANSI Common Lisp implementations.

MD5

CLSQL's postgresql-socket interface uses Pierre Mai's md5 module.

Supported Common Lisp Implementation

The implementations that support CLSQL is governed by the supported implementations of UFFI. The following implementations are supported:

  • AllegroCL v6.2 and 7.0b on Debian Linux x86 & x86_64 & PowerPC, FreeBSD 4.5, and Microsoft Windows XP.

  • Lispworks v4.3 on Debian Linux and Microsoft Windows XP.

  • CMUCL 18e on Debian Linux, FreeBSD 4.5, and Solaris 2.8.

  • SBCL 0.8.5 on Debian Linux.

  • SCL 1.1.1 on Debian Linux.

  • OpenMCL 0.14 on Debian Linux PowerPC.

Supported SQL Implementation

Currently, CLSQL supports the following databases:

  • MySQL v3.23.51 and v4.0.18.

  • PostgreSQL v7.4 with both direct API and TCP socket connections.

  • SQLite.

  • Direct ODBC interface.

  • Oracle

  • Allegro's DB interface (AODBC).