Home Database Database Navigator
Authors:
dancioca
logos
Apache

Database Navigator

Products: IntelliJ IDEA, AppCode, PhpStorm, PyCharm, RubyMine, WebStorm

Vendor: Dan Cioca

Email:

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

SourceCode: http://database-navigato...ooglecode.com/svn/trunk/

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.

Supported Databases:
  • Oracle
  • MySQL



This tool is free for personal and commercial usage.
Donations are very welcome though.

Downloads: 134384
Rating:
Participated in rating: 25
Comment and rate
Version Since Build Until Build File/URL Size (Kb) Date Details
3.0.2570. 111.1. 129.9999. Download 6399.92 2013-05-13 04:09:52 details
3.0.2570. 97.1. 107.9999. Download 6401.96 2013-05-13 04:08:55 details
3.0.2501. 93.1. 95.9999. Download 6341.73 2013-03-31 05:30:24 details
3.0.2017. 110.1. 110.9999. Download 5941.48 2011-11-15 23:26:51 details
3.0.1804. 80.8000. 85.9999. 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
. .
21 updates are hidden show all updates
Screenshot #573
Screenshot #571
Screenshot #572
Screenshot #568
Screenshot #570
Screenshot #569

Recent change notes:

  • 3.0.2570
      - "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:

Comment and rate
12345>
dancioca
Rated: noRate
2013-03-16 11:29:59
Hi Oleg. Not quite sure i understand what you try to achieve. Can you please file a feature request in the request tracker (http://code.google.com/p/database-navigator/issues/list) explaining your use-case in detail. Thanks a lot!
.
OlegYch
Rated:
2013-03-16 02:24:03
thanks for the great plugin one thing that really bothers me though - how do i execute insert/show/anything else rather than select in sql console?
.
dancioca
Rated: noRate
2013-03-15 20:58:48
Thanks for the rating and issue report. A redesign of connection life cycle along with timeout considerations are planned for the upcoming releases.
.
dscherbakov
Rated:
2013-03-15 17:37:07
Excellent tool. The only problem I have is hanging for a very long time while trying to disconnect connection that is already lost to that time. All activity in Idea hangs for 10-20 minutes. I can't even shut down idea to restart it.
.
dancioca
Rated: noRate
2012-07-24 18:46:07
Will provide a fix for the initialization problems below as soon as possible. Sorry for the inconveniences.
.
dancioca
Rated: noRate
2012-07-24 12:47:28
Hello issamovDgui, Thanks for the issue report. Have created the ticket http://www.jetbrains.net/jira/browse/DBN-50. Would appreciate if you could upload the idea.log file so I can investigate the reasons. Looks like an initialization problem very specific to your project. I could not reproduce it on my environments so far. Thanks a lot for your support.
.
issamovDgui
Rated: noRate
2012-07-24 12:20:59
I installed the latest version of this plugin and it's not working for me, I click on Db Browser I get this error: null java.lang.NullPointerException at com.dci.intellij.dbn.browser.ui.TabbedBrowserForm.initTabs(TabbedBrowserForm.java:57) at com.dci.intellij.dbn.browser.ui.TabbedBrowserForm.(TabbedBrowserForm.java:30) at com.dci.intellij.dbn.browser.ui.BrowserToolWindowForm.initBrowserForm(BrowserToolWindowForm.java:59) at com.dci.intellij.dbn.browser.ui.BrowserToolWindowForm.(BrowserToolWindowForm.java:41) at com.dci.intellij.dbn.browser.DatabaseBrowserManager.getToolWindowForm(DatabaseBrowserManager.java:86) at com.dci.intellij.dbn.browser.DatabaseBrowserToolWindowFactory.createToolWindowContent(DatabaseBrowserToolWindowFactory.java:15) at com.intellij.openapi.wm.impl.ToolWindowImpl.ensureContentInitialized(ToolWindowImpl.java:445) at com.intellij.openapi.wm.impl.ToolWindowManagerImpl$11$1.run(ToolWindowManagerImpl.java:500) at com.intellij.openapi.application.impl.LaterInvocator$FlushQueue.run(LaterInvocator.java:333) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646) at java.awt.EventQueue.access$000(EventQueue.java:84) at java.awt.EventQueue$1.run(EventQueue.java:607) at java.awt.EventQueue$1.run(EventQueue.java:605) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:616) at com.intellij.ide.IdeEventQueue.e(IdeEventQueue.java:699) at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:538) at com.intellij.ide.IdeEventQueue.b(IdeEventQueue.java:420) at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:378) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) It does not work for me with Intellij Idea 11.1 build 117.147 and Intellij Idea 12 Any idea about this error? thanks in advance.
.
dancioca
Rated: noRate
2012-04-18 03:18:20
Hello rcjkierkels,
Thanks for your support! The issue was the "dot" in your schema name. Was not expecting this to be a valid character in database object names. I released a quick fix to this particular problem. If you encounter further issues please file bug reports in the dedicated request tracker, so you can track their progress at any time.
Thanks again, Dan
.
rcjkierkels
Rated: noRate
2012-04-17 22:32:07
Thanks for the reply!
I uploaded a video that shows exactly the steps until the error occurs.

http://youtu.be/sWTchIC49IA

I hope that helps!
.
dancioca
Rated: noRate
2012-04-17 13:57:19
Hello rcjkierkels,
Can you please specify the versions you are using (both DBNavigator and IDE)? I was not able to reproduce this issue.
Thanks, Dan
.
rcjkierkels
Rated:
2012-04-15 20:50:36
Seems to be a very good plugin but for me its not working at all.

What have i done:
I have setup my mysql database connection and tested the connection. It works so far.
I added a schema filter so that only one database is loaded from my server.
Now when i click to open the DB browser window i see all the tables. When i double click at a table name or choose 'edit data' phpstorm tries to load the data but then crashes throwing this error:

null
java.lang.NullPointerException
at com.dci.intellij.dbn.editor.data.filter.ui.DatasetFilterForm.(DatasetFilterForm.java:47)
at com.dci.intellij.dbn.editor.data.filter.DatasetFilterGroup.createConfigurationEditor(DatasetFilterGroup.java:271)
at com.dci.intellij.dbn.editor.data.filter.ui.DatasetFilterDialog.construct(DatasetFilterDialog.java:57)
at com.dci.intellij.dbn.editor.data.filter.ui.DatasetFilterDialog.(DatasetFilterDialog.java:28)
at com.dci.intellij.dbn.editor.data.filter.DatasetFilterManager.openFiltersDialog(DatasetFilterManager.java:40)
at com.dci.intellij.dbn.vfs.DatabaseEditableObjectFile.preOpen(DatabaseEditableObjectFile.java:70)
at com.dci.intellij.dbn.vfs.DatabaseFileSystem$3.run(DatabaseFileSystem.java:300)
at com.intellij.openapi.application.impl.LaterInvocator$FlushQueue.run(LaterInvocator.java:333)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:607)
at java.awt.EventQueue$1.run(EventQueue.java:605)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:616)
at com.intellij.ide.IdeEventQueue.e(IdeEventQueue.java:699)
at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:538)
at com.intellij.ide.IdeEventQueue.b(IdeEventQueue.java:420)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:378)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
.
tufan
Rated:
2012-02-14 12:10:04
very good plugin, would love to see it with PostgreSQL support.
.
burhanahmed92
Rated: noRate
2011-12-13 11:37:25
I am using WAMP as a local server plz tell me how to configure database navigator in phpstorm in wamp. Also i want it to remotely connect to my web server databases. Plz help
.
pbyrne84
Rated:
2011-10-12 20:48:47
Great plugin. Makes editing PL/SQL much more enjoyable and cost efficient.

Any chance of an update for phpstorm3/intellij 11 EAPs? We do a lot of PL/SQL so we really appreciate this plugin.
.
adeel.shahzad
Rated:
2011-07-06 09:27:03
I UNABLE TO CONNECT TO MYSQL DATABASE. MY IS SETTING IS LIKE THAT:
NAME: CRUD
DESCRIPTION: TESTING CONNECTION
DRIVER LIBRARY: C:\wamp\www\mysql-connector-java-5.1.15-bin.jar
DRIVER: COM.MYSQL.JDBC.DRIVER
URL: "jdbc:mysql://localhost:8889/"
USERNAME: ROOT
PASSWORD: ROOT

PLEASE TELL ME THE SOLUTION OTHERWISE I WILL JUMP TO NETBEANS WHICH I DON WANNA BE. PHPSTORM IS FABOLOUS BUT HERE I FACE THE MUD
.
12345>