X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fintro.xml;h=346ead3693b5bfa950fbe87f947676cca9184cde;hb=1564d97ae25555b0d4f597316a42d0b7419de846;hp=facffa7f67dbf08ef4bd9ed09d0af93274a26f3e;hpb=bd57425b302d5c2e52732545f3f354a2f5f471cf;p=clsql.git diff --git a/doc/intro.xml b/doc/intro.xml index facffa7..346ead3 100644 --- a/doc/intro.xml +++ b/doc/intro.xml @@ -23,14 +23,14 @@ 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: + on Pierre R. Mai's excellent &maisql; package. The main changes + from &maisql; are: - Optimized loading of integer and floating-point fields. + port from the &cmucl; FFI to &uffi;. - port from the &cmucl; FFI to &uffi;. + Optimized loading of integer and floating-point fields. new &acl; ODBC interface back-end. @@ -39,7 +39,8 @@ 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. @@ -59,34 +60,30 @@ &asdf; - &clsql; uses &asdf; to compile and load its - components. &asdf; is included in the &cclan; collection. + + &clsql; uses &asdf; to compile and load its components. + &asdf; is included in the &cclan; + collection. &uffi; - &clsql; uses &uffi; - as a Foreign Function Interface (FFI) to support multiple &cl; - implementations. + + &clsql; uses &uffi; + as a Foreign Function Interface + (FFI) to support + multiple &cl; implementations. - - You can download &uffi; from its FTP site. There - are zip files for Microsoft Windows systems and gzipped tar files for - other systems. - &md5; &clsql;'s postgresql-socket interface uses Pierre Mai's md5 - module. If you plan to use - this interface please download the md5 module from ftp://clsql.b9.com. + module. @@ -100,7 +97,7 @@ &lw; v4.3 on Debian Linux and Microsoft Windows XP. &cmucl; 18e on Debian Linux, FreeBSD 4.5, and Solaris 2.8. &sbcl; 0.8.5 on Debian Linux. - &scl; 1.2 on Debian Linux. + &scl; 1.1.1 on Debian Linux. &openmcl; 0.14 on Debian Linux PowerPC. @@ -111,9 +108,11 @@ Currently, &clsql; supports the following databases: - &mysql; v3.23.51. - &postgresql; v7.2 with both direct API and TCP socket connections. - Allegro's ODBC interface (&aodbc;) using iODBC ODBC manager. + &mysql; v3.23.51 and v4.0.15. + &postgresql; v7.2 with both direct API and TCP + socket connections. + Allegro's ODBC interface (&aodbc;) using iODBC + ODBC manager. @@ -139,7 +138,7 @@ implementations do not support 64-bit integers. Thus, C helper libraries are required to break these 64-bit integers into two compatible 32-bit integers. The helper libraries reside in the directories - uffi/ and db-mysql. + uffi and db-mysql. @@ -156,10 +155,15 @@ &unix; - Files named Makefile are supplied for building the libraries - under &unix;. However, the .asd automatically invoke - the makefiles when necessary. So, manual building of the helper libraries - is not necessary on &unix;. + Files named Makefile are supplied for + building the libraries under &unix;. Loading the + .asd files automatically invokes + make when necessary. So, manual + building of the helper libraries is not necessary on most + &unix; systems. However, the location of the &mysql; library + files and include files may need to adjusted in + db-mysql/Makefile on non-Debian + systems. @@ -183,13 +187,14 @@ Load &md5; module - If you plan to use the clsql-postgresql-socket interface, you must load the md5 module. - Unzip or untar the cl-md5 distribution, which creates a directory for the cl-md5 files. - Add that directory to &asdf;'s asdf:*central-registry*. - You can do that by pushing the pathname of the directory onto this variable. - The following example code assumes the cl-md5 files reside in the - /usr/share/lisp/cl-md5/ - directory. + If you plan to use the clsql-postgresql-socket interface, you + must load the md5 module. Unzip or untar the cl-md5 + distribution, which creates a directory for the cl-md5 files. + Add that directory to &asdf;'s + asdf:*central-registry*. You can do that by + pushing the pathname of the directory onto this variable. The + following example code assumes the cl-md5 files reside in the + /usr/share/lisp/cl-md5/ directory. (push #P"/usr/share/lisp/cl-md5/" asdf:*central-registry*) (asdf:operate 'asdf:load-op :md5) @@ -200,21 +205,24 @@ Load &clsql; modules - Unzip or untar the &clsql; distribution which creates a directory - for the &clsql; files. Add that directory to &asdf;'s asdf:*central-registry*. - You can do that by pushing the pathname of the directory onto this variable. - The following example code assumes the &clsql; files reside in the - /usr/share/lisp/clsql/ - directory. You need to load, at a minimum, - the main :clsql system and at least one interface system. + Unzip or untar the &clsql; distribution which creates a + directory for the &clsql; files. Add that directory to &asdf;'s + asdf:*central-registry*. You can do that by + pushing the pathname of the directory onto this variable. The + following example code assumes the &clsql; files reside in the + /usr/share/lisp/clsql/ directory. You need + to load, at a minimum, the main clsql system + and at least one interface system. The below example show loading + all &clsql; systems. + (push #P"/usr/share/lisp/clsql/" asdf:*central-repository*) -(asdf:operate 'asdf:load-op 'clsql-base) ; base clsql package -(asdf:operate 'asdf:load-op 'clsql-mysql) ; MySQL interface -(asdf:operate 'asdf:load-op 'clsql-postgresql) ; PostgreSQL interface +(asdf:operate 'asdf:load-op 'clsql-base) ; base CLSQL package +(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-aodbc) ; Allegro ODBC interface -(asdf:operate 'asdf:load-op 'clsql) ; main clsql package +(asdf:operate 'asdf:load-op 'clsql-aodbc) ; Allegro ODBC interface +(asdf:operate 'asdf:load-op 'clsql) ; main CLSQL package @@ -222,12 +230,13 @@ Run test suite - After loading &clsql;, you can execute the test suite. A configuration - file named .clsql-test.config must be created - in your home directory. There are instructures on the format of that file - in the tests/tests.lisp file in the &clsql; - source directory. After creating that file, you can run the test suite - with &asdf;: + After loading &clsql;, you can execute the test suite. A + configuration file named + .clsql-test.config must be created in + your home directory. There are instructures on the format of + that file in the tests/tests.lisp file in + the &clsql; source directory. After creating that file, you + can run the test suite with &asdf;: (asdf:operate 'asdf:test-op 'clsql)