Where do we host our applications? How do we deploy them? Can we have different environments like development, staging and production? A possible answer to all those questions is Pantheon. It provides hosting, database, caching, version control, different environments, workflows for moving an application through the development pipeline and more. Let's go over the basics of working on a Drupal or WordPress site hosted on Pantheon, using PhpStorm. (more…)

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 Database Tools available in PhpStorm? Note that Google Cloud SQL is not the only database platform we can make use of from within PhpStorm. MySQL, Microsoft SQL Server, Microsoft’s Windows Azure SQL Database (another cloud!), Oracle, PostgreSQL and many more providers are available. (more&hel

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): Setting up a database connection Creating a table Inserting and updating data Using the database console Generating a database diagram Database refactoring (more…)