Phpstorm Datagrip



We’ve released our last EAP build before the official release of DataGrip 2021.1. Let’s see what’s new.

Datagrip vs phpstorm

Context live templates

Phpstorm Datagrip

This is our solution for anyone wanting to generate simple statements straight from the database explorer. While general live templates cover many cases where you need to write a simple query quickly, we also understand that sometimes, when you are in the context of the database explorer and you are already focusing on the object you need, there is a better way to get a simple query using that object.

PhpStorm 2020.3 will come with several PHP 8 attributes available out-of-the-box: Download PhpStorm 2020.3 EAP (more). The datatools in phpstorm have the same feature set as datagrip (according to jetbrains support). Copy over the datasource.xml and datasource.local.xml when phpstrom isn't running. The 'kind of' part is that you will have to reenter any saved passwords. – mushcraft Jul 4 '16 at 8:34.

Check out popular companies that use DataGrip and some tools that integrate with DataGrip. PhpStorm is a PHP IDE which keeps up with latest PHP & web languages trends, integrates a variety of modern tools, and brings even more extensibility with support for major PHP frameworks.

And of course, many other tools use this mechanism for reducing repetitive work, so many newcomers are already used to it.

Datagrip Vs Phpstorm

We’ll start with a short video that shows how it works:

Every code snippet in this list is actually a live template, but they are all special ones that can be generated in the context of the chosen object. For example, let’s look at the template Select first N rows from a table.

Open the live templates setting and locate the template you need:

As you can see, it looks like a general template (and can be used as such). Since this particular syntax cannot be used in all databases, the corresponding dialects are set for the template. The major difference that makes this template applicable in the database explorer is the special expression dbObjectName which is used for the $table$ variable:

Obviously, you can add your own templates or edit existing ones, which makes this feature customizable.

Adding grants to user

Phpstorm Vs Datagrip

The Modify user window, which is called by Cmd/Ctrl+F6, now has a UI for adding grants to objects:

This is available for PostgreSQL, Redshift, Greenplum, MySQL, MariaDB, DB2, SQL Server, and Sybase.

Data source templates for unsupported databases

From 2021.1 it’s easier to add the data source for databases we don’t support. We now provide JDBC drivers for AWS Athena, Informix, MemSQL, Presto, SAP HANA, and Google Cloud Spanner. Look for these databases in the Other section of the database list.

We’ve made some additional improvements:

Phpstorm Include Datagrip

  • You no longer need to download the driver yourself and manually create a data source based on it.
  • New versions of the driver will be provided by DataGrip.
  • Some new databases have their own dedicated icons.

Please note that support for these databases is limited. It is mainly dependent on the abilities of the JDBC driver and the SQL:2016 dialect support of DataGrip’s SQL editor.

Change field type in MongoDB

To make editing more flexible, we’ve introduced the ability to change the type of a field using the UI. This can be done both in the context menu of the field and in the value editor:

You are welcome to give us feedback using our Twitter or forum. We also have a simple way for you to quickly report issues straight from DataGrip, click Help -> Report problem… to create a new issue in our issue tracker.

Phpstorm Datagrip

Thank you,

Your DataGrip team