PhpStorm 3.0: New and Noteworthy in Database Realm
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
- Exact syntax as in docs
- Context-aware completion
- PL-extensions support
- 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.
- 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
Working with Windows Azure SQL Database in PhpStorm
PhpStorm provides us the possibility to connect to Windows Azure SQL Database right from within the IDE. In this post, we’ll explore several options that are available for working with Windows Azure SQL Database (or database systems like SQL Server, MySQL, PostgreSQL or Oracle, for that matter): …
Change signature refactoring in PhpStorm
A very powerful refactoring is the Change signature refactoring in PhpStorm. It enables us to modify a function signature in many ways: we can change the function name, change its visibility, add, remove and reorder parameters as well as rename parameters. (more…)…
Folding for imports in PhpStorm 6.0
In PhpStorm 6, we've introduced code folding for imports. Any list of imports will now be folded into a single line. This greatly reduced clutter in your editor when having a lot of imports! (more…)…
Drag & Drop Project Files to Remote Hosts in PhpStorm
The Remote Host pane allows us to work directly on a remote server through FTP, FTPS, SFTP or a local/network folder. A lot of people asked us to add drag & drop to the Remote Host pane in PhpStorm. Good news: PhpStorm 6 comes with drag & drop as well as copy & paste support from the pro…