JetBrains opens the series of 2020.3 versions of development environments with the DataGrip database IDE. Above all, the SQL queries to the document-oriented database MongoDB are worth mentioning. A connection has recently also been made for the NoSQL database Couchbase, but via the N1QL query language from Couchbase.
NoSQL im Fokus
The driver only allows to start
SELECT-Queries, and as clauses are
In the NoSQL environment, the newly added connection to Couchbase is also noteworthy. For the interaction, DataGrip has its own JDBC driver that executes queries using the Couchbase-specific query language N1QL. The connection initially works exclusively via the Couchbase Query Service, while a connection to the Couchbase Analytics Service is not yet available.
Two new methods of extracting data have been added for import and export. Data extractors are essentially rules for copying data into the editor. The new menu entry One-row inserts the selected elements in a row, which, among other things, enables values to be taken from a column for
IN-Clauses can be useful.
The also new method SQL-Insert-Multirow allows multiple lines to be copied into one
INSERTInstruction. A small innovation concerns the CSV export, which can now omit any quotation marks. For Quote values exists next to in the CSV dialog When needed and Always recently Never.
Look into the cell
The current release also extends the Cell Values Editor introduced in DataGrip 2020.2 for editing individual cell contents. Among other things, single-line XML and JSON content can be displayed in a structured and formatted multi-line view. In addition, the Cell Value Editor now shows images and can be moved to the lower edge to save space.
For editing, an extended function for the selection has been added, which can no longer only be enlarged, but recently also reduced. The keyboard shortcut is used for this in Windows Strg | Shift | W and on macOS Opt | Unten.
Further new features in DataGrip 2020.3 can be found on the JetBrains blog. Details on the connection to MongoDB can be found in a separate blog post from the end of October. JetBrains offers all IDEs in a subscription model, with the price dropping within the first three years. DataGrip costs 89 euros in the first year and 53 euros per user from the third year. Unlike IntelliJ IDEA, there is no free version for DataGrip.