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


Colorization Of Early Films Good or Bad?
17/01/2021

Here's another example of the use of AI for colorizing and breathing new life into photos, or rather in this case early film footage. This one goes an extra step - adding sound effects. While the resu [ ... ]



What Apps Are Removed From The App Store?
20/01/2021

A new study throws a lot of light on a mysterious subject - what apps are removed from the iOS App Store? The first big surprise is how many apps were removed. Guess how many were removed in the recen [ ... ]


More News

square

 



 

Comments




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

Last Updated ( Wednesday, 02 December 2020 )