20.1.2 Supported databases
Common SQL supports connections to various databases on the platforms indicated below in . Common SQL may work with other platform/ODBC driver combinations and we would be pleased to hear of your experience with these. The keyword shown in the last column is the corresponding value of the
database-type
argument to
sql:connect
:
|
Platform
|
Database
|
Driver/Client library
|
database-type
|
|
Windows
|
ODBC
|
Microsoft SQL Server
|
:odbc
|
|
Windows
|
ODBC
|
Oracle
|
:odbc
|
|
Windows
|
ODBC
|
Postgres
|
:odbc
|
|
Linux
|
ODBC
|
MySQL
|
:odbc
|
|
Linux
|
ODBC
|
Postgres
|
:odbc
|
|
Mac OS X
|
ODBC
|
MySQL
|
:odbc
|
|
Mac OS X
|
ODBC
|
Postgres
|
:odbc
|
|
Linux
|
Oracle
|
Oracle 9i (r2) or 10g
|
:oracle
|
|
Mac OS X
|
Oracle
|
Oracle 10g
|
:oracle
|
|
Windows
|
Oracle
|
Oracle 9i (r2) or 10g
|
:oracle
|
|
Solaris
|
Oracle
|
Oracle 9i (r2) or 10g
|
:oracle
|
|
HP-UX
|
Oracle
|
Oracle 9i (r2) or 10g
|
:oracle
|
|
Linux
|
Oracle
|
Oracle
|
:oracle8
|
|
Solaris
|
Oracle
|
Oracle
|
:oracle8
|
|
HP-UX
|
Oracle
|
Oracle
|
:oracle8
|
|
Linux
|
PostgreSQL
|
Postgres
|
:postgresql
|
|
FreeBSD
|
PostgreSQL
|
Postgres
|
:postgresql
|
|
Mac OS X
|
PostgreSQL
|
Postgres
|
:postgresql
|
|
Windows
|
PostgreSQL
|
Postgres
|
:postgresql
|
|
Linux
|
MySQL
|
MySQL
|
:mysql
|
|
FreeBSD
|
MySQL
|
MySQL
|
:mysql
|
|
Mac OS X
|
MySQL
|
MySQL
|
:mysql
|
|
Windows
|
MySQL
|
MySQL
|
:mysql
|
|
Solaris
|
MySQL
|
MySQL
|
:mysql
|
Note: MySQL versions prior to 4.1.1 should be run in ANSI mode to work with Common SQL. That is,
mysqld
must be started with
--ansi
or the
ansi
option must appear in the
[mysqld]
section of its configuration file.
Note:
Oracle is not currently (July 2006) available for the Intel based Macintosh.
Note: To use PostgreSQL on any non-Microsoft Windows platform, LispWorks/Common SQL requires PostgreSQL version >= 8.x built with
--enable-thread-safety
.
LispWorks User Guide - 11 Mar 2008
