Home Database Database Navigator
Authors:
dancioca
Apache

Database Navigator

Vendor: Dan Cioca

Email:

Website: http://www.jetbrains...T/Database+Navigator

SourceCode: link

Bugtracker page

Description:

Database development, scripting and navigation tool
This product aims to add extensive database development and maintenance capabilities to the IntelliJ IDEA development environment. Along with a qualified and IDE-compliant SQL and PL/SQL editor, it provides advanced database connection management, script execution support, database objects browsing, data and code editor, support for database compiler operations, method execution and debugging, database objects factory, as well as various navigation capabilities between all its components.
See features overview on the support page.

NEW: PL/SQL Debugger

Supported Databases:
  • Oracle
  • MySQL

For JRE5 users (MAC)
Java 5 compatible builds of the plugin are also available. Please pick the appropriate one and unpack it in the plugins directory:
  - DBN-8.0-JRE5 (for IntelliJ IDEA 8.x)
  - DBN-9.0-JRE5 (for IntelliJ IDEA 9.x)

Downloads: 17904
Rating:
Participated in rating: 10
Comment and rate
Version Since Build Until Build File/URL Size (Kb) Date Dependency
3.0.1757. 90.10000. . Download 5234. 2010-01-14 01:00:45 com.intellij.modules.lang.
3.0.1757. 80.8000. 85.9999. Download 5234.13. 2010-01-14 00:55:35 .
3.0.1741. 90.10000. . Download 5205.49. 2009-12-10 02:55:10 com.intellij.modules.lang.
3.0.1741. 80.8000. 85.9999. Download 5204.14. 2009-12-10 02:47:25 .
2.0.1391. 80.8000. . Download 4948.62. 2009-10-01 15:50:51 .
2.0.1348. 80.8000. . Download 4926.64. 2009-07-11 23:19:05 .
2.0.1301. 80.8000. . Download 4870.32. 2009-04-23 22:33:37 .
2.0.1292. 80.8000. . Download 4866.63. 2009-04-15 01:13:57 .
2.0.1285. 80.8000. . Download 4825.96. 2009-02-28 00:24:49 .
1.1.0547. 69.7126. 75.7999. Download 4726.2. 2009-02-28 00:11:44 .
1.0.509. 69.7126. 75.7999. Download 4685.05. 2009-01-26 01:04:15 .
1.0.483. 69.7126. 75.7999. Download 4633.65. 2008-12-14 01:33:55 .
1.0.474. 69.7126. 75.7999. Download 4613.87. 2008-12-11 02:16:07 .
1.0.459. 69.7126. 75.7999. Download 4597.27. 2008-12-06 00:04:42 .
1.0.390. 69.7126. 75.7999. Download 2651.25. 2008-10-07 12:05:04 .
1.0.384. 69.7126. 75.7999. Download 2648.62. 2008-09-18 12:22:28 .
1.0.321. 69.7126. 75.7999. Download 2490.2. 2008-08-09 16:12:11 .
1.0.303. 69.7126. 75.7999. Download 1261.51. 2008-07-04 00:52:35 .
1.0.286. 69.7126. 75.7999. Download 1209.21. 2008-04-09 00:46:13 .
1.0.258. 69.7126. 75.7782. Download 1174.36. 2008-04-02 04:48:27 .
1.0.237. 69.7126. . Download 1205.86. 2008-04-02 04:40:32 .
1.0.228. 60.6107. . Download 1189.51. 2008-03-21 00:57:22 .
1.0. 60.6107. . Download 932.19. 2007-11-21 04:50:11 .
. .
Database Navigator
Database Navigator
Database Navigator
Database Navigator
Database Navigator
Database Navigator

