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
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
Thank you, Sergio! We have an issue in our youtrack for this: https://youtrack.jetbrains.com/issue/DBE-3640
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
Please, please in DataGrip 2017.1 add a query timer. See -> DBE-269
We plan! Thanks.
Hello,
DataGrip support for NoSql databases planned?
Thanks.
Not in closest future: https://youtrack.jetbrains.com/issue/DBE-41
please add introspection oracle db and better support for pl sql
What kind of introspection do you mean?