DataGrip 2017.1 new EAP build

Hello! It’s time for the new EAP build for 2017.1 which is going to be released later this March. There are several notable features, let’s take a look at them.

Schema management

We are still working on the schema selection UI. Now it’s a tree with the ability to choose the current schema. Of course, if the current schema is changed in some other place, DataGrip will show the new one.

SchemasPattern

The Schemas tab comes back to the data source properties dialog. We added the Pattern field where you can describe what you want to be introspected. The Ctrl+Q (Ctrl+J for OSX) shortcut will give you information about the syntax.

Import CSV

First: Drag-n-drop csv files to the datasource.

Second: Import zipped CSV files.

ImportCSV

Remember that the process information is available on the Database tab of Event Log. We added a link to the error file.

ImportErrors

Also, importing itself has become much faster. For instance, a 50 MB file was imported for 2 minutes. Now it takes just 10 seconds.

Other enhancements

The column details in the Modify Table dialog are now opened by double-cliсk.  We changed it based on your negative feedback on single-click opening.

ModifyTable

Data Source color (Context menuColor settings) now affects the console and result tab toolbars.

Colors

Aliases casing now can be set in Settings Editor Code style SQL. Aliases are offered in code completion.

Aliases

An amusing feature for MySQL: due to errors in MySQL grammar, a database cannot run queries with some combinations of parenthesis and UNION’s. Now DataGrip can handle these situations.

MySQL

That’s it! Don’t forget about twitter, forum, and the issue tracker.

Your DataGrip Team
_
JetBrains
The Drive to Develop

 

This entry was posted in EAP, Features and tagged , , . Bookmark the permalink.

9 Responses to DataGrip 2017.1 new EAP build

  1. Sergio says:

    I think that show different colors for the table result of a query would be great. For example, blue for numbers, green for string, yellow for select and red for date

    • Maksim Sobolevskiy says:

      Thank you, Sergio! We have an issue in our youtrack for this: https://youtrack.jetbrains.com/issue/DBE-3640

      • Kostyantyn says:

        Hi Maksim,

        Should I think you prefer madness color dance in result set instead of normal standard way to show number, text, and date?

        If you ever see SQL*Plus you will note the old application DOES align values in console(!) output. Text to right border, numbers to left. MS Excel, PL/SQL Developer, SQL Developer… all these apps DO align values in result set. But DataGrip does NOT…

        I’m not objecting on any additional option in DataGrip I can disable. But could please implement the standard way of data output in result set first?

        Just in case the task I created on May 26th, 2016 https://youtrack.jetbrains.com/issue/DBE-2701

  2. Daas says:

    Please, please in DataGrip 2017.1 add a query timer. See -> DBE-269

  3. Zero says:

    Hello,

    DataGrip support for NoSql databases planned?

    Thanks.

  4. Luciano says:

    please add introspection oracle db and better support for pl sql

Leave a Reply

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