tdbc::sqlite3 - TDBC driver for the SQLite3 database manager
package require tdbc::sqlite3 1.0
tdbc::sqlite3::connection create db fileName
?-option value...?
The tdbc::sqlite3 driver provides a database interface that
conforms to Tcl DataBase Connectivity (TDBC) and allows a Tcl
script to connect to a SQLite3 database. It is also provided as a
worked example of how to write a database driver in Tcl, so that
driver authors have a starting point for further development.
Connection to a SQLite3 database is established by invoking
tdbc::sqlite3::connection create, passing it a string to be
used as the connection handle followed by the file name of the
database. The side effect of tdbc::sqlite3::connection
create is to create a new database connection.. As an
alternative, tdbc::sqlite::connection new may be used to
create a database connection with an automatically assigned name.
The return value from tdbc::sqlite::connection new is the
name that was chosen for the connection handle. See
tdbc::connection(n) for the details of how to use the
connection to manipulate a database.
The standard configuration options -encoding,
-isolation, -readonly and -timeout are all
recognized, both on tdbc::sqlite3::connection create and on
the configure method of the resulting connection.
Since the encoding of a SQLite3 database is always well known,
the -encoding option accepts only utf-8 as an
encoding and always returns utf-8 for an encoding. The
actual encoding may be set using a SQLite3 PRAGMA statement
when creating a new database.
Only the isolation levels readuncommitted and
serializable are implemented. Other isolation levels are
promoted to serializable.
The -readonly flag is not implemented. -readonly 0
is accepted silently, while -readonly 1 reports an
error.
If any column name is not unique among the columns in a result set,
the results of -as dicts returns will be missing all but the
rightmost of the duplicated columns. This limitation can be worked
around by adding appropriate AS clauses to SELECT
statements to ensure that all returned column names are unique.
Plans are to fix this bug by using a C implementation of the
driver, which will also improve performance significantly.
tdbc, tdbc::connection, tdbc::resultset, tdbc::statement
TDBC, SQL, SQLite3, database, connectivity, connection
Copyright (c) 2008 by Kevin B. Kenny.
