Wisql is a simple Tk GUI for interacting with SQL
RDBMS like Sybase and Postgres. Tom Poindexter is the original author,
but in 1992 or 1993 I came along and added some features to make wisql
suitable for use by the SQL-illiterate.Wisql is a simple Tk GUI for interacting with SQL
RDBMS like Sybase and Postgres. Tom Poindexter is the original author,
but in 1992 or 1993 I came along and added some features to make wisql
suitable for use by the SQL-illiterate.
If you want to know what Wisql looks like, go visit the Wisql Photo Gallery. You'll find a series of screendumps with a little narration tying them together. A picture is worth many hundreds of words.
Wisql is not particularly tricky. Most of it is pretty basic Tcl/Tk coding. In fact, my portions at least are overdue for a major re-write, since it was my first Tk project. However, it has stood up well under heavy use here and at several other sites.
Wisql comes with a Tcl proc library called ucodb.tlib, a general-purpose toolkit for people doing database hacking with Tcl. You may want to get a copy of Wisql just for that library: the library has high-level procs for Sybase, Oracle, and Postgres SQL transactions, making it easier to port apps between the three DB. It has string filtering and string 'fixing' routines, and various other 'swiss army knife' goodies that may make your programming life easier or provide useful example code.
Wisql also comes with Sybase PerfMeter and sybdump, minor tools but handy ones if you have a Sybase server. Syperf is a perfmeter for Sybase dataserver. Sybdump is an ASCII Sybase data/DDL dump tool. It's nowhere near as good as the commercial product reSQL from Platinum Software (used to be Elmwood Info Sys), but it will preserve basic DDL or extract it for you to alter, and it extracts data (using bcp) quite reliably. Sybdump comes in handy when you have to do major surgery on a table; you can extract the data and the DDL, hack on both, and then redefine and reload fairly easily. In the bad old days Sybase's dump utility was binary and would only direct itself to a local tape drive. I hear things are better now with Sys12, but sybdump might still be useful...
Wisql is free. Just pick up the Wisql Distribution from us, and please note the COPYRIGHT.