AppCode
CLion
DataGrip
GoLand
IntelliJ IDEA
MPS
PhpStorm
PyCharm
Rider
RubyMine
WebStorm
Toolbox App
.NET Tools
ReSharper C++
Space
TeamCity
Upsource
YouTrack
Datalore
Hub
Kotlin
Ktor
News
Team
JetBrains PlatformDataGrip 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.
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.
Remember that the process information is available on the Database tab of Event Log. We added a link to the error file.
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.
Data Source color (Context menu→ Color settings) now affects the console and result tab toolbars.
Aliases casing now can be set in Settings → Editor → Code style → SQL. Aliases are offered in code completion.
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.
That’s it! Don’t forget about twitter, forum, and the issue tracker.
Your DataGrip Team
_
JetBrains
The Drive to Develop
Sergio says:
February 6, 2017I 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:
February 6, 2017Thank you, Sergio! We have an issue in our youtrack for this: https://youtrack.jetbrains.com/issue/DBE-3640
Kostyantyn says:
February 21, 2017Hi 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
Daas says:
February 21, 2017Please, please in DataGrip 2017.1 add a query timer. See -> DBE-269
Maksim Sobolevskiy says:
February 22, 2017We plan! Thanks.
Zero says:
February 22, 2017Hello,
DataGrip support for NoSql databases planned?
Thanks.
Maksim Sobolevskiy says:
February 27, 2017Not in closest future: https://youtrack.jetbrains.com/issue/DBE-41
Luciano says:
February 27, 2017please add introspection oracle db and better support for pl sql
Maksim Sobolevskiy says:
February 28, 2017What kind of introspection do you mean?