Version 11 of dgDBBrowser
Updated 2007-02-23 15:38:53What: dgDBBrowser
Where: http://goblet.molgen.mpg.de/tclkit/dgDBBrowser.kit
Description: Tclkit based database viewer and editor for
Postgres, Mysql, Oracle, SQLite3, SQLite2, Metakit and ODBC.
Platforms: Win32, Linux32, Linux64, Solaris,Mac-OSX (ppc,i86)
but not all databases on all platforms
Features:
export tables as csv or tabulated files, import tabulated, space,
or comma separated files, create new tables, views from select
statements search tables by keywords, delete and rename views and
tables, colourized SQL-editor.
Currently at version 1.26 .
Updated: 02/2006
Comment: Please use tclkit8.4 not the 8.5 alphas
Contact: See web site, needs t be done soon.
Who: Dr. Detlef Groth
Platform SQLite3 SQLite2 Metakit Postgres Mysql ODBC Oracle Win32 x x x x x x x Linux32 x x x x x - - Linux64 x x x x x - - Solaris x - x - - - - MacOSX x - x - - - -
The minus symbols can be replaced if users are compiling the libraries for those extensions. The only exception is ODBC.
LV What does that last comment (about ODBC being an exception) mean?
Anyone interested in supporting Tab and CSV files as well. My idea is to use the SQLite3-library and to use "create temp table" foreach tab- or csv file in a certain folder.
escargo 22 Feb 2007 - My greatest interest is probably importing from Microsoft Access. Of course, there is also a need for printing, but that's not a data base issue.
LV What is used to manipulate the imported file formats? Because the tcllib csv module allows one to specify the delimiter, so that one can have comma, space, tab, bang (!), or whatever else you need delimination. I wonder whether anyone is consistently using XML notation for such data - it seems like a natural fit.
escargo 23 Feb 2007 - In fact, one of the export formats for Access is XML. (Of course, so is CSV.) I'm just trying reduce my requirements to use nonportable applications. (I really had a fondness for PowerBuilder, an RDBMS with a handy form builder as its front end. I've wondered what it would take to create a Tcl/Tk work-alike with flexible choice for the back-end DB.)