Finally, the day has come for us to start working on MongoDB support. After more than 400 votes we have decided now is a good time to begin including the basic functionality.
You can observe collections and fields in the database explorer. We fetch the first 10
documents from each collection to get information about the fields. This can be customized
via the JDBC parameter fetch_documents_for_metainfo
which is available in the
Advanced tab of the data source properties dialog.
There is currently no coding assistance, but this doesn’t stop you from running queries and getting the results. To run a statement, put the caret on it and run it via Ctrl+Enter or by using the Run button on the toolbar.
If you’re using the database support in any other JetBrains IDE, your queries will be highlighted with the help of the JavaScript highlighter. Highlighting and completion in DataGrip will come later.
Open any collection or observe the query result. You have the option to sort by columns or filter the values. Paging works as well.
It’s also available to explore data as a tree. To turn it on, click the Gear icon | View as… | Tree.
The first version of the long-awaited PL/SQL debugger: you can debug procedures, functions, triggers, and anonymous blocks and observe variables there.
Don’t forget, that the object you wish to debug needs to be compiled for this operation. To do this go to the context menu of the object: Database tools | Recompile. Don't forget to use With “debug” option.
Note: if the procedure is already compiled for debug, there is a small green bug on its icon.
Ok, now you are ready to understand what is happening under the hood! Use the Debug button on the toolbar.
To learn more about how the debugger works please visit our help page. If you have any feedback for us about the debugger please post it in the corresponding issue.
When you submit source code and DataGrip determines that it was changed while you were editing it, a notification will pop up. This notification will suggest you resolve the conflict by way of a three-way-merge.
Also, if you want to make sure that you won’t accidentally delete someone else’s work by submitting an outdated object, the Warn if editing outdated DDL option should be turned on.
We've turned on code prettifier in PostgreSQL by default. Before, the code given by the database contained many parentheses, which were frequently unneeded:
With the new option turned on, it looks like this:
Please note, PostgreSQL states in its documentation:
The pretty-printed format is more readable, but the default format is more likely to be interpreted the same way by future versions of PostgreSQL; avoid using pretty-printed output for dump purposes.
Now you can clearly see when your query is running: there is a spinning icon on the gutter and the inline live timer as well.
We’ve added a new type of visualization for the explain plan results. To see it, click the corresponding button on the left. It is just under the diagram button.
DataGrip will warn you, if:
It makes no sense to use the COALESCE
operator. And then provides you with
a quick-fix!
You’re inserting a NULL
value into not nullable column.
You haven’t listed all the columns that are needed in the INSERT
statement.
Use the ‘equals’ operator to find out if the value is null. You probably want IS
NULL
to be used here.
An ORDER BY
clause has found its way into the subquery in SQL Server.
You use TOP
and OFFSET
simultaneously in SQL Server.
This intention will assist you in converting a complicated comparison to a
BETWEEN
operator and vice versa.
This intention helps you convert JOIN ON
to JOIN USING
, and vice
versa.
A new action will help you to sort lines alphabetically in the selected piece of code. This can be useful when working with CSV files or for finding duplicate values!
It’s now possible to search only in a selected area. Simply select the code piece you need in the editor and press Ctrl+F. If you need to perform the search within the whole file, press the shortcut again.
Now, if you use filtering in the database explorer, DataGrip will not resolve any objects which are not displayed in the database tree view.
We have a bunch of new stuff in the Generate menu! Invoke it with Alt+Ins. Remember, speed search works here.
Now if your result-set contains multiple columns with the same name, you won’t have any problems with ambiguous names if you create a table from it: the column names will be qualified.
The Modify Table action is now available from the data editor context. Want to add a new column while editing table data? Go ahead, just press Ctrl+F6 and it is nearly done!