############ Databrid 1.6 ############ Web Page: http://www.databrid.com ============ Introduction ============ Databrid is a Database tool for Oracle and/or MySql databases that is suited to all levels of users. Databrids core functionality is based around a main set of tabs that allow access to the following areas: SQL Editor, Database Browser, File Processing, Active/Inactive Jobs and Help. The application (apart from the help) supports English, Spanish, French and German. ---------- SQL Editor ---------- The SQL Editor tab allows you to write and run SQL and/or PLSQL (for Oracle). This tab provides the ability to use one of more syntax highlighting editors with code autocompletion, automatic case adjustment of keywords, word highlighting, sql formatting etc. Each editor includes an area for displaying query results and/or Oracle DBMS_Output output. Each editor can belong to its own database connection and to the same or different databases (MySql or Oracle). ---------------- Database Browser ---------------- The Database Browser tab allows the you to browse through the objects in one or more database schemas or catalogs. You are ables view information on tables, views, sequences etc that are relevant to your database connection. Database objects and/or data can also be manipulated from this tab. For Oracle databases Databrid will produce relevant SQL and/or PLSQL code for generating the selected object. --------------- File Processing --------------- This tab allows the user to work with data from a CSV(comma delimited text file) file to load data into the database or add additional information to the CSV. Manipulation or data loading is done using SQL or PLSQL statements that can be bound to the data in each line of the CSV. -------------------- Active/Inactive Jobs -------------------- This tab shows details about SQL and PLSQL statements run in either the SQL Editor or File tabs. Details include time taken so far, success status, error messages, time taken, statement run. It is also possible to stop jobs that are currently running. ---- Help ---- This tab displays help information on how to use Databrid. This is in English only. ============= 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 -jar databrid.jar "%CLASSPATH%" UNIX: cd /usr/bin/databrid java -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.6 =============== ------------ New Features ------------ * Databrid is now multi-language, with support for English, German, Spanish and French. Unfortunately help pages are only available in English. * SQL Formatting * Caching of autocompletion data to speed up display times. * Auto login at startup saves having to open the same connection(s) each time. * Command line tool for exporting data in a table as insert statements. * Browser object type lists (i.e. tables, views etc) allow selection by typing the name in the list. * Dramatic increase in speend of doing insert and updates in File tab. * Data can be saved as update statements. ---------- Bugs Fixed ---------- * Reconnecting in MySql now sets the correct catalog in the editor. * MySql 'save as insert statements' now correctly outputs date and datetime data. * Minor error fixes. =============== Changes for 1.5 =============== ------------ New Features ------------ * Databrid is now a multi-connection database tool. * Print editor functionality (with print preview). * A connection (Oracle or MySql) is now associated with an Sql Editor. An editors connection can be change or shared with another connection. * You can now browse the database in more than one connection (Oracle or MySql). * You can now have more than one File processing tab open, each with its own independant connection (no problem with commits in this tab affecting other areas of Databrid). * The current line is now highlighted, making navigation and reading of code easier. * Aliases can not be used to save typing. Type sw followed by shift-space and sw will be replaced by SELECT xx FROM yy WHERE zz. Aliases are defined in the preferences. * More functions have been added to the Browser tab views. * Table/View data can now be edited in either the Sql Editor result or Browser table/view data views. ---------- Bugs Fixed ---------- * Dates in insert statements for MySql are now generated correctly. * Multiple other small bugs have also been fixed. =============== Changes for 1.4 =============== ------------ New Features ------------ * Search files 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 ------------ * Dates are now formats in the correct locale * Option to not display the splash screen * Removed Nag screens ---------- 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