X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=doc%2Fappendix.xml;h=a37c582a9459f1f2e012c45df0ac0f2d07a39f0f;hp=d6a50d9cf8aa5b4164e0aef5243564a5ea7899c5;hb=d529146041f6265030edc25c735e063ebfdbd285;hpb=46525a14e41672ba3daaf79c68fdc413e47c4fd0
diff --git a/doc/appendix.xml b/doc/appendix.xml
index d6a50d9..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