Uncategorized

DataGrip 2018.2 EAP 3

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. Avatar

    Edoardo Luppi says:

    July 16, 2018

    Awesome as always, thanks!

    • Avatar

      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. Avatar

    Anand says:

    July 24, 2018

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

    • Avatar

      Maksim Sobolevskiy says:

      July 25, 2018

      It’ll happen one day!

  3. Avatar

    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.

    • Avatar

      Maksim Sobolevskiy says:

      July 26, 2018

      So do we!

  4. Avatar

    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.

    • Avatar

      Maksim Sobolevskiy says:

      July 26, 2018

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

  5. Avatar

    Nabi says:

    November 14, 2018

    introspecting is so slow!!!

    • Avatar

      Maksim Sobolevskiy says:

      November 21, 2018

      What database do you use?

Discover more