Databrid is a database browsing, retrieval and manipulation tool for Oracle and MySql Databases. Functionality includes sql autocompletion, syntax word highlighting, sql formatting, auto case adjustment, schema browsing, save or update data in CSV
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.