SQLite

Appendix G. Tcl Interface Reference

This appendix lists the Tcl commands that are used to communicate with a SQLite database.

The Tcl Library

The Tcl library for SQLite is called libtclsqlite.so on Unix platforms and sqlite.dll on Windows systems. The library file should reside in a location that your scripts will be able to load from. Typically this would be a subdirectory of /usr/share/tcl on Unix or C:\tcl\lib on Windows.

In this appendix, commands from the Tcl library are shown first, followed by the explanation.

package require sqlite

Imports the sqlite package into a Tcl script.

Opening and Closing a Database

sqlite dbcmd database-name

Opens a database called database-name—either from the current directory or referenced via a relative or absolute ...