PostgreSQLLibraries
- 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 @@
InitializationUse
-(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.
+ MySQLLibraries
- 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;LibrariesThe &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,166 @@
+ 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.
+
+
+
+ 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)
+
+
+
+
+ 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-nameuserpassword)
+
+
+ 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.
+
+
+
+
+