JetBrains opens the round of 89. 3 versions of the development environments with the database IDE DataGrip. 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 in focus In conjunction with MongoDB, the IDE enables direct SQL queries. The database usually relies on native drivers for programming languages ​​such as C ++, Java, Node.js, Go or Python and offers its own query language, MongoDB Query Language (MQL). In the current release, DataGrip comes with a driver written in JavaScript, which takes care of the translation of the SQL commands into MongoDB queries.

DataGrip 2020. 3 bring a MongoDB driver for direct SQL queries with them.

(Image: JetBrains)

At the start the driver only allows SELECT – Queries, and as clauses are JOIN , WHERE , GROUP BY , HAVING , ORDER BY , LIMIT and OFFSET allowed. The JavaScript code created for the query can be accessed via the context menu with Copy JS script to clipboard or Show JS Script copy or display and edit.

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 there is not yet a connection to the Couchbase Analytics Service.

Cleverly extracted Two new methods for 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 adds the selected elements in a row, which, among other things, allows the transfer of values ​​from a column for IN – Clauses can be useful.

Let via data extractors now take over several lines for an INSERT statement.

(Image: JetBrains)

The also new method SQL-Insert-Multirow allows copying several lines into one INSERT statement. A small innovation concerns the CSV export, which can now omit any quotation marks. For Quote values ​​ exists in the CSV -Dialog next to When needed and Always recently Never .

View into the cell In addition, the current release extends the one in DataGrip 2020. 2 introduced Cell Values ​​Editor 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 has recently started displaying images and can be moved to the lower edge to save space.

The Cell Values ​​Editor is now showing images.

(Image: JetBrains)

For editing, an extended function for the selection has been added, which no longer just enlarges, but recently can also be reduced. This is done using the keyboard shortcut Ctrl | in Windows Shift | W and under macOS Opt | Below .

Further innovations 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 in the first year 89 euros and from the third year 53 Euro per user. Unlike IntelliJ IDEA, there is no free version for DataGrip.

(rme)