Index

What is This?

TkSQLite is a GUI database manager for SQLite implemented by Tcl/Tk. It can manage SQLite version2.8 and SQLite version3.x database. And it can handle many encodings like Shift-JIS, EUC-JP and Windows native milti-byte encodings not only UTF-8. And it can run on Windows and Linux and MacOSX as native Look & Feel. And it's Freeware.

Features

Requirements

NOTE:
Tablelist4.5+ is still required by tksqlite 0.4. But tksqlite 0.5 requires Treectrl2.1+ instead of Tablelist.

ActiveTcl has all of these precompiled extensions. I really recommend to install it if you are not familiar with tcl/tk environment.

Uninstall

remove tksqlite.tcl and, rm ~/.tksqlite on linux or %APPDATA%/tksqlite/.tksqlite on windows

License

New BSD style license.

Screenshot

ver0.5 English version on Vista

TkSQLite version 0.5 on Vista


ver0.4 Japanese version on Linux

TkSQLite version 0.4 on FedoraCore1

Download

Note: Please take care of compatibility of file format.
see also
http://www.sqlite.org/changes.html
http://www.sqlite.org/formatchng.html

Update History

How to use

Create Table and Index

Key Binding

Import/Export CSV

Functions

TkSQLite have many user functions emulated some other DB's functions. See SQLite user function.

Loading tcl script functions.

tksqlite 0.5 can load tcl script functions. The interface is tclsqlite. You can access the db command. It is just a sqlite database command. But don't use another sub commands except for db function, because the command is used by tksqlite. Don't rename and free the command too.

The loading process is

  1. db is opened.
  2. default sqlite functions is installed.
  3. registerd tcl scripts are sourced.

Example:
plus.tcl

proc plusProc {a b} {
    if {[string is double $a] && [string is double $b]} {
        return [expr {$a + $b}]
    }
    return [append a $b]
}
db function plus plusProc

Register this script in Preference Dialog, and check Enable. Then open a database file and You can use the plus func.

select plus(1,1)

returns 2

select plus(1, 'abc')

returns '1abc'

One Line Comment



CategoryTclTk CategorySoft CategoryEnglish


|New|Edit|Freeze|Diff|History|Attach|Copy|Rename|
Last-modified: 2024-01-25 (Thu) 04:08:15
HTML convert time: 0.090 sec.