Tdbc Documentation > Tdbcsqlite3 > tdbc_sqlite3

Tcl Database Connectivity | TDBC-ODBC Bridge | TDBC driver for Sqlite3 | TDBC driver for Mysql | Tcl Database Connectivity C API

NAME

tdbc::sqlite3 - TDBC driver for the SQLite3 database manager

SYNOPSIS

package require tdbc::sqlite3 1.0
tdbc::sqlite3::connection create db fileName ?-option value...?

DESCRIPTION

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.

CONFIGURATION OPTIONS

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.

SEE ALSO

tdbc, tdbc::connection, tdbc::resultset, tdbc::statement

KEYWORDS

TDBC, SQL, SQLite3, database, connectivity, connection

COPYRIGHT

Copyright (c) 2008 by Kevin B. Kenny.