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

This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to DataGrip 2018.2 EAP 3

  1. Edoardo Luppi says:

    Awesome as always, thanks!

    • Edoardo Luppi says:

      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) ;)

Leave a Reply

Your email address will not be published. Required fields are marked *