DaFT Screenshot (Theme ITFT1)

eXTReMe Tracker

RSSFeeds:

Project news releases

RSS Feed Available

Project file releases

RSS Feed Available

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: 3 cows
InfoWeek.ch  Rating: 6 stars
Businesssoftwareland.com: 5 stars
Brothersoft.com: 5 shields

 

SourceForge.net Logo

 

Links

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.