Using SQLite With Tcl - Getting Started

Page 9 of 41
[prev] [next]

Interface designed for ease of use

  load ./tclsqlite.so Sqlite3
  sqlite3 db test.db
  db eval {CREATE TABLE t1(a,b,c)}
  db eval {INSERT INTO t1 VALUES(1,2,3)}
  db eval {INSERT INTO t1 VALUES('hello',NULL,'world')}
  db close

You can, of course, use package require instead of an explicit load.

The library defines a single new Tcl command: sqlite3.

Database filenames do not require any particular extension.

Name of the connection is arbitrary

Multiple connections can be open at once