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
Comments below can no longer be edited.
Andriy Bazanov says:
January 12, 2012I’m trying to create a DB Data Source for SQL Server 2008. Can someone tell me what I need to do (where to download JDBC driver etc) as there is no SQL Server option in a list of available JDBC Driver files (PhpStorm 3.0.1 EAP; 111.150). Thanks.
Taras Tielkes says:
January 12, 2012You could try the open source jTDS driver:
http://jtds.sourceforge.net/
Andriy Bazanov says:
January 13, 2012Thanks Taras — this one worked. Originally I have tried driver from Microsoft themselves .. but it failed to connect (whole IDE freezes/stop responding and I have to kill it).
I may use it one day (for some quick code completion or something). But right now I see no reason to stop using SSMS — it much better in my opinion (plus I have got used to use it).
Artjom Kurapov says:
January 17, 2012Is it me, or does table navigation doesn’t request data when I try to sort columns? It just orders those that are already loaded in IDE..
That is not very useful – it forces to use filter (which is a separate dialog), or write own SQL