Tksql, layout and more...

Welcome, in these pages you can find applications and libraries (packages for tcl/tk) I developed in the last few years:

tksql: (app) GUI to edit postgreSQL and MySQL tables
tkspy: (app) inspector for tcl application
sdsql: (package) base package for tksql: provides editDb and popSqlQueries
layout: (package) package to make easier creation of layout
sdtcl: (package) general procedures used in sdsql

News

Today (Dec, 28 - 2002) I release the first version of tksql that works both with PostgreSQL and MySQL. I started a job where I need MySQL so I will support both backend database from now. The first public release w/ MySQL support is 0.8.13, I'm still changing it rapidly, but it seems to work pretty well. In order to use it you will need mysqltcl, if you use Debian, just apt-get install mysqltcl.

In this release I also introduced some means to create database and tables. I improved also the part relative to validation of data and support for application specific foreign keys.

In 1999 I started developing application using Tcl-Tk as a front end and PostgreSQL as back end. What I present here is a collection of libraries I developed and used in these years. These scripts are all written in tcl/tk (no C-code). They are being used in a production environment and still undergo a continuos development.

Packages

The best way to understand these packages is to run the examples. You don't need to install them, just download the packages and run the demo from demo dir.

sdtcl: is a package that primarily provides a proc called layout that allows to use a very compact and intuitive "formalism" to create a layout. It does not superceed grid, pack or place ; it uses them but starting from a simple syntax allows one to create widgets and manage them.

sdsql: this package relies on Tktable :

editDb: a proc to pop a tktable to edit a table e.g:
```
editDb -sql "select * from products where code ~'ABC'" -fetch 200
```
TkTable with no more than 200 lines of the result of the sql statement above. opt. -mask allows to have a view in a mask instead of a table. Two views can coexist.
Hooks are provided to trigger validation on row and cell change. Single fields can be turned not editable. Filter capability is provided in very simple way, on the resulting table/mask.
popSqlQuery: a proc to allow completion of field thru query to the database, this is used in bind commands for entries and Tktable.
info on the relation between tables (foreign keys and allowed values) can be written to a special table called attr_info so that popSqlQuery can show allowed values.

Applications

A couple of programs are built up as examples:

tksql: an editor of tables. Can be used from the command line:

$ tksql -db sandro 
$ tksql -db sandro -tbl tel 
$ tksql -host localhost -db erm -sql "select * from area"

tkspy: a debugger. It really only issues a package require sdtcl to a remote application via send and then sends a sd::spy to pop a blt::hierbox to show variable, proc and widget's trees.

Feed-back

I do really appreciate any feed-back, starting from grammatic/syntactic correction up to patches to the code or just comments, and obviously any possible bug-report. My e-mail is: sandro.dentella@tin.it

License

Sdtcl and sdsql are free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation.

Download

Please go to download page.