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:
Now DataGrip detects if an old driver is in use and offers you to update it:
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
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.
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.
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.
All IntelliJ-based products bundle FiraCode font so you can use it to have ligatures in your code.
- SQL Server 2016 grammar support
- External tables parsing in Oracle
- Better operators parsing in PostgreSQL
- SELF resolving in Oracle
Your DataGrip Team
The Drive to Develop