TkSQLite をテンプレートにして作成

Start:
**Index [#ub7cac4e] #contents ** What is This? [#bfb46c8d] TkSQLite is a GUI database manager for SQLite implemented... It can manage SQLite version2.8 and SQLite version3.x dat... encodings like Shift-JIS, EUC-JP and Windows native milt... encodings not only UTF-8. And it can run on Windows and L... and MacOSX as native Look & Feel. And it's Freeware. ** Features [#oefefad8] -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 f... -Run on any platform Tcl/Tk can. -Attach and Detach Database. -Export and Import CSV. -Dump a database to SQL. -Support loadable extension. **Requirements [#requirements] -[[Tcl/Tk8.4+:http://www.tcl.tk/]] -[[Tile0.7+:http://tktable.sourceforge.net/tile/]](not re... -[[tclsqlite and|or tclsqlite3:http://www.sqlite.org/]] -[[TkTable2.9+:http://tktable.sourceforge.net/]] -[[Dict8.5+:http://pascal.scheffers.net/software/]](not r... -[[Treectrl2.1+:http://sourceforge.net/projects/tktreectr... -[[tkImg:http://sourceforge.net/projects/tkimg/]] (requir... -[[Trf:http://sourceforge.net/projects/tcltrf]] and [[Tcl... ''NOTE:''~ Tablelist4.5+ is still required by tksqlite 0.4. But tksqlite 0.5 requires Treectrl2.1+ instead of Tableli... [[ActiveTcl:http://www.activestate.com/Products/activetcl... ** Uninstall [#d64566fc] remove tksqlite.tcl and, rm ~/.tksqlite on linux or %APPD... ** License [#c9005506] New BSD style license. **Screenshot [#tef99b25] //ver0.1 on Win2000~ //http://reddog.s35.xrea.com/img/tkSQLiteGUI001.jpg~ //~ //ver0.2 on Linux~ //http://reddog.s35.xrea.com/img/tkSQLiteGUI002.jpg~ //~ ver0.5 English version on Vista~ #ref(http://reddog.s35.xrea.com/img/TkSQLite001.png,nolin... ~ ver0.4 Japanese version on Linux~ #ref(http://reddog.s35.xrea.com/img/TkSQLite0.3a.png,noli... **Download [#download] -Old versions~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.3.2.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.1.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.2.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.3.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.4.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.5.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.6.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.3.2.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.1.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.2.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.3.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.4.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.5.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.6.tar.gz~ -ver0.4.7~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.4.7.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.7.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.0'')~ http://reddog.s35.xrea.com/software/tksqlite-0.4.7-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.4.7-linux-... -ver0.5.0~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.0.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.0.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.1'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.0-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.0-linux-... -ver0.5.1~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.1.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.1.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.1'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.1-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.1-linux-... -ver0.5.2~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.2.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.2.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.2'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.2-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.2-linux-... -ver0.5.3~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.3.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.3.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.2'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.3-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.3-linux-... -ver0.5.4~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.4.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.4.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.2'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.4-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.4-linux-... -ver0.5.5~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.5.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.5.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.5.2'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.5-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.5-linux-... -ver0.5.6~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.6.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.6.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.6.0'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.6-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.6-linux-... -ver0.5.7~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.7.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.7.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.6.5'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.7-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.7-linux-... -ver0.5.8~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.8.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.8.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.6.11'... http://reddog.s35.xrea.com/software/tksqlite-0.5.8-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.8-linux-... -ver0.5.9~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.9.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.9.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.7.14'... http://reddog.s35.xrea.com/software/tksqlite-0.5.9-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.9-linux-... http://reddog.s35.xrea.com/software/tksqlite-0.5.9-osx10.... -ver0.5.10~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.10.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.10.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.7.14'... http://reddog.s35.xrea.com/software/tksqlite-0.5.10-win32... http://reddog.s35.xrea.com/software/tksqlite-0.5.10-linux... http://reddog.s35.xrea.com/software/tksqlite-0.5.10-osx10... -ver0.5.11~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.11.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.11.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-win32... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-linux... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-osx10... -ver0.5.11-1~ --Tcl script~ (same as 5.11) --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-1-win... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-1-lin... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-1-osx... -ver0.5.11-2~ --Tcl script~ (same as 5.11) --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-2-win... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-2-lin... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-2-osx... -ver0.5.11-3~ --Tcl script~ (same as 5.11) --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-3-win... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-3-lin... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-3-osx... -ver0.5.12~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.12.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.12.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.12-win32... http://reddog.s35.xrea.com/software/tksqlite-0.5.12-linux... http://reddog.s35.xrea.com/software/tksqlite-0.5.12-osx10... -ver0.5.13~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.13.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.13.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.8.12.... http://reddog.s35.xrea.com/software/tksqlite-0.5.13-win32... http://reddog.s35.xrea.com/software/tksqlite-0.5.13-linux... http://reddog.s35.xrea.com/software/tksqlite-0.5.13-osx10... #htmlinsert(TkSQLite336x280) 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 [#changelog] -''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 sql... -''0.3'' (2005-12-04) -- Create Table Dialog, Create Index Dialog and Preferenc... -- 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 c... -- Fix a session bug that TkSQLite wasn't able to recover... -- 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 automa... -- 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... -- Add 3.x compatible format mode option. (in Preference ... -- Add Cache size Dialog. -- Add DataEditor Dialog. -- Enable to change table schema. -- Enable to view images in BLOB data.(gif, jpeg, png, bm... -- Speed up base64 encode/decode. -- New user function compress, decompress, read_file and ... -- Add binary mode to crypt user function (md5, sha1, bas... -''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 w... -- 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, winnativ... --Readiness for tk8.5a6(or b1?) and tile0.8. tksqlite now... --Fix some gui bugs. -''(source tcl script isn't modified)'' (2007-04-05) -- update to sqlite 3.3.14 in executable standalone versi... -- A tclkit of linux was compiled with thread-enabled opt... -''(source tcl script isn't modified)'' (2007-04-09) -- update to sqlite 3.3.15 in executable standalone versi... -''(source tcl script isn't modified)'' (2007-04-23) -- update to sqlite 3.3.16 in executable standalone versi... -''(source tcl script isn't modified)'' (2007-04-29) -- update to sqlite 3.3.17 in executable standalone versi... -''0.4.4'' (2007-05-25) -- Improved a behavior of grid-table. If a new row was cr... -- 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... -- Changed Shortcuts. Now "Select All" is Ctrl-A. (or Cmd... -- 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(CV... -''0.4.5'' (2007-05-28) -- Fixed conflict of context menu bindings and default wi... -''0.4.6'' (2007-06-20) -- Fixed garbled string inputted by xim on unix, if encod... -- Added [[cp51932 encoding>cp51932.enc]] to standalone v... -- Updated to sqlite 3.4.0 in executable standalone versi... -''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 (shiftji... -''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... -- 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. Beca... -- Used tclkit lite to avoid libstdc++ dependency on linu... -- Updated Tcl/Tk to CVS HEAD used in standalone version. -- Fixed garbled string when db is multibyte encoding on ... -- Fixed sql parser error if "CREATA TABLE" query has "DE... -- Fixed delete row error if using multibyte encoding on ... -''(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 ... -- Fixed a suspicious behavior of a grid table. -- Improved import/export text dialog. The dialogs can se... -- Improved a modify table scheme dialog. When you add a ... -- 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 cla... --Fixed a but that if "NULL" was enterd in DEFAULT text e... -''(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 wh... --Fixed a text sticking out of cell in grid table. The pr... -''0.5.4'' (2007-09-05) --Fixed a bug that CSV(Text) Importer couldn't break out ... --Fixed a left-over conflict between tclsqlite and last T... --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 win3... -''(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::dia... -- Fixed auto_path error when tksqlite is executed by sta... -''(source tcl script isn't modified) (2007-12-15)'' -- Updated to sqlite 3.5.4 in executable standalone versi... -''(source tcl script isn't modified) (2008-02-02)'' -- Updated to sqlite 3.5.5 in executable standalone versi... -- Updated to Tcl/Tk 8.5.1b1 in executable standalone ver... -''(source tcl script isn't modified) (2008-03-23)'' -- Updated to sqlite 3.5.7 in executable standalone versi... -- Updated to Tcl/Tk 8.5.1 in executable standalone versi... -''(source tcl script isn't modified) (2008-07-17)'' -- Updated to sqlite 3.6.0 in executable standalone versi... -- Updated to Tcl/Tk 8.5.3 in executable standalone versi... -''0.5.7'' (2008-11-17) -- updated to sqlite 3.6.5 in executable standalone versi... -- Updated to Tcl/Tk 8.5.5 in executable standalone versi... -- Updated to Tktable2.10 in executable standalone version. -- Updated to Treectrl2.2.8 in executable standalone vers... -- Updated to Tcllib1.11 in executable standalone version. -- Fixed a bug, if column name was reserved keyword, "Mod... -- Fixed init file ".tksqlite" could not save on Windows ... -- Enable to set DEFAULT value on "Modify Table schema" D... -- If SQL Editor has selection, and you push Ctrl-Enter (... -''0.5.8'' (2009-03-07) -- updated to sqlite 3.6.11 in executable standalone vers... -- Fixed a bug, grid table's cell editor escaped single q... -- Enable to use collation list from sqlite3 pragma colla... -''0.5.9'' (2013-04-27) -- update to sqlite 3.7.14 in executable standalone versi... -- 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... -- Fixed a bug, a modal dialog was locked on OSX (aqua wi... -- 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 ... -''0.5.11'' (2014-04-09) -- Enabled to run Common Table Expressions. -- Skip loading a function if the function is already exi... -- Add printf function. -''0.5.11-1'' (2014-05-12) -- Same as 0.5.11. But updated the Tcl/Tk runtime to 8.6.... -''0.5.11-2'' (2014-05-23) -- Same as 0.5.11. But binary versions include sqlite3 wi... -''0.5.11-3'' (2014-05-29) -- Same as 0.5.11. But fixed binary versions to include s... -''0.5.12'' (2015-11-06) -- Add option for Unicode BOM at Export CSV Dialog. -''0.5.13'' (2016-04-29) -- Fixed some dialogs move over out of screen when using ... -- Fixed size of maximized window is not recovered by ses... -- Upgrade to sqlite 3.12.2 in executable standalone vers... ** How to use [#pdaa6504] *** Create Table and Index [#kc6d3e69] -Create Table~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_createtable.... ~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_createcolumn... -Create Index~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_createindex.... *** Key Binding [#fe49003b] -Editor |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Ctrl+Return |Execute sql | |BGCOLOR(#DDDDDD):Ctrl-Delete |Clear all | -GridTable --Normal mode |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Ctrl+n |Insert Row | |BGCOLOR(#DDDDDD):Ctrl+d |Delete Row | |BGCOLOR(#DDDDDD):F5 |Update Grid Table | |>|BGCOLOR(#BBBBBB):CENTER:Vi keybind | |BGCOLOR(#DDDDDD):h |Move left | |BGCOLOR(#DDDDDD):j |Move down | |BGCOLOR(#DDDDDD):k |Move up | |BGCOLOR(#DDDDDD):l |Move right | |BGCOLOR(#DDDDDD):o |Insert row | |BGCOLOR(#DDDDDD):slash |Show Search Dialog | |BGCOLOR(#DDDDDD):gg |Move top | |BGCOLOR(#DDDDDD):G |Move bottom | |BGCOLOR(#DDDDDD):u |Update Grid Table | --Cell Edit mode |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Escape |Cancel Editing ... |BGCOLOR(#DDDDDD):Return |Commit and move down ... |BGCOLOR(#DDDDDD):Shift+Return |Commit and move up ... |BGCOLOR(#DDDDDD):Ctrl+Return |Commit ... |BGCOLOR(#DDDDDD):Alt+Return |Insert Return ... |BGCOLOR(#DDDDDD):Left |Commit and move left ... |BGCOLOR(#DDDDDD):Right |Commit and move right ... |BGCOLOR(#DDDDDD):Tab |Commit and move next ... |BGCOLOR(#DDDDDD):Shift+Tab |Commit and move prev ... |>|BGCOLOR(#BBBBBB):CENTER:Vi keybind | |BGCOLOR(#DDDDDD):Ctrl+h |Commit and begin editing ... |BGCOLOR(#DDDDDD):Ctrl+j |Commit and begin editing ... |BGCOLOR(#DDDDDD):Ctrl+k |Commit and begin editing ... |BGCOLOR(#DDDDDD):Ctrl+l |Commit and begin editing ... --Insert new row |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Escape |Cancel | |BGCOLOR(#DDDDDD):Return |Commit | |BGCOLOR(#DDDDDD):Shift+Return |Commit and move up | |BGCOLOR(#DDDDDD):Ctrl+Return |Commit | |BGCOLOR(#DDDDDD):Alt+Return |Insert | |BGCOLOR(#DDDDDD):Up |Commit and move up | |BGCOLOR(#DDDDDD):Down |Commit | |BGCOLOR(#DDDDDD):Left |move left | |BGCOLOR(#DDDDDD):Right |move right | |BGCOLOR(#DDDDDD):Tab |move next | |BGCOLOR(#DDDDDD):Shift+Tab |move prev | |>|BGCOLOR(#BBBBBB):CENTER:Vi keybind | |BGCOLOR(#DDDDDD):Ctrl+h |same as Left | |BGCOLOR(#DDDDDD):Ctrl+j |same as Down | |BGCOLOR(#DDDDDD):Ctrl+k |same as Up | |BGCOLOR(#DDDDDD):Ctrl+l |same as Right | -DataEditor(Text) (this binding is enable on tksqlite0.5+) |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Ctrl+Return |Update | |>|BGCOLOR(#BBBBBB):CENTER:Vi keybind | |BGCOLOR(#DDDDDD):Ctrl-h |Move left grid table ... |BGCOLOR(#DDDDDD):Ctrl-j |Move down grid table ... |BGCOLOR(#DDDDDD):Ctrl-k |Move up grid table ... |BGCOLOR(#DDDDDD):Ctrl-l |Move right grid table ... *** Import/Export CSV [#x4f20879] -Import CSV Dialog~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_import.png,n... --If "First Line is Field Name" was checked and an existi... TkSQLite try to insert empty string or NULL(if the col wa... --Leading spaces adjacent to separator are trimmed. --Fields with embedded separator must be delimited with q... --The embedded quote characters must be represented by a ... -Export CSV Dialog~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_export.png,n... *** Functions [#a433bd24] TkSQLite have many user functions emulated some other DB'... ~ - Some example --perl5 like regexp. (this is Tcl regexp command. see als... select * from t where name regexp "^J.*" --regsub(pattern, colname, str). You can use submach patt... insert into t select regsub("syo", name, "sho") from t2 ~ select regsub("(\d{4})(\d{2})(\d{2}).*", "20050401", "\1... 2005-04-01 --MD5(requires Tcllib). select md5(name) from t --read_file insert into t values(NULL, 'image test', read_file('c:/t... *** Loading tcl script functions. [#ye1814e3] tksqlite 0.5 can load tcl script functions. The interface... You can access the ''db'' command. It is just a sqlite da... But don't use another sub commands except for ''db functi... the command is used by tksqlite. Don't rename and free th... The loading process is + db is opened. + default sqlite functions is installed. + 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 Enab... 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 [#g986055b] -this script is useful, but 20mb TCL prerequisite is a ki... -Thank you. I'll examine that. -- reddog 2006-01-11 15:30... -Hi. Looks like a great peace of software but, as techie ... -I was going to make standalone until 3.3 came. But I'm h... -Excellent work. Would be nice if keywords could be upper... -Your standalone executable binary for Windows is excelle... -Thanks for the excellent program, very useful. Keep up t... -Just gets better and better. Domo Arigato for the upperc... -Thank you for the impressive work. Would be really be ab... -Really excellent program - if development remains active... --I am now observing Tcl/Tk8.5 and some sqlite new featur... -I have to admit, I am not fan of Tk look, but TkSQLite w... -Dear Reddog - would you mind if I make a new page on the... --No, of course I don't mind that. Please add tksqlite to... -Page added to Tcler's Wiki - http://mini.net/tcl/TkSQLit... -Looks very nice and Tcl is just the right choice! The 0.... --There isn't 0.4.2 yet. And I could untar 0.4.1 and 0.3.... -Sorry, 0.4.2 was a false mix of 0.3.2 and 0.4.1. Today t... -ver0.4.5のツールバーが日本語にならないのですがパッチを作... --ツールバーってどの部分のことですか？パッチを作っていた... -大変失礼いたしました．申し訳ございません　OSはwindows xp... --環境変数でLANG=jaしてみてください。 -- reddog 2007-06-1... -どうもありがとうございます　日本語になりました　 -- jils... -TkSQLite is really great. Thank you + greetings from ger... -Nice Nice progrm however recent versions 4.3+ having pro... --thank you for the report. Are you using the binary vers... -2 Quick 4 Me thanks for your reply and yes I have consis... -Quick addition Running latest script OK so problem is in... -the greatest admin for sqlite i ever seen! -- tataremka ... -Hi! 0.5.5 windows standalone doeasn't work :( -- 2007-1... --oh... It may be side-by-side config info problem. I tes... -dont know if my email reached you:)caouse no answer. it ... --I noticed your email was in spam dir on gmail. sorry, I... -Hi? i'm only curious you work on populate dialog? :) one... -If you get the "cannot find kit pre-init script" error, ... -Hi! please look in email (propably in spam as before) wi... -アイコンのデザインがすごく・・・いいです。 -- twister 20... -There is a problem to set default using CURRENT_TIMESTAM... -Perhaps use external sqlite.dll so tksqlite.exe needs no... -メモリデータベースは対応してないんでしょうか -- clock 20... --してないです。 -- reddog 2007-11-18 21:14:46 -please set auto_path in interp creation at line 9496/7 "... --Are you talking about tksqlite standalone version? -- r... -hi. i have tested a lot of sqlite-tools. at the end i on... -If I try to open an existing database as new in ver0.5.5... --I fixed it. try 0.5.6. -- reddog 2007-12-04 02:01:46 -Hey man... the same as others... I have tested many sqli... -after upgrading to gutsy gibbon tksqlite stopped working... --What error message did you get ? -- reddog 2007-12-12 0... -Thank you for that application. But I have a problem: Af... --I noticed that the ubuntu7.10's new security layer may ... --''"sudo /etc/init.d/apparmor kill"'' makes tksqlite wor... -OK, now it works again. Thanks -- josch 2007-12-23 21:35... -I tried "sudo modprobe -r apparmor" to unload apparmor, ... -Changing the folowing code will make a not perfect hack ... if {$hasdefault == 1} { if {![Util::isNumber $defaultvalue]} { if {[regexp {current_} [string tolower $defaultv... set defaultvalue "[string map {' ''} $defaul... } else { set defaultvalue "'[string map {' ''} $defau... } } append coldef " DEFAULT $defaultvalue" } -i think that virtual tables are wrong handled, eg.: crea... --What versions of sqlite and tksqlite and fts3 are you u... -i'm using the latest one version of tksqlite. i'm sugges... -when im adding in grid a new row then error is: "Invalid... --I confirmed the insert problem now. I'm goin to debug. ... -i cannot create table with CURRENT_DATE, CURRENT_TIME, C... --I know the problem. I'm thinking how express the data t... -すばらしいツールです。スタンドアロン版をdebian-etch686,X... --[[Requirements>#requirements]]を見てください。 -- reddo... -can u pls help me install 0.5.6 on mac os x leopard... h... --Sorry I can't help you, because I dont have the machine... -いいツールです。デザインも素敵ですね。win xp pro ですが... -↑自己解決。個人的に入れたAIKOフォントが使われていました... -I love the application! And the tcl/tk programming is i... -expected floating-point number but got "0,0151917" dec... -Just trying it out, looks useful. Question, got empty st... -If column name is reserved word eg. "references" then it... -script errors on my Mac PowerBook "can't find package di... --TkSQLite requires some extensions. See [[Requirements>#... -【バグ報告です】(スタンドアロン版 ver 0.5.7,WindowsXP) ... --報告ありがとうございます。確認しました。調べて直したい... -expected floating-point number but got "0,015738" while ... -on mac: can't rename to "ttk::_scrollbar": command alrea... -Problem with table edit. Correct me if I am incorrect, m... -便利なツールありがとうございます！せっかくなのでｔｃｌ一... -hi,after upgrading to ubuntu 9.10 (karmic) tksqlite does... -Is it possible to make available a 64bit binary for Linu... -Hi, I tried many sqlite managers, this one is my favorit... -I tried to used the functions left and right but I recei... -The windows standalone executable is an excellent tool. ... -Warning! Missing option "if not exists" in Create Table ... -Is there a chance that you will further develop this gre... -Get up to date binary versions at http://sourceforge.net... -SJISに対応してくれていたので死ぬほど助かりました…本当に... -blobに画像ファイル格納してみたんですが動作が重くなったよ... -Anyone got a compiled Mac OS X version available? -- and... -Could you please update standalone version with SQLite 3... -TEXTのカラムに'0001'と入力すると'1'で保存されてしまいま... -環境変数LANG = jani -- 2011-06-15 20:09:43 -環境変数ちゃんと設定したのになぜか日本語にならないのです... -I have created a fork of TkSQLite with wxSQLite AES 128b... -Please change line 14708 from "Cmd::openDB [file normali... -Very, very useful. Thank you for your hard work. -- mike... -It would be nice to be able to manually select the local... -I like it, very usefull, but facing issue since I switch... --I have confirmed some reported bugs, I intend to fix th... - Last time I commented here was in 2006, haven't changed... - Sqlite::publish の $sqlcmd を検査する並びに "with" も加... - こんな感じです＞ https://gist.github.com/hkoba/10017451... -- なるほど。。 -- reddog &new{2014-04-08 (火) 22:06:27}; - Hi, there! I tried 0.5.11 for Windows and it even impor... -- right-click a table icon in the tree view or menu->dat... - In ver 0.5.11 SHIFT-CONTROL-DOWN to mark text downwards... -- The Shift-Ctl-Down is a bug of Tcl/Tk, Try tksqlite0.5... - Thank you for continuing to work on your great program!... -- OK. I have done that. Try tksqlite0.5.11-2. -- reddog ... - Awesome! Thank you for doing that reddog. May I offer s... -- Thank you for your comment. I'll take a moment to thin... - My dearst thanks to you: within only a few weeks you so... -- Your suggestion is easy to understand. But the list or... - 5.11-3winで設置パス中に日本語文字があるとcouldn't load ... -- I wrapped tksqlite again to fix the error, try 0.5.11-... -- エラーが出ない事を確認しました。ご対応頂いてありがとう... - 日本語CSV取り込みがすばらしいです！感謝します。最新のma... - Please tell if there is a reception of the donations f... - Hey reddog! Please consider adding an option to export ... -- 0.5.12. -- reddog &new{2015-11-05 (金) 23:09:23}; - Thank you so much! May I ask for your kind re-considera... - 素晴らしいツールを提供していただき、心から感謝いたしま... -- 0.5.13. -- reddog &new{2016-04-29 (金) 00:48:25}; - 0.5.13のご提供ありがとうございました。マルチディスプレ... - please consider uncheck the checkmark of default during... - Hi reddog :-) I found reading or writing a string over ... - Please enable FTS5 support. Says "no such module: fts5"... - こんにちは、本当に楽しいです 私はこのサイトを訪問するた... - Windows10で利用させて頂いています。Tkツールキットの問題... - 新しい tk8.6.10 だとDbtree のテーブル名でダブルクリック... - 20 Insightful Quotes On Accident Attorney No Injury att... #comment #htmlinsert(TkSQLite336x280) ---- [[CategoryTclTk]] [[CategorySoft]] [[CategoryEnglish]]

End:
**Index [#ub7cac4e] #contents ** What is This? [#bfb46c8d] TkSQLite is a GUI database manager for SQLite implemented... It can manage SQLite version2.8 and SQLite version3.x dat... encodings like Shift-JIS, EUC-JP and Windows native milt... encodings not only UTF-8. And it can run on Windows and L... and MacOSX as native Look & Feel. And it's Freeware. ** Features [#oefefad8] -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 f... -Run on any platform Tcl/Tk can. -Attach and Detach Database. -Export and Import CSV. -Dump a database to SQL. -Support loadable extension. **Requirements [#requirements] -[[Tcl/Tk8.4+:http://www.tcl.tk/]] -[[Tile0.7+:http://tktable.sourceforge.net/tile/]](not re... -[[tclsqlite and|or tclsqlite3:http://www.sqlite.org/]] -[[TkTable2.9+:http://tktable.sourceforge.net/]] -[[Dict8.5+:http://pascal.scheffers.net/software/]](not r... -[[Treectrl2.1+:http://sourceforge.net/projects/tktreectr... -[[tkImg:http://sourceforge.net/projects/tkimg/]] (requir... -[[Trf:http://sourceforge.net/projects/tcltrf]] and [[Tcl... ''NOTE:''~ Tablelist4.5+ is still required by tksqlite 0.4. But tksqlite 0.5 requires Treectrl2.1+ instead of Tableli... [[ActiveTcl:http://www.activestate.com/Products/activetcl... ** Uninstall [#d64566fc] remove tksqlite.tcl and, rm ~/.tksqlite on linux or %APPD... ** License [#c9005506] New BSD style license. **Screenshot [#tef99b25] //ver0.1 on Win2000~ //http://reddog.s35.xrea.com/img/tkSQLiteGUI001.jpg~ //~ //ver0.2 on Linux~ //http://reddog.s35.xrea.com/img/tkSQLiteGUI002.jpg~ //~ ver0.5 English version on Vista~ #ref(http://reddog.s35.xrea.com/img/TkSQLite001.png,nolin... ~ ver0.4 Japanese version on Linux~ #ref(http://reddog.s35.xrea.com/img/TkSQLite0.3a.png,noli... **Download [#download] -Old versions~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.3.2.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.1.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.2.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.3.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.4.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.5.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.6.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.3.2.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.1.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.2.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.3.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.4.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.5.tar.gz~ http://reddog.s35.xrea.com/software/tksqlite-0.4.6.tar.gz~ -ver0.4.7~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.4.7.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.4.7.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.0'')~ http://reddog.s35.xrea.com/software/tksqlite-0.4.7-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.4.7-linux-... -ver0.5.0~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.0.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.0.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.1'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.0-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.0-linux-... -ver0.5.1~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.1.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.1.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.1'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.1-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.1-linux-... -ver0.5.2~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.2.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.2.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.2'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.2-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.2-linux-... -ver0.5.3~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.3.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.3.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.2'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.3-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.3-linux-... -ver0.5.4~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.4.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.4.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.4.2'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.4-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.4-linux-... -ver0.5.5~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.5.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.5.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.5.2'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.5-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.5-linux-... -ver0.5.6~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.6.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.6.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.6.0'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.6-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.6-linux-... -ver0.5.7~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.7.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.7.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.6.5'')~ http://reddog.s35.xrea.com/software/tksqlite-0.5.7-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.7-linux-... -ver0.5.8~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.8.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.8.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.6.11'... http://reddog.s35.xrea.com/software/tksqlite-0.5.8-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.8-linux-... -ver0.5.9~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.9.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.9.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.7.14'... http://reddog.s35.xrea.com/software/tksqlite-0.5.9-win32-... http://reddog.s35.xrea.com/software/tksqlite-0.5.9-linux-... http://reddog.s35.xrea.com/software/tksqlite-0.5.9-osx10.... -ver0.5.10~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.10.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.10.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.7.14'... http://reddog.s35.xrea.com/software/tksqlite-0.5.10-win32... http://reddog.s35.xrea.com/software/tksqlite-0.5.10-linux... http://reddog.s35.xrea.com/software/tksqlite-0.5.10-osx10... -ver0.5.11~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.11.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.11.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-win32... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-linux... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-osx10... -ver0.5.11-1~ --Tcl script~ (same as 5.11) --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-1-win... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-1-lin... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-1-osx... -ver0.5.11-2~ --Tcl script~ (same as 5.11) --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-2-win... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-2-lin... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-2-osx... -ver0.5.11-3~ --Tcl script~ (same as 5.11) --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-3-win... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-3-lin... http://reddog.s35.xrea.com/software/tksqlite-0.5.11-3-osx... -ver0.5.12~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.12.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.12.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.8.4.3... http://reddog.s35.xrea.com/software/tksqlite-0.5.12-win32... http://reddog.s35.xrea.com/software/tksqlite-0.5.12-linux... http://reddog.s35.xrea.com/software/tksqlite-0.5.12-osx10... -ver0.5.13~ --Tcl script~ http://reddog.s35.xrea.com/software/tksqlite-0.5.13.zip~ http://reddog.s35.xrea.com/software/tksqlite-0.5.13.tar.gz~ --Standalone executable binary (sqlite 2.8.17 / ''3.8.12.... http://reddog.s35.xrea.com/software/tksqlite-0.5.13-win32... http://reddog.s35.xrea.com/software/tksqlite-0.5.13-linux... http://reddog.s35.xrea.com/software/tksqlite-0.5.13-osx10... #htmlinsert(TkSQLite336x280) 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 [#changelog] -''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 sql... -''0.3'' (2005-12-04) -- Create Table Dialog, Create Index Dialog and Preferenc... -- 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 c... -- Fix a session bug that TkSQLite wasn't able to recover... -- 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 automa... -- 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... -- Add 3.x compatible format mode option. (in Preference ... -- Add Cache size Dialog. -- Add DataEditor Dialog. -- Enable to change table schema. -- Enable to view images in BLOB data.(gif, jpeg, png, bm... -- Speed up base64 encode/decode. -- New user function compress, decompress, read_file and ... -- Add binary mode to crypt user function (md5, sha1, bas... -''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 w... -- 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, winnativ... --Readiness for tk8.5a6(or b1?) and tile0.8. tksqlite now... --Fix some gui bugs. -''(source tcl script isn't modified)'' (2007-04-05) -- update to sqlite 3.3.14 in executable standalone versi... -- A tclkit of linux was compiled with thread-enabled opt... -''(source tcl script isn't modified)'' (2007-04-09) -- update to sqlite 3.3.15 in executable standalone versi... -''(source tcl script isn't modified)'' (2007-04-23) -- update to sqlite 3.3.16 in executable standalone versi... -''(source tcl script isn't modified)'' (2007-04-29) -- update to sqlite 3.3.17 in executable standalone versi... -''0.4.4'' (2007-05-25) -- Improved a behavior of grid-table. If a new row was cr... -- 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... -- Changed Shortcuts. Now "Select All" is Ctrl-A. (or Cmd... -- 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(CV... -''0.4.5'' (2007-05-28) -- Fixed conflict of context menu bindings and default wi... -''0.4.6'' (2007-06-20) -- Fixed garbled string inputted by xim on unix, if encod... -- Added [[cp51932 encoding>cp51932.enc]] to standalone v... -- Updated to sqlite 3.4.0 in executable standalone versi... -''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 (shiftji... -''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... -- 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. Beca... -- Used tclkit lite to avoid libstdc++ dependency on linu... -- Updated Tcl/Tk to CVS HEAD used in standalone version. -- Fixed garbled string when db is multibyte encoding on ... -- Fixed sql parser error if "CREATA TABLE" query has "DE... -- Fixed delete row error if using multibyte encoding on ... -''(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 ... -- Fixed a suspicious behavior of a grid table. -- Improved import/export text dialog. The dialogs can se... -- Improved a modify table scheme dialog. When you add a ... -- 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 cla... --Fixed a but that if "NULL" was enterd in DEFAULT text e... -''(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 wh... --Fixed a text sticking out of cell in grid table. The pr... -''0.5.4'' (2007-09-05) --Fixed a bug that CSV(Text) Importer couldn't break out ... --Fixed a left-over conflict between tclsqlite and last T... --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 win3... -''(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::dia... -- Fixed auto_path error when tksqlite is executed by sta... -''(source tcl script isn't modified) (2007-12-15)'' -- Updated to sqlite 3.5.4 in executable standalone versi... -''(source tcl script isn't modified) (2008-02-02)'' -- Updated to sqlite 3.5.5 in executable standalone versi... -- Updated to Tcl/Tk 8.5.1b1 in executable standalone ver... -''(source tcl script isn't modified) (2008-03-23)'' -- Updated to sqlite 3.5.7 in executable standalone versi... -- Updated to Tcl/Tk 8.5.1 in executable standalone versi... -''(source tcl script isn't modified) (2008-07-17)'' -- Updated to sqlite 3.6.0 in executable standalone versi... -- Updated to Tcl/Tk 8.5.3 in executable standalone versi... -''0.5.7'' (2008-11-17) -- updated to sqlite 3.6.5 in executable standalone versi... -- Updated to Tcl/Tk 8.5.5 in executable standalone versi... -- Updated to Tktable2.10 in executable standalone version. -- Updated to Treectrl2.2.8 in executable standalone vers... -- Updated to Tcllib1.11 in executable standalone version. -- Fixed a bug, if column name was reserved keyword, "Mod... -- Fixed init file ".tksqlite" could not save on Windows ... -- Enable to set DEFAULT value on "Modify Table schema" D... -- If SQL Editor has selection, and you push Ctrl-Enter (... -''0.5.8'' (2009-03-07) -- updated to sqlite 3.6.11 in executable standalone vers... -- Fixed a bug, grid table's cell editor escaped single q... -- Enable to use collation list from sqlite3 pragma colla... -''0.5.9'' (2013-04-27) -- update to sqlite 3.7.14 in executable standalone versi... -- 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... -- Fixed a bug, a modal dialog was locked on OSX (aqua wi... -- 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 ... -''0.5.11'' (2014-04-09) -- Enabled to run Common Table Expressions. -- Skip loading a function if the function is already exi... -- Add printf function. -''0.5.11-1'' (2014-05-12) -- Same as 0.5.11. But updated the Tcl/Tk runtime to 8.6.... -''0.5.11-2'' (2014-05-23) -- Same as 0.5.11. But binary versions include sqlite3 wi... -''0.5.11-3'' (2014-05-29) -- Same as 0.5.11. But fixed binary versions to include s... -''0.5.12'' (2015-11-06) -- Add option for Unicode BOM at Export CSV Dialog. -''0.5.13'' (2016-04-29) -- Fixed some dialogs move over out of screen when using ... -- Fixed size of maximized window is not recovered by ses... -- Upgrade to sqlite 3.12.2 in executable standalone vers... ** How to use [#pdaa6504] *** Create Table and Index [#kc6d3e69] -Create Table~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_createtable.... ~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_createcolumn... -Create Index~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_createindex.... *** Key Binding [#fe49003b] -Editor |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Ctrl+Return |Execute sql | |BGCOLOR(#DDDDDD):Ctrl-Delete |Clear all | -GridTable --Normal mode |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Ctrl+n |Insert Row | |BGCOLOR(#DDDDDD):Ctrl+d |Delete Row | |BGCOLOR(#DDDDDD):F5 |Update Grid Table | |>|BGCOLOR(#BBBBBB):CENTER:Vi keybind | |BGCOLOR(#DDDDDD):h |Move left | |BGCOLOR(#DDDDDD):j |Move down | |BGCOLOR(#DDDDDD):k |Move up | |BGCOLOR(#DDDDDD):l |Move right | |BGCOLOR(#DDDDDD):o |Insert row | |BGCOLOR(#DDDDDD):slash |Show Search Dialog | |BGCOLOR(#DDDDDD):gg |Move top | |BGCOLOR(#DDDDDD):G |Move bottom | |BGCOLOR(#DDDDDD):u |Update Grid Table | --Cell Edit mode |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Escape |Cancel Editing ... |BGCOLOR(#DDDDDD):Return |Commit and move down ... |BGCOLOR(#DDDDDD):Shift+Return |Commit and move up ... |BGCOLOR(#DDDDDD):Ctrl+Return |Commit ... |BGCOLOR(#DDDDDD):Alt+Return |Insert Return ... |BGCOLOR(#DDDDDD):Left |Commit and move left ... |BGCOLOR(#DDDDDD):Right |Commit and move right ... |BGCOLOR(#DDDDDD):Tab |Commit and move next ... |BGCOLOR(#DDDDDD):Shift+Tab |Commit and move prev ... |>|BGCOLOR(#BBBBBB):CENTER:Vi keybind | |BGCOLOR(#DDDDDD):Ctrl+h |Commit and begin editing ... |BGCOLOR(#DDDDDD):Ctrl+j |Commit and begin editing ... |BGCOLOR(#DDDDDD):Ctrl+k |Commit and begin editing ... |BGCOLOR(#DDDDDD):Ctrl+l |Commit and begin editing ... --Insert new row |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Escape |Cancel | |BGCOLOR(#DDDDDD):Return |Commit | |BGCOLOR(#DDDDDD):Shift+Return |Commit and move up | |BGCOLOR(#DDDDDD):Ctrl+Return |Commit | |BGCOLOR(#DDDDDD):Alt+Return |Insert | |BGCOLOR(#DDDDDD):Up |Commit and move up | |BGCOLOR(#DDDDDD):Down |Commit | |BGCOLOR(#DDDDDD):Left |move left | |BGCOLOR(#DDDDDD):Right |move right | |BGCOLOR(#DDDDDD):Tab |move next | |BGCOLOR(#DDDDDD):Shift+Tab |move prev | |>|BGCOLOR(#BBBBBB):CENTER:Vi keybind | |BGCOLOR(#DDDDDD):Ctrl+h |same as Left | |BGCOLOR(#DDDDDD):Ctrl+j |same as Down | |BGCOLOR(#DDDDDD):Ctrl+k |same as Up | |BGCOLOR(#DDDDDD):Ctrl+l |same as Right | -DataEditor(Text) (this binding is enable on tksqlite0.5+) |>|BGCOLOR(#BBBBBB):CENTER:Normal keybind | |BGCOLOR(#DDDDDD):Ctrl+Return |Update | |>|BGCOLOR(#BBBBBB):CENTER:Vi keybind | |BGCOLOR(#DDDDDD):Ctrl-h |Move left grid table ... |BGCOLOR(#DDDDDD):Ctrl-j |Move down grid table ... |BGCOLOR(#DDDDDD):Ctrl-k |Move up grid table ... |BGCOLOR(#DDDDDD):Ctrl-l |Move right grid table ... *** Import/Export CSV [#x4f20879] -Import CSV Dialog~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_import.png,n... --If "First Line is Field Name" was checked and an existi... TkSQLite try to insert empty string or NULL(if the col wa... --Leading spaces adjacent to separator are trimmed. --Fields with embedded separator must be delimited with q... --The embedded quote characters must be represented by a ... -Export CSV Dialog~ #ref(http://reddog.s35.xrea.com/img/TkSQLite_export.png,n... *** Functions [#a433bd24] TkSQLite have many user functions emulated some other DB'... ~ - Some example --perl5 like regexp. (this is Tcl regexp command. see als... select * from t where name regexp "^J.*" --regsub(pattern, colname, str). You can use submach patt... insert into t select regsub("syo", name, "sho") from t2 ~ select regsub("(\d{4})(\d{2})(\d{2}).*", "20050401", "\1... 2005-04-01 --MD5(requires Tcllib). select md5(name) from t --read_file insert into t values(NULL, 'image test', read_file('c:/t... *** Loading tcl script functions. [#ye1814e3] tksqlite 0.5 can load tcl script functions. The interface... You can access the ''db'' command. It is just a sqlite da... But don't use another sub commands except for ''db functi... the command is used by tksqlite. Don't rename and free th... The loading process is + db is opened. + default sqlite functions is installed. + 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 Enab... 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 [#g986055b] -this script is useful, but 20mb TCL prerequisite is a ki... -Thank you. I'll examine that. -- reddog 2006-01-11 15:30... -Hi. Looks like a great peace of software but, as techie ... -I was going to make standalone until 3.3 came. But I'm h... -Excellent work. Would be nice if keywords could be upper... -Your standalone executable binary for Windows is excelle... -Thanks for the excellent program, very useful. Keep up t... -Just gets better and better. Domo Arigato for the upperc... -Thank you for the impressive work. Would be really be ab... -Really excellent program - if development remains active... --I am now observing Tcl/Tk8.5 and some sqlite new featur... -I have to admit, I am not fan of Tk look, but TkSQLite w... -Dear Reddog - would you mind if I make a new page on the... --No, of course I don't mind that. Please add tksqlite to... -Page added to Tcler's Wiki - http://mini.net/tcl/TkSQLit... -Looks very nice and Tcl is just the right choice! The 0.... --There isn't 0.4.2 yet. And I could untar 0.4.1 and 0.3.... -Sorry, 0.4.2 was a false mix of 0.3.2 and 0.4.1. Today t... -ver0.4.5のツールバーが日本語にならないのですがパッチを作... --ツールバーってどの部分のことですか？パッチを作っていた... -大変失礼いたしました．申し訳ございません　OSはwindows xp... --環境変数でLANG=jaしてみてください。 -- reddog 2007-06-1... -どうもありがとうございます　日本語になりました　 -- jils... -TkSQLite is really great. Thank you + greetings from ger... -Nice Nice progrm however recent versions 4.3+ having pro... --thank you for the report. Are you using the binary vers... -2 Quick 4 Me thanks for your reply and yes I have consis... -Quick addition Running latest script OK so problem is in... -the greatest admin for sqlite i ever seen! -- tataremka ... -Hi! 0.5.5 windows standalone doeasn't work :( -- 2007-1... --oh... It may be side-by-side config info problem. I tes... -dont know if my email reached you:)caouse no answer. it ... --I noticed your email was in spam dir on gmail. sorry, I... -Hi? i'm only curious you work on populate dialog? :) one... -If you get the "cannot find kit pre-init script" error, ... -Hi! please look in email (propably in spam as before) wi... -アイコンのデザインがすごく・・・いいです。 -- twister 20... -There is a problem to set default using CURRENT_TIMESTAM... -Perhaps use external sqlite.dll so tksqlite.exe needs no... -メモリデータベースは対応してないんでしょうか -- clock 20... --してないです。 -- reddog 2007-11-18 21:14:46 -please set auto_path in interp creation at line 9496/7 "... --Are you talking about tksqlite standalone version? -- r... -hi. i have tested a lot of sqlite-tools. at the end i on... -If I try to open an existing database as new in ver0.5.5... --I fixed it. try 0.5.6. -- reddog 2007-12-04 02:01:46 -Hey man... the same as others... I have tested many sqli... -after upgrading to gutsy gibbon tksqlite stopped working... --What error message did you get ? -- reddog 2007-12-12 0... -Thank you for that application. But I have a problem: Af... --I noticed that the ubuntu7.10's new security layer may ... --''"sudo /etc/init.d/apparmor kill"'' makes tksqlite wor... -OK, now it works again. Thanks -- josch 2007-12-23 21:35... -I tried "sudo modprobe -r apparmor" to unload apparmor, ... -Changing the folowing code will make a not perfect hack ... if {$hasdefault == 1} { if {![Util::isNumber $defaultvalue]} { if {[regexp {current_} [string tolower $defaultv... set defaultvalue "[string map {' ''} $defaul... } else { set defaultvalue "'[string map {' ''} $defau... } } append coldef " DEFAULT $defaultvalue" } -i think that virtual tables are wrong handled, eg.: crea... --What versions of sqlite and tksqlite and fts3 are you u... -i'm using the latest one version of tksqlite. i'm sugges... -when im adding in grid a new row then error is: "Invalid... --I confirmed the insert problem now. I'm goin to debug. ... -i cannot create table with CURRENT_DATE, CURRENT_TIME, C... --I know the problem. I'm thinking how express the data t... -すばらしいツールです。スタンドアロン版をdebian-etch686,X... --[[Requirements>#requirements]]を見てください。 -- reddo... -can u pls help me install 0.5.6 on mac os x leopard... h... --Sorry I can't help you, because I dont have the machine... -いいツールです。デザインも素敵ですね。win xp pro ですが... -↑自己解決。個人的に入れたAIKOフォントが使われていました... -I love the application! And the tcl/tk programming is i... -expected floating-point number but got "0,0151917" dec... -Just trying it out, looks useful. Question, got empty st... -If column name is reserved word eg. "references" then it... -script errors on my Mac PowerBook "can't find package di... --TkSQLite requires some extensions. See [[Requirements>#... -【バグ報告です】(スタンドアロン版 ver 0.5.7,WindowsXP) ... --報告ありがとうございます。確認しました。調べて直したい... -expected floating-point number but got "0,015738" while ... -on mac: can't rename to "ttk::_scrollbar": command alrea... -Problem with table edit. Correct me if I am incorrect, m... -便利なツールありがとうございます！せっかくなのでｔｃｌ一... -hi,after upgrading to ubuntu 9.10 (karmic) tksqlite does... -Is it possible to make available a 64bit binary for Linu... -Hi, I tried many sqlite managers, this one is my favorit... -I tried to used the functions left and right but I recei... -The windows standalone executable is an excellent tool. ... -Warning! Missing option "if not exists" in Create Table ... -Is there a chance that you will further develop this gre... -Get up to date binary versions at http://sourceforge.net... -SJISに対応してくれていたので死ぬほど助かりました…本当に... -blobに画像ファイル格納してみたんですが動作が重くなったよ... -Anyone got a compiled Mac OS X version available? -- and... -Could you please update standalone version with SQLite 3... -TEXTのカラムに'0001'と入力すると'1'で保存されてしまいま... -環境変数LANG = jani -- 2011-06-15 20:09:43 -環境変数ちゃんと設定したのになぜか日本語にならないのです... -I have created a fork of TkSQLite with wxSQLite AES 128b... -Please change line 14708 from "Cmd::openDB [file normali... -Very, very useful. Thank you for your hard work. -- mike... -It would be nice to be able to manually select the local... -I like it, very usefull, but facing issue since I switch... --I have confirmed some reported bugs, I intend to fix th... - Last time I commented here was in 2006, haven't changed... - Sqlite::publish の $sqlcmd を検査する並びに "with" も加... - こんな感じです＞ https://gist.github.com/hkoba/10017451... -- なるほど。。 -- reddog &new{2014-04-08 (火) 22:06:27}; - Hi, there! I tried 0.5.11 for Windows and it even impor... -- right-click a table icon in the tree view or menu->dat... - In ver 0.5.11 SHIFT-CONTROL-DOWN to mark text downwards... -- The Shift-Ctl-Down is a bug of Tcl/Tk, Try tksqlite0.5... - Thank you for continuing to work on your great program!... -- OK. I have done that. Try tksqlite0.5.11-2. -- reddog ... - Awesome! Thank you for doing that reddog. May I offer s... -- Thank you for your comment. I'll take a moment to thin... - My dearst thanks to you: within only a few weeks you so... -- Your suggestion is easy to understand. But the list or... - 5.11-3winで設置パス中に日本語文字があるとcouldn't load ... -- I wrapped tksqlite again to fix the error, try 0.5.11-... -- エラーが出ない事を確認しました。ご対応頂いてありがとう... - 日本語CSV取り込みがすばらしいです！感謝します。最新のma... - Please tell if there is a reception of the donations f... - Hey reddog! Please consider adding an option to export ... -- 0.5.12. -- reddog &new{2015-11-05 (金) 23:09:23}; - Thank you so much! May I ask for your kind re-considera... - 素晴らしいツールを提供していただき、心から感謝いたしま... -- 0.5.13. -- reddog &new{2016-04-29 (金) 00:48:25}; - 0.5.13のご提供ありがとうございました。マルチディスプレ... - please consider uncheck the checkmark of default during... - Hi reddog :-) I found reading or writing a string over ... - Please enable FTS5 support. Says "no such module: fts5"... - こんにちは、本当に楽しいです 私はこのサイトを訪問するた... - Windows10で利用させて頂いています。Tkツールキットの問題... - 新しい tk8.6.10 だとDbtree のテーブル名でダブルクリック... - 20 Insightful Quotes On Accident Attorney No Injury att... #comment #htmlinsert(TkSQLite336x280) ---- [[CategoryTclTk]] [[CategorySoft]] [[CategoryEnglish]]

Page: