It will make writing SQL a pleasure. I don't really want JB to do it but most of the T-SQL editors on the market do not help as much as they can. Intellisense on DB tables\objects, function help, sophisticated formatting\style enforcement, standard templates, complexity evaluation...
There's almost certainly market room for an IDEA-quality database development tool. A tool that was written by someone who understood database developers and database administrators, rather than just database interfaces, could be very powerful indeed. Completion, navigation, refactorings, and inspections would all be valuable in SQL.
Now that I think about it, the best way to develop such a tool would be as an SQL plugin to IDEA, using the new language API. Having the ability to recognize Java string constants and properties file values as SQL queries and updates, with all the tools and toys that implies, could deeply rule.
There's almost certainly market room for an IDEA-quality database development tool. A tool that was written by someone who understood database developers and database administrators, rather than just database interfaces, could be very powerful indeed. Completion, navigation, refactorings, and inspections would all be valuable in SQL.
>
Now that I think about it, the best way to develop such a tool would be as an SQL plugin to IDEA, using the new language API. Having the ability to recognize Java string constants and properties file values as SQL queries and updates, with all the tools and toys that implies, could deeply rule.
With a picked team of four (db guru, swing guru, usability/product management god, and myself on plugin-code, parser, and QA) and six months paid, I think I could do it, and turn out something with a maximum of "Wow!". Sadly, that just doesn't fit into my life at this time.
Pal Hoye wrote:
That does what?
Ciao,
Gordon
--
Gordon Tyler (Software Developer)
Quest Software <http://www.quest.com/>
260 King Street East, Toronto, Ontario M5A 4L5, Canada
Voice: (416) 933-5046 | Fax: (416) 933-5001
It will make writing SQL a pleasure. I don't really want JB to do it but most of the T-SQL editors on the market do not help as much as they can. Intellisense on DB tables\objects, function help, sophisticated formatting\style enforcement, standard templates, complexity evaluation...
There's almost certainly market room for an IDEA-quality database development tool. A tool that was written by someone who understood database developers and database administrators, rather than just database interfaces, could be very powerful indeed. Completion, navigation, refactorings, and inspections would all be valuable in SQL.
Now that I think about it, the best way to develop such a tool would be as an SQL plugin to IDEA, using the new language API. Having the ability to recognize Java string constants and properties file values as SQL queries and updates, with all the tools and toys that implies, could deeply rule.
--Dave Griffith
+ 1000. Get on it Dave.
"Dave Griffith" <dave.griffith@cnn.com> wrote in message
news:17711293.1120605209460.JavaMail.itn@is.intellij.net...
>
>
1 , but I'd prefer to see a better IDEADB integration, like JDevelopper for instance. So +1000 for a better IDEA DB plugin.
With a picked team of four (db guru, swing guru, usability/product management god, and myself on plugin-code, parser, and QA) and six months paid, I think I could do it, and turn out something with a maximum of "Wow!". Sadly, that just doesn't fit into my life at this time.
--Dave Griffith
Exactly!
You guys got my point: ctrl+n to navigate to the table, intellisense when writing sql, and syntax/error highlighting, etc.