We open EAP for DataGrip 2016.3

Maksim Sobolevskiy

Hello! As you know, there is a good tradition to let you try new product features before the official release, so today meet DataGrip 2106.3 Early Access Program.

This version features integration with dump tools, several new inspections, the possibility to edit several fields at the same time, new completions, and many other enhancements. Let’s take a closer look at them:

Drivers

Now DataGrip detects if an old driver is in use and offers you to update it:

Table Editor

Now you can edit several fields at once — just select them and begin to type. Of course, it works only if the columns you are editing are not unique and have the same type.

The familiar expand selection action by Ctrl+W (Alt+Up for OSX) now works in the data grid as well: first, a field is selected, then the column of the active field, then the row of the active field and finally, the whole grid.

External dump tools integration

We integrated DataGrip with mysqldump and pg_dump. To dump the objects, use the Dump with… option from the context menu.

This is what the dialogue window for MySQL looks like:

And here is the one for PostgreSQL. Note that in both cases you can use completion for the console parameters.

Code completion

Now if you use JOIN USING, DataGrip offers you only the field names common for both tables.

The INSERT statement completion offers you not only the list of all fields but also the list of fields which have no default value.

Inspections

The IDE will warn you about the unused variable or parameter in the function.

Another inspection will let you know if there is a different number of columns in queries used in set operators (UNION, INTERSECT and EXCEPT).

Introspect missing schemas and databases

The new intention action offers you to introspect the schema or databases right from the editor if DataGrip has no metadata on them yet.

Find usages in PostgreSQL

Find Usages now handles positional parameters references in PostgreSQL: $1 will be treated as the first parameter’s usage and so on.

FiraCode font

All IntelliJ-based products bundle FiraCode font so you can use it to have ligatures in your code.

Other enhancements

• SQL Server 2016 grammar support
• External tables parsing in Oracle
• Better operators parsing in PostgreSQL
• SELF resolving in Oracle

That’s it! Your feedback is welcome in our twitter, forum and the issue tracker. Let us know what you think about 2016.3!

Your DataGrip Team
_
JetBrains
The Drive to Develop