X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fappendix.xml;h=a37c582a9459f1f2e012c45df0ac0f2d07a39f0f;hb=211b900e9229737168224258d58be490e58b22f9;hp=ad2f4ef8961a2e7f48dca30f8f0663a58fe5c8a3;hpb=f7a356bb4c11d062eeeb5d4aaf4e187a3cb15a27;p=clsql.git
diff --git a/doc/appendix.xml b/doc/appendix.xml
index ad2f4ef..a37c582 100644
--- a/doc/appendix.xml
+++ b/doc/appendix.xml
@@ -583,6 +583,118 @@
+
+ &sqlite3;
+
+ LibrariesThe &sqlite3; back-end requires
+ the &sqlite3; shared library file. Its default file name is
+ /usr/lib/libsqlite3.so.
+
+
+ Initialization
+
+ Use
+
+(asdf:operate 'asdf:load-op 'clsql-sqlite3)
+
+ to load the &sqlite3; back-end. The database type for the &sqlite3;
+ back-end is :sqlite3.
+
+
+
+ Connection Specification
+
+ Syntax of connection-spec
+ (filename &optional init-function)
+
+
+ Description of connection-spec
+
+
+ filename
+
+ String representing the filename of the &sqlite3;
+ database file.
+
+
+
+ init-function
+
+
+ A function designator.
+ init-function takes a
+ single argument of type
+ sqlite3:sqlite3-db, a foreign pointer to
+ the C descriptor of the newly opened database.
+ init-function is called by
+ the back-end immediately after &sqlite3;
+ sqlite3_open library function,
+ and can be used to perform optional database
+ initializations by calling foreign functions in the
+ &sqlite3; library.
+
+
+ An example of an initialization function which
+ defines a new collating sequence for text columns is
+ provided in
+ ./examples/sqlite3/init-func/.
+
+
+
+
+
+
+ Notes
+ Connection
+
+
+
+ Passing filename a value of
+ :memory: will create a database in
+ physical memory instead of using a file on disk.
+
+
+
+
+ Some operations will be many times faster if database
+ integrity checking is disabled by setting the SYNCHRONOUS
+ flag to OFF (see the SQLITE manual for details).
+
+
+
+
+ FDDL
+
+
+
+ The :owner keyword argument to the FDDL functions
+ for listing and testing for database objects is ignored.
+
+
+
+
+ The :column-list keyword argument to
+ create-view
+ is not supported by &sqlite3;.
+
+
+
+
+ Symbolic SQL Syntax
+
+
+
+ &sqlite3; does not support the all,
+ some, any and
+ exists subquery operations.
+
+
+
+
+
+
+
Oracle
@@ -591,9 +703,23 @@
library. (libclntsh.so). The location of
this library is specified relative to the
ORACLE_HOME value in the operating system
- environment. &clsql; has tested sucessfully using the client
- library from Oracle 9i and Oracle 10g server installations as
- well as Oracle's 10g Instant Client library.
+ environment.
+
+
+
+ Library Versions
+
+ &clsql; has tested sucessfully using the client library from
+ Oracle 9i and Oracle 10g server installations as well as
+ Oracle's 10g Instant Client library. For Oracle 8 and earlier
+ versions, there is vestigial support by pushing the symbol
+ :oci7 onto cl:*features*
+ prior to loading the clsql-oracle &asdf;
+ system.
+
+ (push :oci7 cl:*features*)
+ (asdf:operate 'asdf:load-op 'clsql-oracle)
+