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

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 the table simply editing or adding values; write SQL queries with smart code completion and syntax highlighting; and run SQL queries just from the code or the built-in SQL editor. If you have more complicated tasks to perform, there are UML diagrams showing relations between tables and tools to com

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 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 Derb

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 WebStorm.

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 remote to local files comparison as well. Diff Tools are available via Ctrl+D/Cmd-D hotkey, or from context menu, wherever you may need them. Say, to compare two Data Sources (or Tables, or Schemes, come to that), all you need to do is select them in Data Sources tool window, and then invoke the

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 Console actions (in IDE Settings) Per-result Page Up, Page Down and Refresh actions Complete support for In-Memory Databases (try running some DDL in Console then click Refresh Tables and all the tables will be loaded in the Data Sources tree) Quick Table Contents Lookup using the standar