DB Plugins - which one?

Does anyone have a suggestion for which DB plugin to use? There seems to be 3 that would be useful to me (DBHelper, Database Navigator, SQL Query Plugin). What's the difference? I've been writing more SQL and PL/SQL lately and could use a good tool besides TOAD. Thanks in advance for any insight.

2 comments
Comment actions Permalink

I think nothing beats TOAD :)

Idea is better in CVS integration of course, so I was using Idea only as an advanced editor with CVS capabilities, thus I only needed something to highlight PL/SQL syntax.
I was using SQL Script Editor for it, but it was horribly slow on larger files (it took seconds to type a single character in 2500 lines file)

Now I switched to DBHelper and it is as snappy as the rest of IDEA, even on those larger files. It has plenty of other features that I am not using at all, maybe give it a try.

0
Comment actions Permalink

Thanks for your thoughts. I was interested in DB Navigator since it
supposedly has code completion, navigation, etc... but the first sql file I
opened was full of "good code marked bad". I have tried DBHelper and it's
code highlighting is good so I'll probably just stick with that and TOAD for
anything more than a small edit.

"Adam" <no_reply@jetbrains.com> wrote in message
news:12534885.1196947983357.JavaMail.itn@is.intellij.net...
>I think nothing beats TOAD :)
>

Idea is better in CVS integration of course, so I was using Idea only as
an advanced editor with CVS capabilities, thus I only needed something to
highlight PL/SQL syntax.
I was using SQL Script Editor for it, but it was horribly slow on larger
files (it took seconds to type a single character in 2500 lines file)

>

Now I switched to DBHelper and it is as snappy as the rest of IDEA, even
on those larger files. It has plenty of other features that I am not using
at all, maybe give it a try.



0

Please sign in to leave a comment.