Connection SpecificationSyntax of connection-spec
- (hostdbuserpassword)
+ (hostdbuserpassword &optional port)Description of connection-spec
@@ -277,6 +277,13 @@
field.
+
+ port
+
+ String representing the port to use for
+ communication with the MySQL server.
+
+
@@ -583,6 +590,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