DataGrip 2018.2 EAP 3

Posted on by Maksim Sobolevskiy

Hello! We’ve prepared a new build for our early adopters. Here’s a list of interesting things you will find inside.

Running stored procedures

A long-awaited feature! Now it’s implemented for Oracle and PostgreSQL. SQL Servers procedures are to come.

Choose Execute from the context menu of the procedure.

ExecuteProc

The SQL code will be generated. Put in the values of the parameters you need and press OK.

RunOracle

As you see, we deal with the output of this Oracle procedure, that’s because we have SQL code which retrieves the result-set from the JDBC driver.

In the cases where you run just a simple procedure with no output, DataGrip will generate SQL code just running this procedure. Again, you’ll need to add the values to the parameters. This is a PostgreSQL example.

RunPostgreSQL

Note, that you can run the procedure by clicking on a button in the toolbar when opening the source code.

Code style per data source

As you perhaps already know, you can create different schemes of Code Style.

ActionsOnCodeStyle

Now any of them can be used specifically for each data source. To do this, go to the Options tab of the data source properties.

SetCodeStyle

That’s all for today. Take DataGrip 2018.2 EAP for a spin!

Your DataGrip Team

Comments below can no longer be edited.

10 Responses to DataGrip 2018.2 EAP 3

  1. Edoardo Luppi says:

    July 16, 2018

    Awesome as always, thanks!

    • Edoardo Luppi says:

      July 16, 2018

      Btw, two features I look forward are partial DB introspection and… the Oracle procedure debugger (I think I told you this a million times hahaha) 😉

  2. Anand says:

    July 24, 2018

    great job team but only a PostgreSql debugger will make me buy this.

    • Maksim Sobolevskiy says:

      July 25, 2018

      It’ll happen one day!

  3. Denis Kozlov says:

    July 25, 2018

    Great! Procedure execution feature is a step forward to full-featured IDE for DB-development with debugger and excellent code completion. I really hope I can replace my PL/SQL Developer with DataGrip someday.

    • Maksim Sobolevskiy says:

      July 26, 2018

      So do we!

  4. renyanbin says:

    July 26, 2018

    U are doing a very good work,can u add the batch import and export functions into the new versions please,thank you very much.

    • Maksim Sobolevskiy says:

      July 26, 2018

      Can you please elaborate? If you run the huge script it is already batch update.

  5. Nabi says:

    November 14, 2018

    introspecting is so slow!!!

    • Maksim Sobolevskiy says:

      November 21, 2018

      What database do you use?