Authors:
dancioca
logos
Apache

Database Navigator

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

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 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
  • PostgreSQL (early preview)



This tool is free for personal and commercial usage.
Donations are very welcome though.
Downloads: 316752
Rating:
Participated in rating: 29
Version Since Build Until Build File/URL Size (Kb) Date Details
3.0.3145. 138.1. 138.*. Download 7012.42 2014-07-26 01:41:47 details
3.0.3145. 130.1. 135.*. Download 7011.63 2014-07-26 01:39:58 details
3.0.3145. 123.1. 129.*. Download 6986.71 2014-07-26 01:38:07 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
. .
55 updates are hidden show all updates
Screenshot #570
Screenshot #568
Screenshot #573
Screenshot #572
Screenshot #571
Screenshot #569

Recent change notes:

  • 3.0.3145
      - Configurable "tracking" columns (display text attributes, visibility, editable)
      - 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>
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
.
dancioca
2013-08-24 13:02:08
Hello "longtimeago". The error is coming from the standard distribution database support not from this plugin. Please address the issue to JetBrains directly.
.
longtimeago
2013-08-24 11:17:53
I have a problem when trying to call Synchronize from Database panel, the Exception popup appears: Connection to database failed: Exception in thread "main" java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory at org.hibernate.dialect.Dialect.(Dialect.java:85) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:190) at com.intellij.persistence.database.console.RemoteJdbcServer.main(RemoteJdbcServer.java:15) Caused by: java.lang.ClassNotFoundException: org.slf4j.LoggerFactory at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 4 more IntelliJ 12.1.4
.
dancioca
2013-08-21 01:45:05
Should be compatible with Android Studio as well. Some features are broken (e.g. pl-sql debugging), but the most should be fine
.
12345..6>