X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fintro.xml;h=57666effbc57eb68eac54356f0f6796a8cb0bf0e;hb=f716bb1161cf9e89a96945c4a444244f9d303691;hp=a96db8f0efbeaba535b184beda032abe2d8c74ed;hpb=5e89022823870e5f1b0a255016a8e48d6a9c53b2;p=clsql.git diff --git a/doc/intro.xml b/doc/intro.xml index a96db8f..57666ef 100644 --- a/doc/intro.xml +++ b/doc/intro.xml @@ -11,45 +11,58 @@ Purpose &clsql; is a Common Lisp interface to SQL databases. A number of Common - Lisp implementations and SQL databases are supported. The general - structure of &clsql; is based on the - CommonSQL - package by Xanalys. + linkend="gloss-sql">SQL databases. A number of Common + Lisp implementations and SQL databases are supported. The general + structure of &clsql; is based on the &commonsql; package by + Xanalys. History - &clsql; is written by Kevin M. Rosenberg and based substantially - on Pierre R. Mai's excellent &maisql; package. The main changes - from &maisql; are: + The &clsql; project was started by Kevin M. Rosenberg in 2001 to + support SQL access on multiple Common Lisp implementations using + the &uffi; library. The initial code was based substantially on + Pierre R. Mai's excellent &maisql; package. In late 2003, the + &usql; library was orphaned by its author, onShore Development, + Inc. In April 2004, Marcus Pearce ported the &usql; library to + &clsql;. The &usql; library provides a &commonsql;-compatible + API for &clsql;. + + + The main changes from &maisql; and &usql; are: - port from the &cmucl; FFI to &uffi;. + Port from the &cmucl; FFI to &uffi; which provide + compatibility with the major Common Lisp + implementations. Optimized loading of integer and floating-point fields. - new &acl; ODBC interface back-end. + Additional database backends: &odbc;, &aodbc;, and &sqlite;. - compatibility layer for &cmucl; specific code. + A compatibility layer for &cmucl; specific code. - much improved robustness for the &mysql; back-end + Much improved robustness for the &mysql; back-end along with version 4 client library support. - improved system loading. + Improved library loading and installation documentation. + + + Improved packages and symbol export. - improved packages and symbol export. + Pooled connections. - transaction support. + Integrated transaction support for the classic + &maisql; iteration macros. @@ -108,12 +121,12 @@ Currently, &clsql; supports the following databases: - &mysql; v3.23.51 and v4.0.15. - &postgresql; v7.2 with both direct API and TCP + &mysql; v3.23.51 and v4.0.18. + &postgresql; v7.4 with both direct API and TCP socket connections. &sqlite;. - Allegro's ODBC interface (&aodbc;) using iODBC - ODBC manager. + Direct &odbc; interface. + Allegro's DB interface (&aodbc;). @@ -222,6 +235,8 @@ (asdf:operate 'asdf:load-op 'clsql-mysql) ; MySQL interface (asdf:operate 'asdf:load-op 'clsql-postgresql) ; PostgreSQL interface (asdf:operate 'asdf:load-op 'clsql-postgresql-socket) ; Socket PGSQL interface +(asdf:operate 'asdf:load-op 'clsql-odbc) ; ODBC interface +(asdf:operate 'asdf:load-op 'clsql-sqlite) ; SQLite interface (asdf:operate 'asdf:load-op 'clsql-aodbc) ; Allegro ODBC interface (asdf:operate 'asdf:load-op 'clsql) ; main CLSQL package