DataGrip Adds SQL For MongoDB
Written by Kay Ewbank   
Tuesday, 01 December 2020

DataGrip has been updated with support for SQL for MongoDB, Azure AD authentication and new extractors. The new release also adds Couchbase support, and better display of results with formatted values and images in the value editor and new data extractors. This is one of DataGrip's regular updates, the third this year.

DataGrip is a combination of an intelligent SQL editor and collection of database tools packed together and running on top of the IntelliJ platform.

datagriplogo

The main improvement to the new version is the ability to use SQL to query MongoDB databases; the DataGrip developers have created their own JS-SQL translator that makes this possible.. For the current release, the support only extends as far as Select queries, with the following qualifiers and clauses:Join, Where, Group By, Having, Order By, Limit and Offset. You can use Distinct and All, and the aggregate functions are supported. You can't use Count. Object builders are supported, and there's a JS query preview and the ability to copy the JS query to the clipboard.

mongdbsqlgeneral

You can use all the available MongoDB functions except map, reduce, filter, and let. Where the functions such as dateToString expect a named argument, you have to use a PostgreSQL-like syntax for the named parameters, using ‘=>’ or ‘:=’.

Query improvements include warnings if you switch schemas when running a query, and history targets in run configurations, along with tab names and hints for indexes when you are using 'Explain plan'.

The new Couchbase support means you can use the Couchbase Query service, but not the Couchbase Analytics service. The Azure AD authentication adds the ability to use Azure AD to log in to your database.

datagriplogo

More Information

DataGrip site

Related Articles

DataGrip Adds Group Data Sources

DataGrip Improves Schema  Management

0xdbe Becomes DataGrip

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner


Automatic Off-By-One Detection
31/03/2021

We all know about off-by-one errors and also know that, however aware of the problem you might be, they manage to bite us eventually. What about applying the power of deep learning? Perhaps this magic [ ... ]



Oracle V Google Android Case Settled
05/04/2021

At long last the 10 year case between Oracle and Google over the copyright or otherwise of the APIs used in Android is settled, the SCOTUS verdict is in.


More News

square

 



 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Wednesday, 02 December 2020 )