SQLite

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.

Installation

Download the file indicated as having the TCL bindings to your machine.
Unzip the file in the download -- the zip file has only one file which is a Dynamic Link Library (DLL).
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.
In your TCL script, load this library using the "load" TCL command (e.g: load tclsqlite3).
Start using using SQLite as indicated on this page on the SQLite web-site.

That's it!

Using

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

Create a table (define the fields/records for each row)
Populate the table
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
  Utilities
  Programming Fun?
  SED FAQ
  C Language
  Source Code Browsers
  C Struct Packing
  Walt Disney World
  PPP RFCs
  FSM/HSM
  Tcl/Tk
  Photographs of Flowers
  Random Photogaphs
  Put this on your site!
  SQLite
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
Blog