############ Databrid 1.4 ############ Web Page: http://www.databrid.com ============ Introduction ============ Databrid is a Hybrid Data browsing, retrieval and manipulation tool designed for the novice to the expert users of Oracle and MySql databases. The core functionality of Databrid revolves around the tabbed areas within the Databrid application. The five tabs in the main screen of Databrid are: SQL Editor, Browser, File, Jobs and Help. ---------- SQL Editor ---------- The SQL Editor tab allows you to write and run SQL and PLSQL. The tab provides the ability to use one of more syntax highlighting editors with autocompletion to assist writing queries, automatic case adjustment for keywords, word highlighting etc. Provided with each editor is a table for displaying SQL query results and a text output area to display Oracle DBMS_Output output. Jobs can be run in the background allowing for the execution of multiple statements at any given time. ------- Browser ------- The Browser tab allows the you to browse various parts of the database schema. The browsing is done via a particular schema user and displays information on tables, views, sequences etc. Features include browsing table or view data, truncating tables, etc. For Oracle databases there is also the ability to generate database creation statements for tables, views etc. ---- File ---- The File tab allows you work with a CSV (comma delimited text file) and the database without having to load the CSV into the database. This tab has two areas that functionality: CSV Update and Database Update. CSV Update allows you to add additional columns to a CSV using a Select statement, including binding CSV column values to the Select statement. Database Update allows you to manipulate the database using insert, updates, deletes or PLSql by binding the CSV column values into your statement. ---- Jobs ---- This tab allows you to view which jobs (started from the SQL Editor and File tabs) are currently running or have finished. Jobs that are running can also be stopped. This tab displays information on how long a job has been running for/took to run, whether the job was successful and what error stopped the job running. ---- Help ---- This tab displays help information on how to use Databrid. ============= Documentation ============= Documentation is supplied in the docs directory which is in the Databrid install directory. ============ Installation ============ Before installing Databrid you need to have Java 1.4 greater installed. If you do not then you can download the latest version of Java from www.java.com ----------- Jar Install ----------- Double Click the Jar file. If you are installing Databrid from a Jar file then you can either double click on the file which should start the installation. If this does not work then try the following command using a command line tool in the directory of the Jar file. java -jar databrid_installer.jar Where databrid_installer.jar is installer that was downloaded. ---------------- Zip/GZip Install ---------------- Unpack Zip file into the required directory. For GZipped files you will also need to untar the ungzipped file. A Shortcut can be setup like those shown below. You may need to change the directory used for Databrid.jar if it is not the same as shown below. WINDOWS: cd "C:\Program Files\Databrid" javaw.exe -Xmx256m -jar databrid.jar "%CLASSPATH%" UNIX: cd /usr/bin/databrid java.exe -Xmx256m -jar ./databrid.jar "$CLASSPATH" ==== Bugs ==== If you find any bugs when using Databrid please send the following information to support@databrid.com: 1. Description of Problem. 2. The tabs, sub tab and component in which the problem occurred. 3. Instructions on how to replicate the problem. If you are unable to give instructions on how to replicate the problem then just state that you are unable to replicate the problem. =============== Changes for 1.4 =============== ------------ New Features ------------ Search file from within Databrid. The database connection can now be changed in a Databrid session. In Oracle a PLSQL can function/procedure/package can be executed using the execute command. An open file in the Sql Editor can be renamed Goto a line number within an Sql Editor. Sql syntax is now defined in external files. Users can copy and change these to suit there own purposes. ---------- Bugs Fixed ---------- Smaller memory footprint. Fix various memory leaks. Removed rogue processes. Fixed the display of Oracle TIMESTAMP data type. Fixed save as insert, no longer drops characters. Rowid in Oracle now showing correctly. =============== Changes for 1.3 =============== ------------ New Features ------------ Databrid is now FREE FREE FREE Dates are now formats in the correct locale Option to not display the splash screen ---------- Bugs Fixed ---------- Change of editor tabs now focuses on the editor Speed enhancements in the editor Fixed various bugs in the editor and sql execution =============== Changes for 1.2 =============== ------------ New Features ------------ MySql Support AutoCompletion Word Highlighting Sorting for Login Connections Commit Shown in Process Screen Rollback shown in Process Screen Foreground executes to show in jobs Login to show as window Left hand side schema information to retrieve all info cache Cursor Sorting for various schema views (i.e. table columns, view columns, tables constraints...). Drag & Drop Files and Text Close button of Sql Editor tabs ---------- Bugs Fixed ---------- * Fixed Case Sensitive Searches (Always searching case insensitive) * Fixed Replace All where find and replace string were identical (Used to go into infinite loops). * In the Replace Dialog the find string can now be replaced with nothing (before the user had to provide a replace string). * Fixed Error reporting problem that would identify the semicolon at end of a statement as being invalid even though the error was a non syntax error. * Fixed error in comment creation script for tables that would show blank comments * Problem in SQL History =============== Changes for 1.1 =============== ------------ New Features ------------ * The table columns in the Login screen can now be sorted by clicking on the header. * The Inactive jobs tab in the Jobs screen now shows commits, rollbacks and statements executed in the foreground. * The Login screen now shows as a window in Windows. * The left hand side lists in the schema browser screen now retrieve all data, rather than retrieving them as you scroll down the list. * The data shown in tables is now cached in Databrid to improve access times * In the Browser screen the table columns for various schema views (columns, grants, indexes (top list only) and constraints (top list only)) are now sortable by clicking on the header. * Files can be opened in the Sql Editor screen by dragging and dropping files onto an existing editor (a new editor is opened) or by dropping the file onto the blank screen, if all editors are closed. * The editors in the Sql Editor screen now have Close buttons on the tabs. * In the Replace Dialog the find string can now be replaced with nothing (before the user had to provide a replace string). ---------- Bugs Fixed ---------- * Fixed Case Sensitive Searches (Always searching case insensitive). * Fixed Replace All where find and replace string were identical (Used to go into infinite loops). * Fixed Error reporting problem that would identify the semicolon at end of a statement as being invalid even though the error was a non syntax error. * Fixed error in comment creation script for tables that would show blank comments. * SQL History is now reliably adding each statement that is executed. * About screen not displaying