Authors:
dancioca
logos
Apache

Database Navigator

Products: IntelliJ IDEA, RubyMine, WebStorm, PhpStorm, PyCharm, AppCode, Android Studio, 0xDBE, CLion

Vendor: Dan Cioca

Email:

Website: http://www.jetbrains.net...NTEST/Database+Navigator

SourceCode: src.zip

License: http://www.apache.org/licenses/LICENSE-2.0.html

Bugtracker page

Description:

Database development, scripting and navigation tool
This product adds extensive database development and maintenance capabilities to the IntelliJ IDEA development environment and related products. 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.

Supported Databases:
  • Oracle
  • MySQL
  • PostgreSQL (early preview)



This tool is free for personal and commercial usage.
Donations are very welcome though.
Downloads: 417411
Rating:
Participated in rating: 30
Version Since Build Until Build File/URL Size (Kb) Date Details
3.0.3441. 138.1. 139.*. Download 7183.1 2014-10-30 00:02:28 details
3.0.3441. 130.1. 135.*. Download 7183.41 2014-10-30 00:01:43 details
3.0.3441. 123.1. 129.*. Download 7151.4 2014-10-30 00:00:34 details
3.0.3145. 111.1. 122.*. Download 6992.04 2014-07-26 01:36:52 details
3.0.2686. 120.1. 129.*. Download 6597.52 2014-04-08 21:31:08 details
3.0.2686. 97.1. 107.*. Download 6599.02 2014-04-08 21:28:50 details
3.0.2630. 111.1. 130.1180. Download 6407.51 2013-08-01 02:51:16 details
3.0.2501. 93.1. 95.*. Download 6341.73 2013-03-31 05:30:24 details
3.0.2017. 110.1. 110.*. Download 5941.48 2011-11-15 23:26:51 details
3.0.1804. 80.8000. 85.*. Download 5345.17 2010-09-11 02:31:36 details
1.1.0547. 69.7126. 75.7999. Download 4726.2 2009-02-28 00:11:44 details
. .
76 updates are hidden show all updates
Screenshot #570
Screenshot #568
Screenshot #569
Screenshot #573
Screenshot #571
Screenshot #572

Recent change notes:

  • 3.0.3441
      - Language support for XML functions (Oracle)
      - Code completion support for locally defined objects
      - Various bug fixes
  • 3.0.3401
      - Support for latest IntelliJ EAP version
      - Support for default project configuration (including connections)
      - Discontinued connection setup on module level
      - Compile error outputs on DDL script execution (Oracle)
      - Support for manually controlled database connectivity
      - Improved statement execution result linkage
      - Improved focus logic on statement execution
      - Various bug fixes and optimizations
  • 3.0.3305
      - Support connecting on demand only (i.e. disable auto-connect)
      - Support for multiple SQL consoles per connection
      - "Save Console To File" functionality
      - Statement execution shortcut improvements
      - Support for Oracle trigger syntax
      - Support for Oracle explain plan syntax
      - Bug fixes
  • 3.0.3272
      - Support for anonymous "begin / end" blocks (Oracle)
      - Support for alternative delimiter configuration (MySQL)
      - "Hide empty schemas" feature for object browser
      - MySQL DDL file support
      - DDL file formatting and configuration enhancements
      - Structure view enhancements
      - Language parsers support for database versions (postgres)
      - Bug fixes and performance improvements
  • 3.0.3192
      - Configurable "tracking" columns (display text attributes, visibility, editable)
      - Datagrid sorting settings (nulls first/last, max number of sorting columns)
      - Postgres table editor (support for Array editing)
      - Postgres SQL language (additional statements support)
      - Oracle SQL (support PIVOT clause)
      - Discontinued support for IntelliJ IDEA 11.x and related products
      - Bug fixes and performance improvements
  • 3.0.3145
      - PostgreSQL support (work in progress)
      - Multiple column sorting in dataset editor and query results (Ctrl-Click)
      - Dataset Editor - hide / move columns (persistent state)
      - Improved object lookup functionality (Ctrl-Shift-D)
      - Copy / Paste feature for connection settings
      - Metadata layer performance improvements (use prepared statements)
      - Support for latest IntelliJ IDEA EAP versions
      - Discontinued support for IntelliJ IDEA 10.x and related products
      - Bug fixes and performance improvements
  • 3.0.2686
      - Support for latest IntelliJ version
      - Live Templates Ctrl-J (work in progress)
      - "About" page (with "donate" link)
      - Multiple column sorting (work in progress - not released)
      - Method execution result improvements (tree view)
      - Reworked action system to allow multiple editor instances, split and detached editors
      - Bug fixes and performance improvements
  • 3.0.2530
      - Support for error reporting directly from IDE
      - Connection timeout and idle time management
      - Memory management improvements (fixed memory leaks on project close)
      - Improved performance for database object lookup (Ctrl+Shift+D)
      - Compatibility with latest IDE version (including EAP)
      - New Icon set (work in progress)
      - Support for dark scheme
      - Minor bug fixes and performance improvements
      - Discontinued support for IntelliJ IDEA 9.x and related products
  • 3.0.2349
      - Code formatting (Experimental - work in progress)
      - Customizable data-grid colors and fonts
      - Uncommitted changes overview / prompt dialogs
      - Balloon notifications and activiy log entries for several operations
      - Connection Auto-Commit support
      - Support for IntelliJ 12 EAP release
      - Fixed broken user interface with PyCharm and RubyMine
      - Minor bug fixes
  • 3.0.2191
      - Support for IntelliJ 11 release
      - Configurable datbase environments / environment colors
      - Data grid preview popup for BLOB/CLOBs
      - Data search functionality in dataset editors and query results (experimental)
      - Minor bug fixes
  • 3.0.2017
      - Support for latest IntelliJ EAP versions
      - Statement generation engine (extract select, insert, ddl statements)
      - Fixes of BLOB editing support
      - Support for database content encoding
      - Data Editor - navigate to referenced record
      - Navigation bar improvement for DB objects
      - XML Data Export format
      - Custom number and date/time formats in locale settings
      - Connection setup enhancements (NOTE: you may lose connection custom properties)
      - Minor bug fixes
  • 3.0.1911
      - Fixed compatibility issues with Ruby plugin
      - Support for IDEA 10.5 release
      - General bug fixes and performance improvements
  • 3.0.1898
      - recommended upgrade if you are using 3.0.1895
      - Support for IDEA X EAP releases
      - Configuration framework changes (NOTE: some of your settings may be reset to default)
      - Object name filters (e.g. Schema filters) on connection level
      - Object type filters on connection level
      - Ability to activate/deactivate connections
      - Oracle OS authentication
      - Fixed memory leak issues with large result-sets
      - General bug fixes and performance improvements
  • 3.0.1870
      - Quick SQL sandbox (SQL Console for database connections)
      - Show object detailed information (configurable)
      - Added support for SQL ISO-92 (work in progress - not usable yet)
      - Minor bug fixes
  • 3.0.1856
      - Added support for IntelliJ IDEA X (BETA)
      - Discontinued support for IDEA 8.x
      - Improved navigation within PL/SQL code
      - Added code completion for variables and method parameters in PL/SQL code
      - Enhanced database object compiler handling (keep current debug status)
      - Improved object lookup functionality (select connection prompt)
      - Added navigation-bar support for database objects (experimental)
      - Fixed xls data export for select statement results
      - Enhanced xls export data format (make use of regional settings)
      - Added HTML data export processor
      - Persisted data export options
      - Object properties (work in progress)
      - Minor bug fixes
  • 3.0.1804
      - Database object lookup (Ctrl-Shift-D) - Experimental phase
      - Improved Debugger breakpoint handling
      - Compatibility version constraint (no support for IDEA X yet)
      - Minor bug fixes
