PhpStorm 2020.3 will come with several PHP 8 attributes available out-of-the-box: Download PhpStorm 2020.3 EAP (more). Remove/Backup – settings & cli for macOS (OS X) – DataGrip, AppCode, CLion, Gogland, IntelliJ, PhpStorm, PyCharm, Rider, RubyMine, WebStorm - README.md.
We’ve released our last EAP build before the official release of DataGrip 2021.1. Let’s see what’s new.
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. In this video I show you how to change you JetBrains ui theme.
Context live templates
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.
And of course, many other tools use this mechanism for reducing repetitive work, so many newcomers are already used to it.
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
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:
- 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.
Thank you,
Your DataGrip team
Skip to end of metadataGo to start of metadataConnection to Heroku
Connection to Snowflake
Connection to AWS Athena
Connection to MySQL (Russian)
Datagrip Vs Phpstorm
Connection to Netezza
Connection to MySQL on Amazon RDS
Connection to NetSuite
Connection to MS SQL Server Express
Connection to Google Big Query
Connecting to Microsoft Azure on Linux (Korean)
DATAGRIP AND AZURE SQL SERVER ACTIVE DIRECTORY – HOWTO
DB classes generation (Russian)
Export SQL results to Markdown
How to install DataGrip in Ubuntu
Phpstorm Include Datagrip
Using Docker PostgreSQL and DataGrip in Ubuntu
Phpstorm Vs Datagrip
DataGrip: Installation Instructions (Windows)
Connection to Redshift (obsolete)