Check out the brand new DBHelper database plugin to extend IDEA!!!!!

Features:
1) Integrated, syntax highlighted SQL editor, same as Java editors in side IDEA
2) Integrated Database schema reverse engineering and graphical viewer
3) SQL code completion
4) Support any JDBC/ODBC database
5) Save and export queries
6) Add new features using Velocity templates
7) Find usages of tables and stored procedures
8) More to discover and come...
9) Complete help file and template examples
10) Free to use

http://plugins.intellij.net/plugin/?id=1120

8 comments

Very useful plug-in :)

+ But please group your menu entries into a group. If you don't know how to do yet, please check this: http://intellij.net/forums/thread.jspa?threadID=260485&tstart=0
+ And it will be better if Add database dialog have a Cancel or Close button, rather than it only has X button to close. Same with Edit database profile.
+ OK button in Add database dialog should change to Add.
+ "Reminder!" should be change to "About"

And how can I add new JDBC drivers?

0

And I have an exception with latest DBHelper in latest IDEA 6.0.2 EAP (don't remember how to reproduce it)

0

Seems this exception is thrown when I click "+" sign before Advanced, General, ... in Add Database dialog.

0

Please read the html help included in the zip file. Basically you need to
1) Add new jar files
2) Selected the class name from the driver field

0

Why not use the built in datasources definitions in IDEA?

Also,some release notes and a better description in the plugin.xml would be useful. The plugin sounds vaguely interesting, but the description here is way more likely to make me try it than the rather terse and vague description in plugin manager.

0

All other folders (help, templates, extension) should keep inside your plug-in folder

0

After selecting a database, I create a SQL file then type: SELECT * FROM (Ctrl + Space), DBHelper will list all database on the server I already connected. It should list tables' name only because I connected to a specified database.

0

I didn't know IDEA has a build-in data source configuration. Also I want this plugin can be ported to other Java editors, so IDEA specific code are minimized.

0

Please sign in to leave a comment.