JetBrains IntelliJ IDEA Blog

There are many little things in database and SQL area that got attention in yesterday’s IntelliJ IDEA 11 release but now I just want to highlight the major ones.

Data Sources view got a new look and now includes stored procedures both from DDL scripts and real databases. The existing SQL dialects support has been redesigned with two new dialects introduced: H2 and MS Transact-SQL. So the list of supported SQL languages now looks like this:

MySQL 5.6 PostgreSQL 9.0.5 Oracle 11.2 SQLite 3.7 SQL Server 10.50 Derby 10.8 HSQLDB 2.2 H2 1.3 SQL-92    Featuring: Exact syntax as in docs Context-aware completion PL-extensions support

Database view:

• Includes stored procedures. Search for usages, navigate to, drag and drop to editor, etc.
• Working with large databases is now less painful. Tables and procedures are available the moment their names are loaded. Columns, procedure parameters and other information are loaded in background afterwards.
• If something is changed there’s no need to wait for the whole synchronization. Refresh only selected schemas, tables or procedures.

Database Console:

• Console now remembers its state so you won’t lose statements you have never run.
• If you do not want to switch editors back and forth you can run statements directly from an SQL file or any other place where SQL injection takes place: invoke “Run Query in Console” intention for the first time then use console “Execute” action shortcut as if you are in console.
• Transact-SQL batch execution mode (the toggle is hidden in the console properties dialog)
• Console editor now can be undocked and split as any other editor.

Enjoy.

Maia release is closing in, and yet we have not run out of useful features to announce. Next EAP brings you a long-awaited support of PostgreSQL dialect. Just as with all others, you can set it at project, folder, or individual file levels either via Project Settings section of Settings dialog, or by invoking a quick-fix on any error marker inside of an .sql file with Alt+Enter shortcut.

In Maia the Show Parameter Info action (Ctrl+P) is available in SQL function calls and value expressions.

Maia brings you the support of Apache Derby SQL dialect. Just as with all others, you can set it at project, folder and individual file levels either via Project Settings section of Settings dialog:
Or by invoking a quick-fix on any error marker inside of an .sql file with Alt+Enter shortcut: