X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fappendix.xml;h=ad2f4ef8961a2e7f48dca30f8f0663a58fe5c8a3;hb=f7a356bb4c11d062eeeb5d4aaf4e187a3cb15a27;hp=8ba1baf6eb59b43091e4c8709a66822fc938649c;hpb=967266c94b00f91e5967b8330fe2b9134b0c0447;p=clsql.git diff --git a/doc/appendix.xml b/doc/appendix.xml index 8ba1baf..ad2f4ef 100644 --- a/doc/appendix.xml +++ b/doc/appendix.xml @@ -12,7 +12,7 @@ PostgreSQL Libraries - The PostgreSQL back-end needs access to the PostgreSQL C + The PostgreSQL back-end requires the PostgreSQL C client library (libpq.so). The location of this library is specified via *postgresql-so-load-path*, which defaults @@ -25,7 +25,7 @@ Initialization Use -(asdf:operate 'adsf:load-op 'clsql-postgresql) +(asdf:operate 'asdf:load-op 'clsql-postgresql) to load the PostgreSQL back-end. The database type for the PostgreSQL back-end is :postgresql. @@ -102,6 +102,9 @@ + Notes + None. + @@ -203,13 +206,16 @@ + Notes + None. + MySQL Libraries - The &mysql; back-end needs access to the &mysql; C + The &mysql; back-end requires the &mysql; C client library (libmysqlclient.so). The location of this library is specified via *mysql-so-load-path*, which defaults @@ -274,8 +280,85 @@ + Notes + FDDL + + + + drop-index + requires a table to be specified with the + :on keyword parameter. + + + + + views are not + supported by &mysql;. + + + + + The :transactions keyword argument to + create-table + controls whether or not the created table is an InnoDB + table which supports transactions. + + + + + The :owner keyword argument to the FDDL functions + for listing and testing for database objects is ignored. + + + + + FDML + + + + Prior to version 4.1, &mysql; does not support nested + subqueries in calls to select. + + + + + Symbolic SQL Syntax + + + + &mysql; does not support the || + concatenation operator. Use concat + instead. + + + + + &mysql; does not support the substr + operator. Use substring instead. + + + + + &mysql; does not support the + intersect and + except set operations. + + + + + &mysql; (version 4.0 and later) does not support string + table aliases unless the server is started with + ANSI_QUOTES enabled. + + + + + - + &odbc; @@ -337,6 +420,18 @@ + Notes + FDDL + + + + The :owner keyword argument to the FDDL functions + for listing and testing for database objects is ignored. + + + + + @@ -393,14 +488,19 @@ + Notes + + None. + + &sqlite; Libraries The &sqlite; back-end requires - access to the &sqlite; shared library file. Its default file - name is /usr/lib/libsqlite.so. + the &sqlite; shared library file. Its default file name is + /usr/lib/libsqlite.so. Initialization @@ -432,6 +532,152 @@ + 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 &sqlite;. + + + + + Symbolic SQL Syntax + + + + &sqlite; does not support the all, + some, any and + exists subquery operations. + + + + + + + + + Oracle + + Libraries + The &oracle; back-end requires the &oracle; OCI client + 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. + + + + Initialization + + Use + +(asdf:operate 'asdf:load-op 'clsql-oracle) + + to load the &oracle; back-end. The database type for the Oracle + back-end is :oracle. + + + + Connection Specification + + Syntax of connection-spec + (global-name user password) + + + Description of connection-spec + + + global-name + + String representing the global name of the Oracle database. + This is looked up through the tnsnames.ora file. + + + + user + + String representing the user name to use for + authentication. + + + + password + + String representing the password to + use for authentication.. + + + + + + Notes + Symbolic SQL Syntax + + + + The userenv operator is &oracle; specific. + + + + + &oracle; does not support the except + operator. Use minus instead. + + + + + &oracle; does not support the all, + some, any + subquery operations. + + + + + Transactions + + + + By default, &clsql; starts in transaction AUTOCOMMIT mode + (see set-autocommit). + To begin a transaction in autocommit mode, start-transaction + has to be called explicitly. + + + + +