X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=usql%2FREADME;fp=usql%2FREADME;h=c0ea747642ca11ce543ff77eed307af20c126be8;hb=ce0e343835a040406678dff74a62d1b0cb56f317;hp=0000000000000000000000000000000000000000;hpb=edd1963395a5b5e5f91ef975fcd329975ae367e2;p=clsql.git diff --git a/usql/README b/usql/README new file mode 100644 index 0000000..c0ea747 --- /dev/null +++ b/usql/README @@ -0,0 +1,64 @@ +INTRODUCTIION + +CLSQL-USQL is a high level SQL interface for Common Lisp which is +based on the CommonSQL package from Xanalys. It was originally +developed at Onshore Development, Inc. based on Pierre Mai's MaiSQL +package. It now incorporates some of the code developed for CLSQL. See +the files CONTRIBUTORS and COPYING for more details. + +CLSQL-USQL depends on the low-level database interfaces provided by +CLSQL and includes both a functional and an object oriented +interface to SQL RDBMS. + +DOCUMENTATION + +A CLSQL-USQL tutorial can be found in the directory doc/ + +Also see the CommonSQL documentation avaialble on the Lispworks website: + +Xanalys LispWorks User Guide - The CommonSQL Package +http://www.lispworks.com/reference/lw43/LWUG/html/lwuser-167.htm + +Xanalys LispWorks Reference Manual -- The SQL Package +http://www.lispworks.com/reference/lw43/LWRM/html/lwref-383.htm + +CommonSQL Tutorial by Nick Levine +http://www.ravenbrook.com/doc/2002/09/13/common-sql/ + + +PREREQUISITES + + o COMMON LISP: currently CMUCL, SBCL, Lispworks + o RDBMS: currently Postgresql, Mysql, Sqlite + o ASDF (from http://cvs.sourceforge.net/viewcvs.py/cclan/asdf/) + o CLSQL-2.0.0 or later (from http://clsql.b9.com) + o RT for running the test suite (from http://files.b9.com/rt/rt.tar.gz) + + +INSTALLATION + +Just load clsql-usql.asd or put it somewhere where ASDF can find it +and call: + +(asdf:oos 'asdf:load-op :clsql-usql) + +You'll then need to load a CLSQL backend before you can do anything. + +To run the regression tests load clsql-usql-tests.asd or put it +somewhere where ASDF can find it, edit the file tests/test-init.lisp +and set the following variables to appropriate values: + + *test-database-server* + *test-database-name* + *test-database-user* + *test-database-password* + +And then call: + +(asdf:oos 'asdf:load-op :clsql-usql-tests) +(usql-tests:test-usql BACKEND) + +where BACKEND is the CLSQL database interface to use (currently one of +:postgresql, :postgresql-socket, :sqlite or :mysql). + +