PhpStorm

With the recent releases of PhpStorm 9 & 10, the database tool inside the IDE got some interesting improvements. In this post we'll take a look at exactly what's changed and how working with your database without leaving PhpStorm is more enjoyable than ever before. (more…)…

When developing PHP applications, chances are at one point we will be deploying them. During development we may want to deploy our application to a testing/staging server or a Vagrant box. And once release day is there we want to make sure our carefully crafted code makes it to production. We're hap…

Always switching between the IDE and a separate database client? There’s no need to juggle apps! Using the built-in Database Tools with PhpStorm, we can setup a database connection and start creating and editing tables, views, work with data, generate a database diagram and so on. Not only that: …

When creating Google App Engine applications in PHP using PhpStorm, chances are that we are also using Google Cloud SQL. From our PHP code, we can easily do this by creating a new connection to our Google Cloud SQL instance using PDO: Now what if we want to connect to this database using the …

A lot of PhpStorm users have been asking us to create a series of video tutorials. Today, we're happy to announce the availability of about two hours of video tutorials around PhpStorm which Maarten has been working on for the past few weeks. JetBrains.TV and YouTube playlist are also available. …

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

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