From d529146041f6265030edc25c735e063ebfdbd285 Mon Sep 17 00:00:00 2001 From: "Kevin M. Rosenberg" Date: Tue, 9 Nov 2004 18:04:31 +0000 Subject: [PATCH] r10147: 09 Nov 2004 Kevin Rosenberg * Version 3.1.0 released: New SQLite3 backend by Aurelio Bignoli * doc/appendix.xml: Document SQLITE3 backend, patch by Aurelio Bignoli --- ChangeLog | 8 +- debian/changelog | 6 + doc/appendix.xml | 112 ++++++++++++++++++ doc/entities.inc | 3 +- doc/intro.xml | 4 +- .../sqlite3/init-func}/Makefile | 0 .../sqlite3/init-func}/example.lisp | 0 .../sqlite3/init-func}/iso-8859-15-coll.c | 0 8 files changed, 127 insertions(+), 6 deletions(-) rename {db-sqlite3/init-func-sample => examples/sqlite3/init-func}/Makefile (100%) rename {db-sqlite3/init-func-sample => examples/sqlite3/init-func}/example.lisp (100%) rename {db-sqlite3/init-func-sample => examples/sqlite3/init-func}/iso-8859-15-coll.c (100%) diff --git a/ChangeLog b/ChangeLog index edf6b8a..bc897d2 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,10 +1,10 @@ 09 Nov 2004 Kevin Rosenberg - * sql/operations.lisp: Add lower and upper SQL - functions from Daniel Lowe. + * Version 3.1.0 released: New SQLite3 backend by Aurelio Bignoli + * doc/appendix.xml: Document SQLITE3 backend, patch by Aurelio Bignoli + * sql/operations.lisp: Add lower and upper SQL functions [Daniel Lowe]. 08 Nov 2004 Kevin Rosenberg - * sql/expressions.lisp: Fix slot name [thanks to - Daniel Lowe] + * sql/expressions.lisp: Fix slot name [thanks to Daniel Lowe] 31 Oct 2004 Kevin Rosenberg * clsql-sqlite3, db-sqlite3/*: NEW BACKEND diff --git a/debian/changelog b/debian/changelog index 30b11d5..e4cc865 100644 --- a/debian/changelog +++ b/debian/changelog @@ -1,3 +1,9 @@ +cl-sql (3.1.0-1) unstable; urgency=low + + * New upstream + + -- Kevin M. Rosenberg Tue, 9 Nov 2004 11:04:04 -0700 + cl-sql (3.0.11-1) unstable; urgency=low * New usptream 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; + + Libraries The &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 diff --git a/doc/entities.inc b/doc/entities.inc index 496d956..25ef73e 100644 --- a/doc/entities.inc +++ b/doc/entities.inc @@ -10,7 +10,8 @@ CommonSQL"> MySQL"> PostgreSQL"> -SQLite"> +SQLite version 2"> +SQLite version 3"> Oracle"> ODBC"> AODBC"> diff --git a/doc/intro.xml b/doc/intro.xml index ea59c4b..5f1ff00 100644 --- a/doc/intro.xml +++ b/doc/intro.xml @@ -42,7 +42,8 @@ Optimized loading of integer and floating-point fields. - Additional database backends: &odbc;, &aodbc;, and &sqlite;. + Additional database backends: &odbc;, &aodbc;, &sqlite; + and &sqlite3;. A compatibility layer for &cmucl; specific code. @@ -131,6 +132,7 @@ &postgresql; v7.4 with both direct API and TCP socket connections. &sqlite;. + &sqlite3;. Direct &odbc; interface. &oracle; OCI. Allegro's DB interface (&aodbc;). diff --git a/db-sqlite3/init-func-sample/Makefile b/examples/sqlite3/init-func/Makefile similarity index 100% rename from db-sqlite3/init-func-sample/Makefile rename to examples/sqlite3/init-func/Makefile diff --git a/db-sqlite3/init-func-sample/example.lisp b/examples/sqlite3/init-func/example.lisp similarity index 100% rename from db-sqlite3/init-func-sample/example.lisp rename to examples/sqlite3/init-func/example.lisp diff --git a/db-sqlite3/init-func-sample/iso-8859-15-coll.c b/examples/sqlite3/init-func/iso-8859-15-coll.c similarity index 100% rename from db-sqlite3/init-func-sample/iso-8859-15-coll.c rename to examples/sqlite3/init-func/iso-8859-15-coll.c -- 2.34.1