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
Comment actions Permalink

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
Comment actions Permalink

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

0
Comment actions Permalink

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

0
Comment actions Permalink

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
Comment actions Permalink

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
Comment actions Permalink

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

0
Comment actions Permalink

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
Comment actions Permalink

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.