XOSql

ATKSqlBrowser - graphical sql-query browser

XOTclIDE - new life for Tcl.

interactive

instrospective

object oriented

syntax checking

version control

Provided functionality

use-friendly connection dialog
word completion in edit area
view of base database schema (double click insert the word into edit area)
view result-rows in table

Supported database connections

mysql
postgres
sqlite
ODBC (in executables only by windows)

Downloads

atksqlbrowser02.exe Windows Executable (no installation required)
atksqlbrowser02.bin Linux x86 executables (no installation required)
atksqlbrowser02.kit tclkit package (see more tclkit wrapping)
atksqlbrowser02.tar.gz source code

ATKSqlBrowser was primary developed as plug-in for XOTclIDE and use internal XOTcl general sql-access library XOSql

Limitation of binary versions.

Windows executable do not contain postgres tcl-interface.
Postgres on Linux need additional postgres client libraries.
Linux version do not can not ODBC (do not contain Linux version of tclodbc)

Screen shoots

value of every cell can be displayed in separated window (menu Edit-Show Cell In Separated Window)
Cell Window

Limitation

ATKSqlBrowser try to receive all rows at once. Big dataset (more than 1000 rows) can overload the program and cause performance problems. The send sql statement can not be stopped.

Requirements for source code using

Tcl and Tk environment - Tcl
XOTcl
TkTable
One from base tcl interfaces
- mysql mysqltcl
- ODBC tclodbc
- sqlite sqlite
- postgres pgtcl

Author and License

The program was written by Artur Trzewik and is GNU Public License Software.

Artur Trzewik

Last modified: Sat Apr 3 07:58:53 CEST 2004