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

  • Support SQLite2.8 and SQLite3.x db.
  • Support many encodings not only utf-8.
  • Edit table with grid table.
  • Change table schema.
  • Show images in BLOB data.(Sqlite3)
  • Syntax keyword hilighting.
  • Native Look & Feel.
  • Japanese and English locale.
  • Many functions (md5, sha1, des, etc. see SQLite user function)
  • Run on any platform Tcl/Tk can.
  • Attach and Detach Database.
  • Export and Import CSV.
  • Dump a database to SQL.
  • Support loadable extension.

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

  • 0.1.0 (2004-01-14)
  • 0.2.1 (2005-11-04)
    • Fix table bug "PRAGMA" result was not shown
    • Fix syntax hilighting bug
    • Fix index property bug
  • 0.2.2 (2005-11-18)
    • Fix syntax hilighting bug
    • Fix selection of attached database bug
    • FIxed bug of grid table's insert row mode.
  • 0.2.3 (2005-11-21)
    • Fix grid table bug that deleting row makes rowid shifts.
  • 0.2.4 (2005-11-26)
    • Fix encoding bug, data was garbled, when euc-jp on sqlite3.
  • 0.3 (2005-12-04)
    • Create Table Dialog, Create Index Dialog and Preference Dialog.
    • Improvement of Look & Feel.
    • Sort Grid Table command.
    • Search Dialog for Grid Table.
    • Add Option of Vi like keybind for Grid Table.
    • Attach/Detach db menu.
    • Import/Export SQL and CSV(or Tab)
    • Add many db functions(regexp, regsub, md5 etc).
  • 0.3.1 (2005-12-14)
    • A Project name was renamed to TkSQLite.
    • Fix a csv import bug that a data having single quote char causes error.
    • Fix a session bug that TkSQLite wasn't able to recover correct window position on Windows.
    • Fix a editor bug that brace char causes a error.
  • 0.3.2 (2006-06-08)
    • Made Standalone binary version.
    • Unified Japanese and English version. Locale is automatically selected now.
    • Fix sqlite init bug.
  • 0.4.0 (2006-08-04)
    • Require dict, Trf, tablelist and tkImg packages.
    • Improvement of Keyword Highlight.
    • Improvement of Preference, CreateTable and CreateIndex Dialogs.
    • Add 3.x compatible format mode option. (in Preference -> SQLite)
    • Add Cache size Dialog.
    • Add DataEditor Dialog.
    • Enable to change table schema.
    • Enable to view images in BLOB data.(gif, jpeg, png, bmp, ico, tiff, tga, ppm (require tkImg))
    • Speed up base64 encode/decode.
    • New user function compress, decompress, read_file and write_file. (see SQLite user function)
    • Add binary mode to crypt user function (md5, sha1, base64_encode, etc). (see SQLite user function)
  • 0.4.1 (2006-08-13)
    • update to sqlite 3.3.7 in executable standalone version
    • Fix a little bug of legacy file format option.
  • (source tcl script isn't modified) (2007-01-11)
    • update to sqlite 3.3.10 in executable standalone version
  • (source tcl script isn't modified) (2007-01-23)
    • update to sqlite 3.3.11 in executable standalone version
  • (source tcl script isn't modified) (2007-01-28)
    • update to sqlite 3.3.12 in executable standalone version
  • 0.4.2 (2007-02-15)
    • Pay attention to utf8/utf16(unicode) byte order mark when importing/exporting text.(thanks to Deneufchatel Renaud)
    • Fix some gui bugs.
    • update to sqlite 3.3.13 in executable standalone version
  • 0.4.3 (2007-03-13)
    • Fix typo of Trf package loading.
    • Improvement of native look & feel on xpnative, winnative, clam(on unix) theme.
    • Readiness for tk8.5a6(or b1?) and tile0.8. tksqlite now works with these last versions. But it is still on the anvil. (thanks to Julian Noble)
    • Fix some gui bugs.
  • (source tcl script isn't modified) (2007-04-05)
    • update to sqlite 3.3.14 in executable standalone version.
    • A tclkit of linux was compiled with thread-enabled option.
  • (source tcl script isn't modified) (2007-04-09)
    • update to sqlite 3.3.15 in executable standalone version.
  • (source tcl script isn't modified) (2007-04-23)
    • update to sqlite 3.3.16 in executable standalone version.
  • (source tcl script isn't modified) (2007-04-29)
    • update to sqlite 3.3.17 in executable standalone version.
  • 0.4.4 (2007-05-25)
    • Improved a behavior of grid-table. If a new row was created and a column had default value, the value would be set instead of empty string.
    • Fixed some startup errors on Mac OS X.
    • Changed Modifier key to be a Command key on Mac OS X.
    • Fixed right-mouse button behavior on Mac OS X. (thanks to Andre Berger!)
    • Changed Shortcuts. Now "Select All" is Ctrl-A. (or Cmd-A on Mac OS X)
    • Fixed and Improved Look and Feel a little.
    • Fixed a garbled string on japanese locale.
    • Improved fonts.
    • Updated Tcl/Tk version in standalone version to 8.5(CVS HEAD. now it was 8.5a7). And The Linux version was compiled as an enable-xft. So you can see anti-aliased font. If you want a standalone without xft, e-mail me or post a comment in this page.
  • 0.4.5 (2007-05-28)
    • Fixed conflict of context menu bindings and default widgets bindings on Mac OS X.(thanks to Andre Berger!)
  • 0.4.6 (2007-06-20)
    • Fixed garbled string inputted by xim on unix, if encoding isn't utf-8.
    • Added cp51932 encoding to standalone version.
    • Updated to sqlite 3.4.0 in executable standalone version.
  • 0.4.7 (2007-07-04)
    • New message dialog, backport from 0.5.0.
    • Fixed bugs, backport from 0.5.0.
      But garbled string when using multibyte encoding (shiftjis, euc-jp, etc) on sqlite3 is not fixed. If the db has the combination, export it on tksqlite0.4, and import the data to new database on tksqlite0.5. If the db is utf-8 on sqlite3 or sqlite2 db is used, this problem didn't occured.
  • 0.5.0 (2007-07-04)
    • Require tktreectrl2.1+ instead of tablelist.
    • Added CreateTrigger Dialog.
    • Added a new file selection dialog ( http://wiki.tcl.tk/15897 ).
    • Improved widgets L&F on WindowsXP at tile0.8.
    • Improved DataEditor Dialog.
    • Enabled to load loadable extension and user tcl script.
    • Enabled to create UTF-16le, UTF-16be database.
    • New message dialog. I avoided to use ttk::dialog. Because I noticed that the ttk::dialog was removed in Tk8.5a7 CVS HEAD. And this dialog shows a long message in textbox.
    • Used tclkit lite to avoid libstdc++ dependency on linux standalone version. I have a bit of concern about the tclkitlite works fine.
    • Updated Tcl/Tk to CVS HEAD used in standalone version.
    • Fixed garbled string when db is multibyte encoding on sqlite3.
    • Fixed sql parser error if "CREATA TABLE" query has "DEFAULT NULL".
    • Fixed delete row error if using multibyte encoding on sqlite3.
  • (source tcl script isn't modified) (2007-07-21)
    • update to sqlite 3.4.1 in executable standalone version.
  • 0.5.1 (2007-08-04)
    • Fixed a little bug building an invalid CREATE TRIGGER query.
    • Fixed a suspicious behavior of a grid table.
    • Improved import/export text dialog. The dialogs can set custom quote and separator.
    • Improved a modify table scheme dialog. When you add a new column to a table and the column has default constraint, the column fillled with the default value.
    • Improved some GUI interface.
  • 0.5.2 (2007-08-14)
    • Fixed odd behavior of a grid table.
    • Fixed a bug that sql parser could not parse DEFAULT clause which has minus number or quoted string.
    • Fixed a but that if "NULL" was enterd in DEFAULT text entry on CreateTable Dialog, the value was not used as string "NULL" but real NULL.
  • (source tcl script isn't modified) (2007-08-16)
    • update to sqlite 3.4.2 in executable standalone version.
  • 0.5.3 (2007-09-04)
    • Improved gui a little.
    • Fixed a conflict between tclsqlite and last Tcl8.5a7 which reformed Var struct.
    • Fixed a text sticking out of cell in grid table. The problem was caused on xft-enabled tk8.5 only.
  • 0.5.4 (2007-09-05)
    • Fixed a bug that CSV(Text) Importer couldn't break out of the infinite loop, if the text had invalid sequence.
    • Fixed a left-over conflict between tclsqlite and last Tcl8.5a7.
    • Improved speed of setting data on grid-table.
  • 0.5.5 (2007-10-08)
    • Updated to sqlite 3.5.1 in executable standalone version
    • Updated to Tcl/Tk 8.5b1 in executable standalone version
    • Refactored a little.
  • (source tcl script isn't modified) (2007-10-12)
    • Fixed a startup error that standalone version for win32 didn't run on WindowsXP.
  • (source tcl script isn't modified) (2007-11-16)
    • update to sqlite 3.5.2 in executable standalone version.
  • 0.5.6 (2007-12-04)
    • Updated to sqlite 3.5.3 in executable standalone version
    • Updated to Tcl/Tk 8.5b3 in executable standalone version
    • Fixed file selection dialog error that called ttk::dialog.
    • Fixed auto_path error when tksqlite is executed by starkit. (but I didn't test it...)
  • (source tcl script isn't modified) (2007-12-15)
    • Updated to sqlite 3.5.4 in executable standalone version.
  • (source tcl script isn't modified) (2008-02-02)
    • Updated to sqlite 3.5.5 in executable standalone version.
    • Updated to Tcl/Tk 8.5.1b1 in executable standalone version.
  • (source tcl script isn't modified) (2008-03-23)
    • Updated to sqlite 3.5.7 in executable standalone version.
    • Updated to Tcl/Tk 8.5.1 in executable standalone version.
  • (source tcl script isn't modified) (2008-07-17)
    • Updated to sqlite 3.6.0 in executable standalone version.
    • Updated to Tcl/Tk 8.5.3 in executable standalone version.
  • 0.5.7 (2008-11-17)
    • updated to sqlite 3.6.5 in executable standalone version.
    • Updated to Tcl/Tk 8.5.5 in executable standalone version.
    • Updated to Tktable2.10 in executable standalone version.
    • Updated to Treectrl2.2.8 in executable standalone version.
    • Updated to Tcllib1.11 in executable standalone version.
    • Fixed a bug, if column name was reserved keyword, "Modify Table schema" Dialog failed to change the column name.
    • Fixed init file ".tksqlite" could not save on Windows Vista, TkSQLite 0.5.7 will read/write the file in %APPDATA%/tksqlite directory on Windows. If you have old .tksqlite, copy it to be %APPDATA%/tksqlite/.tksqlite. It still saved in home directory on other platforms.
    • Enable to set DEFAULT value on "Modify Table schema" Dialog to be CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, expr such like (DATETIME(CURRENT_TIMESTAMP, 'localtime')). Notice that CURRENT_* are allowed only the column type is DATE, TIME, DATETIME or TIMESTAMP only. If another column data type is used, the value will be string 'CURRENT_TIMESTAMP'.
    • If SQL Editor has selection, and you push Ctrl-Enter (Shortcut for execution query), then only the selected range will be executed.
  • 0.5.8 (2009-03-07)
    • updated to sqlite 3.6.11 in executable standalone version.
    • Fixed a bug, grid table's cell editor escaped single quote char twice.
    • Enable to use collation list from sqlite3 pragma collation_list on table schema editor.
  • 0.5.9 (2013-04-27)
    • update to sqlite 3.7.14 in executable standalone version.
    • Enable to build standalone verison for OSX.
    • Change theme to clam on OSX.
    • Drop user defined function left, right.
    • Add user defined function exec.
    • Fixed a bug, failed to get library version on Tcl/Tk 8.6.
    • Fixed a bug, a modal dialog was locked on OSX (aqua windowing system ?).
    • Fixed a bug, 001 was commited as 1 in cell editor.
  • 0.5.10 (2013-07-20)
    • Fixed a bug that table editor points another rowid on linux (sqlite3.7?).
  • 0.5.11 (2014-04-09)
    • Enabled to run Common Table Expressions.
    • Skip loading a function if the function is already exists as sqlite built-in.
    • Add printf function.

How to use

Create Table and Index

  • Create Table
    create table dialog

    create/modify column dialog
  • Create Index
    create index dialog

Key Binding

  • Editor
    Normal keybind
    Ctrl+ReturnExecute sql
    Ctrl-DeleteClear all
  • GridTable
    • Normal mode
      Normal keybind
      Ctrl+nInsert Row
      Ctrl+dDelete Row
      F5Update Grid Table
      Vi keybind
      hMove left
      jMove down
      kMove up
      lMove right
      oInsert row
      slashShow Search Dialog
      ggMove top
      GMove bottom
      uUpdate Grid Table
  • Cell Edit mode
    Normal keybind
    EscapeCancel Editing
    ReturnCommit and move down
    Shift+ReturnCommit and move up
    Ctrl+ReturnCommit
    Alt+ReturnInsert Return
    LeftCommit and move left
    RightCommit and move right
    TabCommit and move next
    Shift+TabCommit and move prev
    Vi keybind
    Ctrl+hCommit and begin editing left
    Ctrl+jCommit and begin editing down
    Ctrl+kCommit and begin editing up
    Ctrl+lCommit and begin editing right
  • Insert new row
    Normal keybind
    EscapeCancel
    ReturnCommit
    Shift+ReturnCommit and move up
    Ctrl+ReturnCommit
    Alt+ReturnInsert
    UpCommit and move up
    DownCommit
    Leftmove left
    Rightmove right
    Tabmove next
    Shift+Tabmove prev
    Vi keybind
    Ctrl+hsame as Left
    Ctrl+jsame as Down
    Ctrl+ksame as Up
    Ctrl+lsame as Right
  • DataEditor(Text) (this binding is enable on tksqlite0.5+)
    Normal keybind
    Ctrl+ReturnUpdate
    Vi keybind
    Ctrl-hMove left grid table cursor
    Ctrl-jMove down grid table cursor
    Ctrl-kMove up grid table cursor
    Ctrl-lMove right grid table cursor

Import/Export CSV

  • Import CSV Dialog
    import csv text dialog
    • If "First Line is Field Name" was checked and an existing table didn't have the field, TkSQLite try to insert empty string or NULL(if the col was integer primary key) to the field.
    • Leading spaces adjacent to separator are trimmed.
    • Fields with embedded separator must be delimited with quote characters.
    • The embedded quote characters must be represented by a pair of quote characters.
  • Export CSV Dialog
    export to csv test dialog

Functions

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

  • Some example
    • perl5 like regexp. (this is Tcl regexp command. see also Syntax of Tcl regular expressions.)
      select * from  t where name regexp "^J.*"
    • regsub(pattern, colname, str). You can use submach pattern like \1 too.
      insert into t 
      select regsub("syo", name, "sho") from t2

      select regsub("(\d{4})(\d{2})(\d{2}).*", "20050401", "\1-\2-\3")
      2005-04-01
  • MD5(requires Tcllib).
    select md5(name) from t
  • read_file
    insert into t values(NULL, 'image test', read_file('c:/tmp/001.gif', 1));

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

  • this script is useful, but 20mb TCL prerequisite is a killer! is it possible to wrap standalone windows version? -- techie 2006-01-09 22:15:07;
  • Thank you. I'll examine that. -- reddog 2006-01-11 15:30:37
  • Hi. Looks like a great peace of software but, as techie said, not really usable beacause of TCL. Good idea, wrong method. -- matthieu 2006-03-09 17:19:50
  • I was going to make standalone until 3.3 came. But I'm hesitating about it now. -- reddog 2006-03-17 01:58:51
  • Excellent work. Would be nice if keywords could be uppercased automatically in addition to colorized. This is SQL, not C. -- mikew 2006-06-22 02:36:29
  • Your standalone executable binary for Windows is excellent. I just loaded 785 mgbyte db with no problems. Quick queries too. Thank you. -- robert 2006-06-26 09:50:57
  • Thanks for the excellent program, very useful. Keep up the good work. -- rjk 2006-07-01 23:57:27
  • Just gets better and better. Domo Arigato for the uppercase SQL keywords and all the other improvements. -- mikew 2006-08-12 02:59:35
  • Thank you for the impressive work. Would be really be able to work with in memory db, fully load a db in memory and offloading the results into a new db -- mario 2006-08-30 21:21:21
  • Really excellent program - if development remains active I expect it will become the most popular SQLite management software -- amnon 2006-11-18 08:05:11
    • I am now observing Tcl/Tk8.5 and some sqlite new features... -- reddog 2006-11-20 22:46:05
  • I have to admit, I am not fan of Tk look, but TkSQLite works great and I have the best sqlite-admin experience of all frontends (linux), THANK YOU! -- macias 2007-01-14 06:20:09
  • Dear Reddog - would you mind if I make a new page on the Tcler's Wiki for tksqlite ? It is by far the nices manager for SQLite I've seen. Thank you. -- AC 2007-01-29 12:49:48
    • No, of course I don't mind that. Please add tksqlite to Tcler's wiki. -- reddog 2007-01-29 21:11:41
  • Page added to Tcler's Wiki - http://mini.net/tcl/TkSQLite -- AC 2007-01-30 11:04:16
  • Looks very nice and Tcl is just the right choice! The 0.4.2 linux standalone .tar.gz is broken :-( -- koloska 2007-01-31 21:59:44
    • There isn't 0.4.2 yet. And I could untar 0.4.1 and 0.3.2. -- reddog 2007-02-01 00:25:55
  • Sorry, 0.4.2 was a false mix of 0.3.2 and 0.4.1. Today the 0.4.1 .tar.gz is fine - thank you! -- koloska 2007-02-01 19:26:04
  • ver0.4.5のツールバーが日本語にならないのですがパッチを作成しないとだめでしょうか? -- jilslay 2007-06-16 14:36:31
    • ツールバーってどの部分のことですか?パッチを作っていただけるならメールで送ってください。あと、OSくらい教えてくれてもいいんじゃないかと思います・・・そこまで隠さなくても -- reddog 2007-06-17 02:40:25
  • 大変失礼いたしました.申し訳ございません OSはwindows xp proです File,database 等が日本語にならないかと思いまして. -- jilslay 2007-06-18 08:50:33
    • 環境変数でLANG=jaしてみてください。 -- reddog 2007-06-18 15:01:10
  • どうもありがとうございます 日本語になりました  -- jilslay 2007-06-20 00:05:10
  • TkSQLite is really great. Thank you + greetings from germany -- Rockford 2007-08-23 17:51:28
  • Nice Nice progrm however recent versions 4.3+ having problems with text bleed in table editor? -- Igo AtM 2007-08-29 23:05:00
    • thank you for the report. Are you using the binary version for linux? Fmm. It seems to me that the cause is tk's xft rendering or tktable's drawing mode... I will check the problem. -- reddog 2007-08-30 16:19:39
  • 2 Quick 4 Me thanks for your reply and yes I have consistantly used the Linux binary. The problem occures when text is selected it over writes local table cells this persists after selection -- Igo AtM 2007-09-01 06:42:22
  • Quick addition Running latest script OK so problem is in the embedded ver thanks -- Igo AtM 2007-09-02 12:31:12
  • the greatest admin for sqlite i ever seen! -- tataremka 2007-09-10 15:42:19
  • Hi! 0.5.5 windows standalone doeasn't work :( -- 2007-10-09 14:19:41
    • oh... It may be side-by-side config info problem. I tested it only w2k and woked fine. I am looking for the solution. -- reddog 2007-10-10 00:09:50
  • dont know if my email reached you:)caouse no answer. it was about new feature: populate datatable with some values.it would be halpful with testing app and db to have possibility to fill tables with lots of data :) -- tataremka 2007-10-10 18:51:55
    • I noticed your email was in spam dir on gmail. sorry, I read it now. It seems to me that the feature is useful to create test data. -- reddog 2007-10-10 22:22:20
  • Hi? i'm only curious you work on populate dialog? :) one idead till now: maybe blobs with given path to file also :):)? -- tataremka 2007-10-23 18:11:31
  • If you get the "cannot find kit pre-init script" error, remember to use the full path to execute. -- Paul 2007-10-25 01:22:00
  • Hi! please look in email (propably in spam as before) with new feature request:) Thanx! -- tataremka 2007-10-29 15:26:35
  • アイコンのデザインがすごく・・・いいです。 -- twister 2007-10-30 22:04:23
  • There is a problem to set default using CURRENT_TIMESTAMP or other standard default, it gets stringfied -- Domingo 2007-11-07 18:33:32
  • Perhaps use external sqlite.dll so tksqlite.exe needs no up2007-11-15 -- Fred 2007-11-15 15:39:52
  • メモリデータベースは対応してないんでしょうか -- clock 2007-11-17 13:12:56
    • してないです。 -- reddog 2007-11-18 21:14:46
  • please set auto_path in interp creation at line 9496/7 "$interp(3) eval [list set auto_path $::auto_path]". Otherwise sqlite is not found in kit files -- rene 2007-11-28 19:00:01
    • Are you talking about tksqlite standalone version? -- reddog 2007-11-28 19:57:32
  • hi. i have tested a lot of sqlite-tools. at the end i only use yours. thank you for your good work. -- Frank 2007-11-30 20:47:54
  • If I try to open an existing database as new in ver0.5.5 binary for Linux I get: invalid command name "ttk::dialog" -- Dimitrios 2007-12-03 01:33:47
    • I fixed it. try 0.5.6. -- reddog 2007-12-04 02:01:46
  • Hey man... the same as others... I have tested many sqlite tools and only your remains... keep going and it will stay on top!... thanks. -- netux 2007-12-08 12:53:26
  • after upgrading to gutsy gibbon tksqlite stopped working (versions: 0.4.5 and 0.5.6). -- Tzury Bar Yochay 2007-12-10 23:35:25
    • What error message did you get ? -- reddog 2007-12-12 00:09:04
  • Thank you for that application. But I have a problem: After upgrading to Ubuntu 7.10 tksqlite does not start - without any message (version 0.5.6 linux). -- josch 2007-12-21 03:19:45
    • I noticed that the ubuntu7.10's new security layer may break upx compressed app... I'm looking for a solution now. -- reddog 2007-12-22 02:19:59
    • "sudo /etc/init.d/apparmor kill" makes tksqlite work. There may be a way to configure the security layer. But I 'm not well versed in the apparmor. -- reddog 2007-12-22 16:09:09
  • OK, now it works again. Thanks -- josch 2007-12-23 21:35:10
  • I tried "sudo modprobe -r apparmor" to unload apparmor, then tksqlite worked. (Ubuntu 7.10) -- Rockford 2007-12-24 01:30:46
  • Changing the folowing code will make a not perfect hack to prevent CURRENT_TIMESTAMP, CURRENT_ to be stringfied. -- Domingo 2007-12-26 21:35:00
    if {$hasdefault == 1} {
        if {![Util::isNumber $defaultvalue]} {
            if {[regexp {current_} [string tolower $defaultvalue]]} {
                set defaultvalue "[string map {' ''} $defaultvalue]"
            } else {
                set defaultvalue "'[string map {' ''} $defaultvalue]'"
            }
        }
        append coldef " DEFAULT $defaultvalue"
    }
  • i think that virtual tables are wrong handled, eg.: create virtual table test using fts3(col1, col2); try insert on that table, it is working but tksqlite show error. and additional fts3 tables should be as subnodes in mention befor 'test' table -- tataremka 2008-02-06 15:08:20
    • What versions of sqlite and tksqlite and fts3 are you using? I noticed that the last fts3 could not load into a db on windows. -- reddog 2008-02-06 22:04:06
  • i'm using the latest one version of tksqlite. i'm suggesting only that you should somehow handle tables depended on virtual one, i mean these created automatically (with sufixes like: _content, _segdir and _segments) by sqlite engine, i think they should be as a subnodes of virtual table (because 'drop table' removes, together with virtual table, those depended tables automatically too. Create virtual table, as i mention prev post, and do some inserts, then you'll see that inserts are executed ok but tksqlite raises some error anyway. -- tataremka 2008-02-07 14:55:29
  • when im adding in grid a new row then error is: "Invalid SQL query: not an error INSERT INTO 'main'.'poem' ("name","text") VALUES ('aaa','aaa');" . But if i refresh table view then new row is added! I think that after querry on virtual tables some other error codes are, dont know what yet. -- tataremka 2008-02-07 15:01:20
    • I confirmed the insert problem now. I'm goin to debug. thank you. And about the second suggestion, these tables are got from sqlite_master, and AFAIK there are no way to know these parent-children relationship. So it seems to me that it is difficult. -- reddog 2008-02-08 00:34:35
  • i cannot create table with CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP default values! evenif i do it with sql editor i cannot add row with it! sqlitemanager insert text 'CURRENT_...' or 'NULL' into grid cell! it has to leave it alone to database or parse it to right datetime or null! i have: CREATE TABLE "test" ( "kol1" TEXT DEFAULT CURRENT_TIMESTAMP, "kol2" TEXT, "kol3" TEXT DEFAULT NULL ) when i use create tabel dialog i get!!!: CREATE TABLE "test" ( "kol1" TEXT DEFAULT ("CURRENT_TIMESTAMP"), "kol2" TEXT, "kol3" TEXT DEFAULT ("NULL") ) even if i do create table with sqleditor to right statement, in the grid is insert wrong default values! here is from sqlite.org from CREATE TABLE help (see paragraph about 'default') : http://www.sqlite.org/lang_createtable.html [^] -- 2008-02-14 22:29:38
    • I know the problem. I'm thinking how express the data type in GUI. If you know SQL, try "Dump SQL" button or "show only" checkbox. These show a sql that tksqlite will do. You can edit it, and then execute it. -- reddog 2008-02-17 23:43:32
  • すばらしいツールです。スタンドアロン版をdebian-etch686,Xubuntu,win2000で試しました。ただ、debian-etch486ではillegal functionで起動できません.tcl8.4をいれてtclソースで起動するとdictエラーなどが出ます。tclのライブラリがどこか教えていただけますか。 -- tkato 2008-02-15 15:54:06
    • Requirementsを見てください。 -- reddog 2008-02-17 23:43:32
  • can u pls help me install 0.5.6 on mac os x leopard... having troubles/didn't have problems on tiger (used wish), thx 4 help -- standa 2008-03-07 03:47:51
    • Sorry I can't help you, because I dont have the machine. -- reddog 2008-03-10 22:26:40
  • いいツールです。デザインも素敵ですね。win xp pro ですがメニュー以外の日本語が勝手にHG丸ゴシック?になってしまうのですが・・? -- css 2008-03-21 00:56:59
  • ↑自己解決。個人的に入れたAIKOフォントが使われていましたので削除したら標準のフォントになりました。どういう優先順位で使われるか不明ですが。 -- css 2008-03-22 02:19:23
  • I love the application! And the tcl/tk programming is impressive! -- bweiss 2008-04-05 19:36:51
  • expected floating-point number but got "0,0151917" decimal separator is "," -- Fred 2008-04-11 20:47:49
  • Just trying it out, looks useful. Question, got empty string instead of expected Null for skipped Integer column when using Table Edit/Insert New Row. -- ARG 2008-04-12 04:36:43
  • If column name is reserved word eg. "references" then it can't modify table schema, because of "Failed to parse SQL" You should safe column enclose in [ ] in SQL Commands -- v 2008-10-14 15:21:31
  • script errors on my Mac PowerBook "can't find package dict" I'm running tclsh & wish 8.4 -- George Jempty 2008-12-06 08:27:49
    • TkSQLite requires some extensions. See Requirements -- reddog 2008-12-06 12:26:14
  • 【バグ報告です】(スタンドアロン版 ver 0.5.7,WindowsXP) データの中でシングルクォーテーション(')を使っている場合、ファイルを閉じたり別のテーブルを表示させたりすると、(')の数が増えてしまいます。例:(')→(),()→('''') 一度増えたらもう変化しないようですが…。 -- sutara_lumpur &2009-02-26 17:35:16
    • 報告ありがとうございます。確認しました。調べて直したいと思います。 -- reddog 2009-03-02 23:04:27
  • expected floating-point number but got "0,015738" while executing ".table.f.y set 0 0,015738" (vertical scrolling command executed by table) decimal separator is "," -- fred 2009-04-09 22:46:06
  • on mac: can't rename to "ttk::_scrollbar": command already exists -- standa 2009-04-10 15:59:08
  • Problem with table edit. Correct me if I am incorrect, modifying a table deletes its indices. -- PaulPaul 2009-05-04 04:48:11
  • 便利なツールありがとうございます!せっかくなのでtcl一式からexeバイナリ作ってみたいですが、この方法については何を参照すればよいでしょうか。 -- Apico 2009-08-31 21:46:33
  • hi,after upgrading to ubuntu 9.10 (karmic) tksqlite doesn't start with the message 'Killed'. apparmor is not installed. -- josch 2009-10-04 20:32:18
  • Is it possible to make available a 64bit binary for Linux? -- Robert 2009-11-19 07:32:33
  • Hi, I tried many sqlite managers, this one is my favorite. I suggest you add a function to run shell commands and capture their output. Thanks for this nice tool. -- alex 2010-04-16 01:25:28
  • I tried to used the functions left and right but I receive this error near "(": syntax error. The mid functions seems to work, I will use it until you check this. Thank you -- alex 2010-04-16 02:07:28
  • The windows standalone executable is an excellent tool. I am using this tool regularly, without any problems. Thanks for this excellent contribution -- Kaustav 2010-07-01 16:24:56
  • Warning! Missing option "if not exists" in Create Table Statement for avoid ... Nice Work, goes on ! -- LAM 2010-09-11 14:05:55
  • Is there a chance that you will further develop this great tool? Appeared in subsequent versions of SQLite, and TKSqlite stopped at version 3.6.11 (0.5.8 / 2009-03-07 /). -- Tumitak 2010-09-14 18:31:39
  • Get up to date binary versions at http://sourceforge.net/projects/kbskit/files under kbs -- rene 2010-10-29 15:37:39
  • SJISに対応してくれていたので死ぬほど助かりました…本当にありがとうございます。 -- めそ &2010-12-10 04:57:18
  • blobに画像ファイル格納してみたんですが動作が重くなったようなデータを全部表示しようとしている?pcが非力なだけ? -- waw 2011-03-14 18:45:46
  • Anyone got a compiled Mac OS X version available? -- andy 2011-04-06 13:53:24
  • Could you please update standalone version with SQLite 3.7? Firefox 4 uses WAL in places.sqlite. -- lpp 2011-04-07 17:20:48
  • TEXTのカラムに'0001'と入力すると'1'で保存されてしまいます。F4キーのデータ編集ウィンドウで入力すれば大丈夫なのですが。 -- 2011-04-15 10:54:00
  • 環境変数LANG = jani -- 2011-06-15 20:09:43
  • 環境変数ちゃんと設定したのになぜか日本語にならないのですが・・・ win7の64bitです -- 2011-06-15 20:14:41
  • I have created a fork of TkSQLite with wxSQLite AES 128bit encrypted database support. https://github.com/yyamasak/TkSQLite-AES128 -- yusuke 2012-03-06 19:32:06
  • Please change line 14708 from "Cmd::openDB [file normalize [file join $_startdir $_file]]" to "Cmd::openDB [file normalize [file join $::starkit::topdir .. $_file]]" to properly work inside starkits. -- rene 2012-05-18 20:54:32
  • Very, very useful. Thank you for your hard work. -- mikeh 2012-07-13 18:07:59
  • It would be nice to be able to manually select the locale. I prefer my tools not to second guess me when it comes to running on Japanese OS. Other than that, it is quite nice. -- Bunny 2012-08-08 13:48:14
  • I like it, very usefull, but facing issue since I switched to Tcl 8.6. BRs -- sebastien 2013-04-04 14:36:01
    • I have confirmed some reported bugs, I intend to fix the bugs in the near future. -- reddog 2013-04-04 15:21:19
  • Last time I commented here was in 2006, haven't changed my mind yet - for me it's still hands down the best SQLite management tool out there :) extra happy to see a Mac version too. Well Done ! -- amnon 2013-07-03 (Wed) 16:17:15
  • Sqlite::publish の $sqlcmd を検査する並びに "with" も加えていただけると有難いです -- 小林弘明 2014-04-07 (月) 18:42:24
  • こんな感じです> https://gist.github.com/hkoba/10017451 -- 小林弘明 2014-04-07 (月) 18:48:37
    • なるほど。。 -- reddog 2014-04-08 (火) 22:06:27
  • Hi, there! I tried 0.5.11 for Windows and it even imported a CSV file containing lots of UTF-8 entries correctly, unlike all the other programs I tried - Well done!! But I didn't find an option to delete a table - is that an oversight or this omission by design? Anyway, thanks a lot for this amazing program!! -- Bernd 2014-04-19 (Sat) 11:33:21
    • right-click a table icon in the tree view or menu->database->delete table/view, and select a menu to delete table/view. -- reddog 2014-04-21 (月) 07:03:01


CategoryTclTk CategorySoft CategoryEnglish


|New|Edit|Freeze|Diff|Backup|Upload|Copy|Rename|
Last-modified: 2014-04-21 (Mon) 07:03:04 (3d)
HTML convert time: 0.387 sec.