What: 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 to be done soon.
 Who: Dr. Detlef Groth

[http://www.dgroth.de/img/dgDBBrowser.gif]

 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?

[DDG] This comment means, that I am in doubt that I can port the ODBC extension to any other OS than Windows.

----

[DDG]

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.

[DDG] Have you tried to register your Access-Database as an ODBC-Database inside the System-Administration Panel of Windows. If you succeed you can open the Access-File inside the dgDBBrowser like any other ODBC-compatible database.

''[escargo] 26 Feb 2007'' - No, I hadn't tried that.  I only wanted to import the Access data base once, and then
be completely separated from it.  But you are certainly right that such a connection would be a good way to do it.

----

[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.

----
[DDG] There is no XML-support planned, the CSV-Import is handmade, it's not to difficult to implement.


''[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.)
----

   * [Metakit]
   * [Mysql]
   * [ODBC]
   * [Oracle]
   * [Postgres]
   * [SQLite] version 2 and 3

----
[Category Application] | [Category Database]