Web www.grok2.com
grok2.gif (391 bytes)




From it's web-site, "SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine". SQLite is by D. Richard Hipp and you can find out more about it here.

The part that interested me was that there are TCL bindings to this library so that you can use it directly from a TCL application. This page is basically some notes I made when playing around with the TCL bindings. All my experimentation was on Microsoft Windows.

A basic guide to using the TCL bindings is here on the SQLite web-site.


  1. Download the file indicated as having the TCL bindings to your machine.
  2. Unzip the file in the download -- the zip file has only one file which is a Dynamic Link Library (DLL).
  3. Extract this file into the "bin" directory of your TCL installation (where the tclsh or wish binary is present). Alternatively you can also put the file in the "lib" directory under the TCL installation or any directory listed in the PATH environment variable.
  4. In your TCL script, load this library using the "load" TCL command (e.g: load tclsqlite3).
  5. Start using using SQLite as indicated on this page on the SQLite web-site.

That's it!


As a novice to databases, I assume, the steps you will need are:

  1. Create a table (define the fields/records for each row)
  2. Populate the table
  3. Add/Edit/Delete entries in the table

You can do all this using SQL embedded in the TCL script via the 'eval' command. See SQLite manual for more info.

Site Links
  The Books I Own
  Main Page
  Vi in Emacs
  Linux on Vaio
  Study NZ
  Programming Fun?
  C Language
  Source Code Browsers
  C Struct Packing
  Walt Disney World
  Photographs of Flowers
  Random Photogaphs
  Put this on your site!
  The Sundial Bridge
  Repetitive Strain Injury (RSI)
  Selling Software Online (MicroISV)
  Tcl Tk Life-Savers
  The Experience Shows!
  Green Tips
  .htaccess tricks
  Web-Site Development Online Tools




Site copyright of domain owner. All rights reserved.