Recent change notes:

  • 3.0.1757
      - Support for CLOB editing (experimental)
      - Fixed compatibility issues with WebIDE and RubyMine
      - Discontinued DB-Module Type (compatibility issues with WebIDE)
      - Minor bug fixes
  • 3.0.1741
      - PL/SQL debugger highlighting of invalid breakpoints
      - PL/SQL debugger support for watchers and expression evaluations
      - Minor bug fixes and cosmetics
  • 3.0.1718
      - PL/SQL debugger enhancements (navigable execution frames)
      - PL/SQL language update (support for DECLARE blocks)
      - Support for PL/SQL blocks in SQL files (e.g. program ddl statements, declare blocks)
      - Critical bug fixes and minor cosmetics
  • 3.0.1658
      - PL/SQL debugger (experimental phase)
      - Compatibility upgrade to IntelliJ 9.x
      - Enhancements to compiler interface (support for debug compile)
      - Basic user role and privilege support
      - Speed search in database objects browser
      - Performance improvements thru backgroundable tasks
      - Main tool-bar actions moved to file editor header
      - Bug fixes and cosmetics
  • 2.0.1391
      - Fixed several syntactical structure definitions of the PL/SQL parser
      - Performance improvements of the identifier resolver for both SQL and PL/SQL
      - Improved sorting / grouping of the structure view model for PL/SQL editors
      - Usability enhancements of method execution history
      - Several other bug fixes
  • 2.0.1348
      - Major enhancements of the PL/SQL parser
      - Overall performance enhancements of the parsing engine
      - Record editor/viewer for dataset editors (still experimental)
      - Support for environments running on JRE5
      - Several bug fixes and cosmetics
  • 2.0.1301
      - Enhancements of the PL/SQL parser - Still BETA
      - Improved navigation in PL/SQL editors
      - Path storage for driver library - relative to project directory
      - Performance enhancements and bug fixes
  • 2.0.1292
      - PL/SQL editor enhancements (code folding, code completion, navigation) - BETA
      - Structure view for PL/SQL code
      - Navigation from package spec to declaration and backwards
      - Performance enhancements of the parsing engine (both SQL and PL/SQL)
      - Bug fixes
  • 2.0.1285
      - IntelliJ IDEA 8.x compatibility
      - Regional settings - date and number formats are now configurable (input and display)
      - Dataset editor enhancements - date and text pupups
      - Reformat code can be disabled from code style settings - code formatting still experiences issues
      - Objects factory - only functions and procedures for now
      - Minor bug fixes
  • 1.1.0547
      - Persisted editor status for code and data editors
      - MySQL method editing and execution - compatibility issues with 5.x versions
      - Object drop functionality
      - Objects factory - support for procedure and functions (work in progress)
      - Data editor - switch to readonly status and back
      - Minor bug fixes and cosmetics
  • 1.0.509
      - SQL editor - code completion enhancements
      - PL/SQL parser (work in progress)
      - DDL file binding to database objects, configurable file extensions
      - Data viewer for database views, like for tables (beta)
      - MySQL compatibility updates
      - Bug fixes
  • 1.0.483
      - Objects factory (work in progress)
      - Objects browser - performance optimizations of refresh operations
      - SQL Parser bug fixes (MySQL)
  • 1.0.474
      - Method execution engine (support for declared types)
      - Objects browser reload feature
      - Automatic reload of objects changed in data editor
  • 1.0.459
      - Dataset editor - background load operations
      - Method execution engine
      - Enable/Disable constraints and triggers feature (oracle only)
      - Bug fixes
  • 1.0.390 (EAP)
      - Fixed SQL code completion issue
      - Show compiler messages on "compile invalid objects" operation (Oracle)
      - Fixed MySQL bigint issue DBN-22
      - Minor bug fixes
  • 1.0.384 (EAP)
      - Added support for MySQL databases (including SQL specific dialect)
      - Enabled navigation and code completion in the editor for database-views
      - Virtual connections for deciding the dialect of the .sql files
      - Minor bug fixes and performance improvements
  • 1.0.321 (EAP)
      - Data export processors (output formats: excel, csv, sql insert script)
      - Enhanced SQL parser to fully support nested subqueries
      - Performance improvements on the SQL editor
      - Minor cosmetic changes
  • 1.0.303 (EAP)
      - Technical release. Major redesign of language support engine (preparation for supporting multiple SQL dialects)
      - Partially defined SQL-92 dialect (not published)
      - Enhanced the dataset editor filters
      - Context menu on the table header of the data editor (filter, sort actions)
      - "Compile invalid objects" feature
      - Structure projection for program-objects (functions, packages..) - not navigable
      - Improved "select connection" and "set current schema" editor intentions
      - Several bug fixes and usability improvements
  • 1.0.286 (EAP)
      - Code completion accuracy considerably improved
      - Added configurable sorting capability on code completion variants
      - Fine tuning on the code formatting engine (still experimental)
      - Added code style configuration to standard IDE settings
      - Added support for preferential case, built in the default code formatting operation
      - Minor bug fixes
  • 1.0.258 (EAP)
      - Improved SQL code formatting (still experimental phase)
      - Several performance improvements of the SQL editor
      - Per file current-schema selection (used to be per connection)
      - Technically redesigned the oracle meta-data loader
      - Minor bug fixes
  • 1.0.237 (EAP)
      - Dropped support for 6.0 (please advise if still needed)
      - Introduced database-module type
      - Enhanced declared type handling
  • 1.0.228 (EAP) - recommended update
      - Fixed serious memory leaks on project close
      - Added support for db-links (beta)
      - Enhanced DDL file linkage handling
      - Added support for DROP/RENAME/TRUNCATE statements in SQL editor
      - Added support for INSERT/UPDATE/DELETE statements in SQL editor
      - Dataset editor data filters
      - Persisted project DDL file mappings
      - Created product debugging feature (beta)
      - Technically redesigned the settings editor
      - Enhanced overall plug-in configurability
      - Data editor custom pop-ups on Alt+Enter (text editor and calendar pop-ups)
      - Data editor suggestions drop-down on Ctrl+Space
      - Overall usability improvements of the data editor
      - Bug fixes and performance improvements
  • 1.0 (EAP)
      - Initial release
      - Early access program

Comments:

