DataGrip 2019.3: MongoDB support, Debugger for Oracle, Inline query progress and more!

Posted on by Maksim Sobolevskiy

We’re pleased to introduce DataGrip 2019.3. This is the third major update of 2019, and it’s packed with various enhancements. Let’s take a look at what it has to offer!

DGR

MongoDB support

The day has finally come for us to start adding MongoDB support. Since the request received more than 400 votes, we decided that the time was ripe to begin including basic functionality for it.

UD-Mongo

Here’s a quick overview of the MongoDB features that work in this version:

Introspection: You can observe collections and fields in the database explorer.

Data viewer: Open any collection or observe the query result and you have the option to sort it by column or filter the values. Paging works, as well.

Tree view: It’s also possible to explore a tree view of the data. To turn it on, click the Gear icon | View as… | Tree.

Query console: To run a statement, put the caret on it and run the console by pressing Ctrl/Cmd+Enter, or use the Play button on the toolbar.

Oracle PL/SQL debugger

In this first version of the long-awaited PL/SQL debugger, you can debug procedures, functions, triggers, and anonymous blocks, and observe variables.

UD-Debug

You can visit our help page to learn more about how the debugger works. If you have any feedback for us about the debugger, please don’t hesitate to post it in the corresponding issue.

Working with the source code

  • Diff viewer for routines
  • 3-way merge
  • Code prettifier in PostgreSQL
  • Intentions now work inside the source codes

UD-Sources

Running queries

  • Inline query progress
  • Flame chart for explain plan

UD-InlineProgress

Coding assistance

  • New inspections
  • New intention actions
  • An option to sort lines alphabetically
  • An option to search only in a selected area
  • Resolve respects filtering
  • New items in the Generate menu

UD-EqualsNull

Data editor

  • There are no longer problems with ambiguous names in the result-set.
  • The Modify Table action is now available from the data editor context.

UD-DataEditor

To take in all the new features with full descriptions, please visit the What’s New page.
You already know all of this, but just as a quick reminder:

Thank you for your attention!
Your DataGrip Team

Comments below can no longer be edited.

10 Responses to DataGrip 2019.3: MongoDB support, Debugger for Oracle, Inline query progress and more!

  1. Thomas S. says:

    December 3, 2019

    Any chance we will get a similar debugger for T-SQL / MS SQL Server in the future?

    • Maksim Sobolevskiy says:

      December 10, 2019

      There is a chance, but no ETA still. I think PostgreSQL will appear earlier.

  2. Felipe de Jesus Hernandez Medina says:

    December 3, 2019

    QUE PASA

  3. Deepak Pathak says:

    December 4, 2019

    I just upgraded and many thanks for adding support for MongoDB.

    I have a suggestion for future release, to please add support for Redis. I know it’s a state management store, rather than an actual and complete database. But most companies these days use Redis, and it would be an awesome feature, if DataGrip could provide support working with Redis.

    Thanks and keep doing the amazing work!

  4. Holger says:

    December 16, 2019

    Loving the inline Query Progress and the PL/SQL Debugger. Thanks!

  5. Pedro says:

    February 13, 2020

    I would like know if the DataGrip support mongodb query like SQL 92?

    • Maksim Sobolevskiy says:

      February 14, 2020

      For now it doesn’t, Pedro

  6. dr1ss says:

    March 2, 2020

    Happy for MongoDB, can’t wait to see more features like index management etc..
    Good job

  7. Mehran says:

    March 31, 2020

    This is awesome! Many thanks for MongoDB support.