Hi! Discussion of DataGrip began already in comments to the announcement of new IntelliJ IDEA, let’s continue here. I will tell what new is in DataGrip 2017.1.
There will be a lot of text and pictures. In brief, here what we added:
- New management of schemes
- Binding of files to data sources
- The interface for creation of bases and schemes
- Settings of flowers for the editor and results of inquiry
Import and export of data
- Export of tables of one base to another
- Comparison of columns of the file and table
Console of inquiries
- Preservation of a way of search by default in PostgreSQL
- A template for generation of triggers
- Settings for shutdown of automatic concatenation of multilower case literals and for automatic qualification of objects
- Time of performance of inquiry and number of a column and line of the allocated field in the status panel
- Search of a name of tables and other objects in comments and lines
- Windows authentication in SQL Server for the jTDS-driver
- Warning of change of the source code of representation, procedure, etc.
Tree of databases
Management of schemes
We once again processed the interface for the choice of schemes in a tree of databases. We hope, it for a long time now:)
The tree of the choice opens on double click on Schemas …. Choose all schemes, current or only at once what you want to see.
The Schemas tab we returned to properties of data source — there now the same tree of the choice. It is possible to specify the displayed schemes in a text template which language is described in information window (Ctrl+Q or F1 for OSX).
Compliances of files and data sources
Earlier, especially in other IDE with the built-in support of bases, there was a confusion with to what data source the file is tied. If inquiries, say, from Java class used unqualified objects, IntelliJ IDEA itself tried to guess in what base they are carried out. Wednesday could be helped with the Resolve Unqualified References tab. But if in data source there were objects with identical names in different schemes, this problem could not be solved.
It became simpler: any file or the folder can obviously be tied to one or several data sources or even to separate schemes. It becomes in Settings → Database → SQL resolution scopes. As a result, unqualified subjects of the database from your inquiries will be perceived as objects from the specified source. That is autoaddition and navigation will work.
UI for creation of bases and schemes
Specify whether you want to see the created schemes and bases in a tree immediately. This option also works for creation of schemes and bases directly from the console.
NB! DataGrip still does not support several bases in PostgreSQL for one data source. Therefore the created new bases in a tree will not appear — for work with them create separate data source. But we began work on it.
Color settings in a context menu of data source were earlier (knew about them?:), but now color can be applied also to a console background, and to the table of results of inquiry. We hope, it will help not to start test scripts on live base.
Import and export of data
Export of tables and results
Now it is possible to drag the table of one base in another. And, even if it is bases from different DBMS. The structure of the table and data will be copied.
It is possible to create the new table in other base and from results of inquiry: added the Export to database button.
Improvements in import dialogue
There were many offers on how to make import more flexible.
Specify to what table you import data, and edit a script of its creation. Comparison of columns will help to understand what data where will get. For names of columns autoaddition works.
Console of inquiries
Way of search to PostgreSQL
Most important for users of PostgreSQL: now we do not forget about a way of search by default. As before, it is adjusted in the top right corner.
Added a template for generation of triggers on Ctrl+N (Cmd+O for OSX).
Supported NEW/OLD and INSERTED/UPDATED for source codes of triggers.
Writing of a code
The acquaintance on other IDE the option Settings → Editor → Appearance → works with Show parameter name hints also in DataGrip: shows names of columns for offers of INSERT.
New settings appeared in Settings → Editor → General → Smart Keys.
Insert string concatenation on Enter is responsible for whether lines at transfer will be automatically concatenated. Earlier it worked by default and looked so:
In some bases multilower case literals are used, and such behavior was inconvenient. If to remove a tick, transfer of lines will not insert anything:
The option Qualify object in completion was asked too. It is convenient to someone that objects were qualified always, it irritates someone even at collisions — the same scripts will be started on different bases, and people do not want anything to change in them. Let’s tell, we have two schemes — max and public, with such tables:
IDE at the Qualify on collisions parameter will behave here is how:
The called parameters are supplemented on the second pressing of Ctrl+Space. In general, in all our IDE it results in interesting results, try.
One more control from a platform works for DataGrip. Settings → Editor → Appearance → Show method separator will draw lines between inquiries.
In MySQL there are bugs in grammar when using UNION. We added amusing inspectorate which will warn about it.
Navigation to settings of flowers and fonts
And it is required to users of any IDE on the IntelliJ platform — do not look for where in a jungle of settings to change color or a font. The Jump to colors and fonts team in the ubiquitous menu on Ctrl+Shift+A (Cmd+Shift+A for OSX) will send you to a color setting of that context in which there is a cursor.
If it is several contexts, choose necessary. Here it is offered to customize color and the display for the started inquiry (a violet frame) and color of a lower case literal (green). Let’s assume, we are concerned by a lower case literal.
It is ready! It is possible to change color.
Inquiries we added time of performance of inquiry and number of a column and line of the allocated record to the panel of the status of results.
In the Modify table window of a detail of a column open on double click, but not on unary.
The editor of source codes catches that an object changed from DataGrip, and warns about it.
In information window for system tables in PostgreSQL the reference to documentation is added.
In search of uses of objects it is possible to exclude text occurrences — comments, dynamic SQL.
And in the new version:
- A preview for big files in the mode “only for reading”.
- Windows authentication in SQL Server for the jTDS-driver.
- Support of inquiry of CREATE/ALTER in SQL Server 2016.
- TNS names are correctly read out from the tnsnames.ora file in Oracle.
- Kommit starts synchronization in PostgreSQL.
- More objects in SQLite Introspektirutsya.
- Preventions appear in the Output tab at once.
- Zero-latency typing (set without delay) is included by default.
- Color settings for regular expressions.
Possibly, you about all this know, but nevertheless:
- To download the free trial version here.