|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.
or email your comment to: firstname.lastname@example.org
|Last Updated ( Wednesday, 02 December 2020 )|