SQL Dialect support

Hello Shorn,

I understand the SQL dialect is a work in progress and dialects are
being added as they can be.

Will there be any support for custom dialects?

We run a fairly rare database here at my current work (Ingres).

So I imagine it would be low on the list of dialects to implement (if
at all, and that would be completely understandable).

So will I be able to write my own dialect support for IDEA?

Yes, but it will require writing a plugin with a custom parser, and getting
a fully working parser has turned out to be quite time-consuming (several
weeks of full-time work, depending on how much custom stuff is in the dialect).

Also, any plans for a HSQLDB dialect?

Not in version 8. Don't know about later releases.

--
Dmitry Jemerov
Development Lead
JetBrains, Inc.
http://www.jetbrains.com/
"Develop with Pleasure!"

Thanks for the quick answer Dmitry.

Hey, as long as you make the API accessible, give good doco and maybe a tutorial/example made up of the current dialect implementations, I'm sure the community will come out with some useful stuff.

Also, how can I get rid of the dreaded "red squigglies"?
The SQL fragments that IDEA doesn't understand in my SQL are being marked as errors, and I can't figure out how to turn that off (acutally I'd prefer to just turn it down to a warning, but searching in the inspections stuff isn't finding anything).

Cheers,
Shorn.

Edited by: Shorn Tolley on Oct 9, 2008 10:40 AM

Which dialects will be supported? We're using Postgres, and IntelliJ complains about a lot of things... I'm also wondering how to turn it off?

Hello Erik,

Which dialects will be supported? We're using Postgres, and IntelliJ
complains about a lot of things... I'm also wondering how to turn it
off?

Postgres is not in the plans for 8.0. To turn the highlighting off, I'm afraid
the only way is to map the .sql extension to the plain text file type.

--
Dmitry Jemerov
Development Lead
JetBrains, Inc.
http://www.jetbrains.com/
"Develop with Pleasure!"

Ah, well, that's a shame, but what I actually wanted to do, was like the previous poster: I would like to have some syntax highlighting, but not the squirrly error lines. I'd rather not see those anywhere in my project, but it XML, Java or SQL.... So if that could be turned off, that would also be fine!

Is there a JIRA issue raised about this that I can follow?
(the lack of being able to switch off the error highlighting, not the SQL support itself).

If not, I'll raise one (seriously, you should never put in error highlighting that can't be configured, it is so unbeliavably annoying).

Hello Shorn,

Is there a JIRA issue raised about this that I can follow? (the lack
of being able to switch off the error highlighting, not the SQL
support itself).

If not, I'll raise one (seriously, you should never put in error
highlighting that can't be configured, it is so unbeliavably
annoying).

Please file a new JIRA issue.

--
Dmitry Jemerov
Development Lead
JetBrains, Inc.
http://www.jetbrains.com/
"Develop with Pleasure!"

Raised: http://www.jetbrains.net/jira/browse/IDEA-20038

Postgres is not in the plans for 8.0.

Then the documentation could be rephrased as it says under Supported Languages:

"SQL and its various dialects (SQL/92, MySQL, Oracle and PostgreSQL)"

Hello dca,

>>

>> Postgres is not in the plans for 8.0.

Then the documentation could be rephrased as it says under Supported
Languages:

"SQL and its various dialects (SQL/92, MySQL, Oracle and PostgreSQL)"

Right, we'll remove it. Thanks for noticing.

--
Dmitry Jemerov
Development Lead
JetBrains, Inc.
http://www.jetbrains.com/
"Develop with Pleasure!"

I want to mention that the MySQL support is very nice.
Luckily some of our projects run on MySQL (5.0 at the moment), so I get very good completion suggestions, etc. :)

Obviously implementing a database-specific lexer/parser/other infrastructure is a large undertaking..
Perhaps it would make sense for Jetbrains to poll customers for their most-used DBMS to get some feedback for post-Diana?

In addition, in what format does IDEA store the list of supported functions for a given dialect?
If this is something relatively simple? In other words, something we could provide patches for?