Tag Archives: database

Deploying PHP Applications with PhpStorm

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 … Continue reading

Posted in Screencast | Tagged , , , , , , | 1 Comment

Database Tools and SQL Editor Changes in PhpStorm 7

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 … Continue reading

Posted in Cool Feature | Tagged , , , , , | 20 Comments

Connecting to Google Cloud SQL from PhpStorm

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 … Continue reading

Posted in Cool Feature | Tagged , , , , , , , | 1 Comment

Introducing PhpStorm Video Tutorials

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 … Continue reading

Posted in Cool Feature, Screencast | Tagged , , , , , , , | 1 Comment

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, … Continue reading

Posted in Cool Feature | Tagged , , , , | 1 Comment

SQL support and Database tools

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 … Continue reading

Posted in Cool Feature, PhpStorm, Tutorial | Tagged , , , | 17 Comments

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. … Continue reading

Posted in Cool Feature, PhpStorm | Tagged , | 4 Comments

Find Table/Column Usages Searches Database Schema

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 … Continue reading

Posted in Cool Feature, PhpStorm | Tagged , | 1 Comment

PhpStorm: What makes a difference

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, … Continue reading

Posted in Cool Feature, PhpStorm | Tagged , | 3 Comments

Integrated Database Console

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 … Continue reading

Posted in Cool Feature, PhpStorm | Tagged , | 8 Comments