Database IDE: DataGrip 2020.3 sends SQL queries to MongoDB


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.

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 brings a driver written in JavaScript that takes care of the translation of the SQL commands into MongoDB queries.

The driver only allows to start 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 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 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.

Using data extractors, multiple lines can now be used for an INSERT statement.

(Image: JetBrains)

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.

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.

The Cell Values ​​Editor now shows images.

(Image: JetBrains)

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.


To home page

Source link


Please enter your comment!
Please enter your name here