|
What is the Database Fishing Tool?
Database Fishing Tool (DaFT) is a front-end to any database that can be connected to with an ODBC driver.
DaFT allows you to browse the database objects, view data in tables and views, and create and execute SQL
statements, also as a script, including variable scanning.
DaFT contains a database objects list (tables and views), list of columns and column properties, a table
for data snapshots, detailed data view, a notepad, a table for viewing the outcome of select statements,
T-SQL or PL/SQL statements, a SQL statement editor with syntax highlighting, and a screen to follow all
ODBC driver messages (errors etc.).
All selected data can be saved into a file. The supported file formats are HTML, XLS, CSV, SyLK, and DIF.
The SQL statements can be saved into a text file.
Multi Platform
DaFT is available for Linux and Windows.
-
For Windows the executable installation file and an ODBC driver for your database is all you need
-
For Linux you need a rpm-file for your distribution, a unixODBC installation and a unixODBC driver for your
database(s)
Open Source
DaFT is licensed under the GNU
GPL
license. This means the software is free, and you get the source code with it. The program is distibuted as a
metakit
combined with
tclkit
to run the kit file. So you can easily unwrap it with
sdx
. After unwrapping you can modify the source code and wrap it again, or run it as a
Tcl/Tk
script; DaFT is written in Tcl/Tk.
DaFT on other websites
Sourceforge.net
The project page of DaFT can be found at
http://sourceforge.net/projects/daft
. On this page you can find the
files
,
forums
,
mailinglists
, and
news
.
Recommendations
Database Fishing Tool version 1.0:
Tucows.com Rating:
|
|
InfoWeek.ch Rating:
|
|
Businesssoftwareland.com:
|
|
Brothersoft.com:
|
|
Links
|
New Version: 1.4.8.1
Released: 08 OCT 2010
This is a minor release, with some major bugfixes.
-
Fixed an issue with column information with non-English ODBC driver
-
Fixed the problem with data sheet column headings for new query results
Download
Release Notes
New Version: 1.4.3
Released: 06 JUN 2006
This is a minor release, in which the following new features are included:
-
Handle Tables, Views, and colums with names (partly) in capitals with surrounding quotes.
-
Some bug fixes...
Download
Release Notes
New Version: 1.4.2
Released: 06 FEB 2006
This is a major release, in which the following new features are included:
-
Tables and views tree view
-
Colums and index tree views
-
Include the database table or view owner
-
SQL Editor margin and statement indicator
-
Use of the Tile library version 0.7.2
Download
Release Notes
New Version: 1.3.2
Released: 04 JUL 2005
New features:
-
Automatic reloading of the database objects when the database is changed within the same connection. This
configurable per ODBC driver type
-
on-standard statements (i.e. not select,insert,update or delete)
will by default not be handled by a database fetch, unless executed as a "single statement" which is necessary when
stored procedures are called.
New Version: 1.3.1
Released: 03 JUN 2005
New features:
-
Themes!
-
Fixed a few bugs in the Project functionality
-
Fixed a bug with loading NonStop ODBC driver
-
Fixed a bug showing table indices
Previous Version: 1.2.1
Released: 11 APR 2005
New features:
-
Execution of selected text, useful for testing a block of T-SQL or PL/SQL code
-
Colored lines in de log messages, indicating errors, OK messages, or ODBC messages
-
Undo/Redo (Ctr-z/Ctr-y) for the SQL-Pad and SQL-Statement editor
-
Tip of the day
-
Check for new version
-
Improved and additional menu's and icons
-
Bypassing of date/time conversion
-
All statement output, except for insert, update, and delete statements, are send to the Data table view
-
Automatic creation of profil.dft backup file, locking, and recovery
-
Progress bars indicating script execution or script creation progress
-
A user configurable setting indicating the number of records at wich point the user must be asked to stop further
retrieving of any records.
-
Clear buttons for tables and Log Messages
-
A new function on top of the statement history stack for remembering current statement and blanc the SQL Editor.
-
Improved INSERT script creation dialog, which enables the created script to be copied into the SQL Editor at once, ready
for execution on another database.
-
Improved Date/Time handling functions when creating INSERT scripts. The user now has the possibility to map datetime
fields to a predefined format, and define which statement in the INSERT line should be used to reformat this date value
(a string) to the target database native format.
|