X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fintro.xml;h=57666effbc57eb68eac54356f0f6796a8cb0bf0e;hb=967266c94b00f91e5967b8330fe2b9134b0c0447;hp=1c7ed2e7ec34fdb5c2104a286383924869b71a2d;hpb=7c52ed0a7fb4d3c191d4454576a4c761ef2a146d;p=clsql.git diff --git a/doc/intro.xml b/doc/intro.xml index 1c7ed2e..57666ef 100644 --- a/doc/intro.xml +++ b/doc/intro.xml @@ -11,49 +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. Recently, the UncommonSQL - package has been ported and integrated with &clsql;. 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. - transaction support. + Pooled connections. - UncommonSQL support. + Integrated transaction support for the classic + &maisql; iteration macros. @@ -112,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;). @@ -226,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