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 the file name of
the database. The side effect of tdbc::sqlite3::connection
create is to create a new database connection.. 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.
tdbc, tdbc::connection, tdbc::resultset, tdbc::statement
TDBC, SQL, SQLite3, database, connectivity, connection
Copyright (c) 2008 by Kevin B. Kenny.