{rightimage: dbe1.gif}
The TCL module attached (see the "Attachments" section below for
a link to the source code)
implements a convenient graphical SQLite
database editor.  Tcl/Tk programs can make use of this module
as follows:

   source dbedit.tcl
   dbedit::start  db

The "db" argument to "dbedit::start" specifies the SQLite database
object that is loaded into the editor.

The screenshots on this page show the dbedit module being used
on the ExperiementalMailUserAgent.
{clear}
----
{rightimage: dbe2.gif}
Select the table to show in the editor from the optionmenu
in the upper left-hand corner of the editor.
{clear}
----
{rightimage: dbe3.gif}
If you click on any of the column labels, a pop-up menu appears
with the options "Search", "Edit", and "Index".  If you select
"Index" then list of all distinct values for that column appears
at the left.
{clear}
{rightimage: dbe4.gif}
Click on any of the values in the "index" and the next entry
in the table with that value appears at the right.
{clear}
----
Sometimes you might have a column that contains more data
than will comfortably fit in the space provided.  An example
of this is the "blob" table of the ExperimentalMailUserAgent
database - the table that contains the complete text of
email messages.  As you can see, the text does not all fit
in the "data" column.
{clear}
{rightimage: dbe6.gif}
For more convenient editing, choose the "Edit" option from
the "data" column pop-up menu...
{clear}
{rightimage: dbe7.gif}
A multi-line text editor appears that makes editing large
fields much more convenient.
{clear}
----
{rightimage: dbe8.gif}
Type some text into the "Pattern" entry box at the top then
select the "Search" option on a column label to advance to
the new row that contains the pattern text.