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


Flox Releases Flox Hub
13/03/2024

Flox has announced that its Command Line Interface (CLI) and FloxHub are now generally available. The CLI is open source and FloxHub is free for anyone to use.



Running PostgreSQL Inside Your Browser With PGLite
18/03/2024

Thanks to WebAssembly we can now enjoy PostgreSQL inside the browser so that we can build reactive, realtime, local-first apps directly on Postgres. PGLite is about to make this even easier.


More News

raspberry pi books

 

Comments




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

Last Updated ( Wednesday, 02 December 2020 )