3 CLSQL-USQL is a high level SQL interface for Common Lisp which is
4 based on the CommonSQL package from Xanalys. It was originally
5 developed at Onshore Development, Inc. based on Pierre Mai's MaiSQL
6 package. It now incorporates some of the code developed for CLSQL. See
7 the files CONTRIBUTORS and COPYING for more details.
9 CLSQL-USQL depends on the low-level database interfaces provided by
10 CLSQL and includes both a functional and an object oriented
11 interface to SQL RDBMS.
15 A CLSQL-USQL tutorial can be found in the directory doc/
17 Also see the CommonSQL documentation avaialble on the Lispworks website:
19 Xanalys LispWorks User Guide - The CommonSQL Package
20 http://www.lispworks.com/reference/lw43/LWUG/html/lwuser-167.htm
22 Xanalys LispWorks Reference Manual -- The SQL Package
23 http://www.lispworks.com/reference/lw43/LWRM/html/lwref-383.htm
25 CommonSQL Tutorial by Nick Levine
26 http://www.ravenbrook.com/doc/2002/09/13/common-sql/
31 o COMMON LISP: currently CMUCL, SBCL, Lispworks
32 o RDBMS: currently Postgresql, Mysql, Sqlite
33 o ASDF (from http://cvs.sourceforge.net/viewcvs.py/cclan/asdf/)
34 o CLSQL-2.0.0 or later (from http://clsql.b9.com)
35 o RT for running the test suite (from http://files.b9.com/rt/rt.tar.gz)
40 Just load clsql-usql.asd or put it somewhere where ASDF can find it
43 (asdf:oos 'asdf:load-op :clsql-usql)
45 You'll then need to load a CLSQL backend before you can do anything.
47 To run the regression tests load clsql-usql-tests.asd or put it
48 somewhere where ASDF can find it, edit the file tests/test-init.lisp
49 and set the following variables to appropriate values:
51 *test-database-server*
54 *test-database-password*
58 (asdf:oos 'asdf:load-op :clsql-usql-tests)
59 (usql-tests:test-usql BACKEND)
61 where BACKEND is the CLSQL database interface to use (currently one of
62 :postgresql, :postgresql-socket, :sqlite or :mysql).