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.


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.


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.


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.


Othello Solved - It's A Draw!

The board game Othello, also known as Reversi as it played by reversing the colors of black and white disks, has been solved using alpha-beta pruning. Given "perfect play", that is a situation in [ ... ]

Amazon Working On Olympus LLM

According to Reuters, Amazon is working on a large language model (LLM), codenamed "Olympus". With, reportedly, 2 trillion parameters, it is twice the size of OpenAI's GPT-4 model.

More News




or email your comment to:

Last Updated ( Wednesday, 02 December 2020 )