Comment and rate
dancioca
Rated: noRate
2009-12-28 22:25:20
Thanks for the post. Was not aware that it is not working for WebIDE. I actually tested it only with community edition of intellij, and was expecting it to work with both RubyMine and WebIDE, since they have the same infrastructure. I will try to fix this in the future releases.
.
Anonymous
Rated: noRate
2009-12-28 19:50:48
Doesn't work with WebIDE 94.48.
.
dancioca
Rated: noRate
2009-04-18 07:37:30
Support for java 5 will be considered in the next release.
.
AlexLin
Rated: noRate
2009-04-17 07:23:05
It is not compatible with JDK 5.
.
dancioca
Rated: noRate
2008-08-04 21:26:34
Thanks for the feedback!
The fix for supporting nested select statements will be part of the next release. I actually identified this issue recently and was working on it.

.
Anonymous
Rated:
2008-08-04 20:47:17
Excellent plugin!
Just a thing that prevents me to use it it doesn't recognise the following expressions:

select * from table_a a
where exists (
select b.unique_id
from table_b b
where b.unique_id = a.unique_id
);

it doesn't recognise a in the nested query.
Anyway excellent work!
.
dancioca
Rated: noRate
2008-04-15 00:13:33
To the "inner/outer join" issue below:
First of all, many thanks for the appreciation!
Please submit an issue report with the details of the SQL statement you experience problems with, in the dedicated request tracker, or send me an email. I will try to solve the problem as soon as possible.
.
Anonymous
Rated:
2008-04-14 21:37:16
Excellent!

Just a sql syntax issue: it should accept the from clause inner/outer join syntax.

Again, excellent work!
.
chrs
Rated:
2008-02-11 15:54:55
Great work!

One niggle for me is the fact that it seems overzealous is finding tokens beginning with "Rem" and considering them to be comments. Shouldn't this only apply to SQL scripts and then only at the start of the line?
.
Anonymous
Rated:
2008-01-29 21:27:52
.
Anonymous
Rated:
2007-12-17 23:14:28
*thumbsup* this is amazing!
.
neox_extreme
Rated:
2007-12-12 20:55:54
This is an amazing plugin. This is one of the best integration ever. I can't resist myself to put forward some feature suggestion/request to make this plugin one of the best ever in functionality wise too.

Here goes the list :-
1. SQL Console to support users that primarily don’t write lots of stored procedures and only want to run some simple queries inside IDEA without creating any files. Users can simply open SQL Console and run any SQL queries. Multiple tabs in the SQL Console should be incorporated. Syntax highlighting and SQL code completion should also available in the SQL Console. Also implementation of templates will be a good idea as normal Idea template will not be available as this will not be an Idea native editor. This functionality is nicely existed in SQL Query plugin.
2. It would be very nice to have the feature of selecting a column in a table and have option to see the tables who have references to this selected column and also tables who is referenced by the selected column. This feature is nicely existed in SQL Query plugin.
3. Database schema diagram. File extension may be .dsd. At any time, the user can select multiple tables or a type of tables and view the schema in a graphical diagram. The diagram can be saved as .dsd format or copied as image. This feature is currently existed in DBHelper plugin.
4. In code completion for a table in SQL editor please consider select all columns of the same table by a single selection like "*". If user selects * then all the columns of that table will be copied in the editor. This will drastically reduce the effort of writing an insert/update statement where one use to write all the column names one by one. This feature is currently existed in DBHelper plugin.
5. Select a query from a properties file or java source file and paste it in the editor and have the tool remove all non-sql syntax from the text making the same ready to execute. Also have the tool recognize parameters in the SQL statement and popup a dialog when running the same requesting values for the parameters. It might be a good idea to do the data type check/validation in that dialog box. This functionality is nicely existed in SQL Query plugin(excluding the input dialog box for input parameters).
.
Anonymous
Rated:
2007-11-26 14:01:17
A standalone SQL-implementation would rock. Maybe with some configuration to tweak differences in SQL dialects, but even basic validation for standard-sql would be great.

At the moment the plugin feels too heavyweight if one doesn't need all those Oracle features... But it looks quite nice anyway ;)
.
dancioca
Rated: noRate
2007-11-22 13:27:25
This plugin will be supporting MySQL as well, and some other common databases, but i'm afraid this will not happen very soon. Earliest when i am done with the "Critical limitations" above, i can start thinking about supporting other databases.
.
Anonymous
Rated:
2007-11-22 04:25:34
so could you please add another plugin for MySQL?
.
dancioca
Rated: noRate
2007-11-21 14:03:44
To the quoted id issue below:
The problem with SQL is that it is allowing keywords as object names (identifiers). The other problem is that it has over five hundred keywords. Additionally to that it is completely case insensitive.
No parser in the world can deal with this mess, therefore one limitation of this tool is the need to quote some identifiers to distinguish them from the keywords. Code completion is doing this automatically.
So I have to disappoint you in this regard. This is and will remain a limitation of this tool.
.
Anonymous
Rated:
2007-11-21 13:31:56
Great plguin even Oracle only. Make it perfect and more guys will like it. :)
.
Anonymous
Rated:
2007-11-21 12:51:12
great plugin. :) a problem in code completion, if I choose primary key, such as id, and code completion will surround it with quotation, and id will be "id". Can you take a look at it.
.