database

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): …

As you work with databases in your project, there are quite a lot of routine tasks that have to be performed on a regular basis. However, now there is a great way to do it right from your IDE. You can view database structure and easily modify it by refactoring affected code; manage data stored in th…

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 b…

In PhpStorm 2.1 “Find Usages” (Alt+F7) results for tables and columns include database schema usages, i.e. references in indices, primary and foreign keys, see screenshot below: Develop with pleasure! Note: since WebStorm doesn't support working with Databases there is no such feature in WebStor…

We at JetBrains know how important it is to track what has been changed in your project from one version or revision to another. This is why PhpStorm 2.1 brings you new Diff Tools for comparing DB objects (Data Sources, Schemes, Tables) and folders. In later updates we’re planning on including even…

The latest PhpStorm EAP (build 94.430) contains a good number changes in Database-related functionality. Namely: A dedicated Database Console tool-window Сonsole-like UI keeps input and output in one place and retains the highlighting for execution history Configurable keyboard shortcuts for…