See full release notes

Comments:

12345..6>
dancioca
2014-10-15 11:42:43
Version 3.0.3385 is a bit unstable. Work is in progress for a new more stable release. Thanks for the patience.
.
dancioca
2014-09-16 16:46:08
Shortcut for execution of statement under caret can be configured (Settings > Keymap > Plug-ins > Database Navigator > "Script Editor - Execute Statement")
.
Anonymous
Rated:
2014-09-12 19:10:31
Can i set a key to execute the query which i'm positioned in?
.
kstenschke
Rated:
2014-06-25 13:27:16
Thanks a lot for this very helpful plugin!
.
Anonymous
Rated:
2014-05-22 09:37:24
Awesome product. Is this still under development?
.
Anonymous
2014-04-11 20:36:24
I've downloaded it, but I don't see any instructions on how to install it and get it up and running
.
Anonymous
Rated:
2014-03-19 18:14:25
The tool is really nice nad works like a charm - but it is not compatible with the current IntelliJ 13.1 :(
.
dancioca
2014-01-14 19:01:30
Hi dtrucken. No font size configuration for the plugin itself. But for the entire IDE (Settings > Appearance > Override default fonts by > Size). For the editor as well (Settings > Editor > Colors & Fonts > Font > ...). The font changes should be reflected in the plugin components.
.
dtrucken
Rated:
2014-01-11 01:56:32
I love it. Is there any way to control the font size in this plugin? I'm using UI-133-471?
.
antony.stubbs
Rated:
2014-01-11 00:18:51
Doesn't support postgres. please vote on: DBN-205 Support Postgres http://dci.myjetbrains.com/youtrack/issue/DBN-205
.
Anonymous
2013-11-28 22:12:29
Great work! Is it possible to work with column comments? I can't even see them :( Thank you!
.
Rayz
2013-11-21 16:57:36
Doesn't work with IntelliJ IDEA Build 133.79
.
Rayz
2013-11-19 13:57:35
Hi. On Intellij IDEA build 132.1045, I can't get the dialog box to display. Clicking the button results in an error: com.dci.intellij.dbn.connection.config.ui.ConnectionDetailSettingsForm$2.append(Ljava/lang/String;)V: com.dci.intellij.dbn.connection.config.ui.ConnectionDetailSettingsForm$2.append(Ljava/lang/String;)V java.lang.NoSuchMethodError: com.dci.intellij.dbn.connection.config.ui.ConnectionDetailSettingsForm$2.append(Ljava/lang/String;)V at com.dci.intellij.dbn.connection.config.ui.ConnectionDetailSettingsForm$2.customizeCellRenderer(ConnectionDetailSettingsForm.java:122) at com.intellij.ui.ColoredListCellRenderer.getListCellRendererComponent(ColoredListCellRenderer.java:64) at .....
.
refrito
Rated:
2013-11-16 07:22:34
Hi, I love the plugin, but I'm having a problem. I have a Joomla database and the default dates are represented like 0000-00-00 00:00:00. When I try to open a table with such a date I get the error: Database error message: Value '000-00-00 00:00:00' can not be represented as java.sql.Timestamp. How can I make it accept this date without canhging the table values? Regards Federico Franco
.
longtimeago
2013-08-24 22:07:13
ups, sorry
.
12345..6>