PhpStorm 3.0: New and Noteworthy in Database Realm

This is a cross-post from IntelliJ IDEA blog. Original post by Gregory Shrago.

There are many little things in database and SQL area that got attention in PhpStorm 3.0 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.

Develop with pleasure!
-JetBrains Web IDE Team