DataGrip usability

Answered

As a new user to this app I hit several really odd stumbling blocks trying to get this tool up and running. Which I have never encountered on any other IDE. Thought I would post them here so you guys have some feedback

  • Took me 5 mins to figure out how to connect SQL Server - I hit ctrl+alt+shift+s, and picked SQL Server, and fiddled around for ages. Then I noticed I was picking it from the drivers list, not the little green "+" at the top left.
  • I had to manually enter the port for SQL Server, can't it store one by default?
  • Then it took me 2-3 mins to figure out how to re-open a text editor window to write a query. I just randomly clicked the little command prompt button (not what I would associate with a text editor) - the button for it looks like a command prompt window. Found nothing that seems obvious from the dropdowns.
  • Changing the font does not appear to work
  • The blue outline you get around suggestions/errors in the text editor is really obnoxious and too close to the text making it hard to read
  • F5 does not run the query but brings up a copy prompt - i guess a default preference but a little weird from VS/SSMS land
  • ctrl+enter constantly prompts to choose a selection to run, why not just the whole script?

 

3 comments
Comment actions Permalink

Hello and thank you for your feedback. I'm duplicating here some parts of my reply to you from the support request you've raised

Thank you very much for your feedback, we appreciate it. Sorry that it took long time to set up the tool, perhaps some work flows indeed can be very different comparing to MS SQL studio but we are constantly working on making it as much obvious as possible. Btw there is a documentation, including quick tutorials with examples at https://www.jetbrains.com/help/datagrip/connecting-to-a-database.html

Please see also related to MS SQL server set up posts:
https://blog.jetbrains.com/datagrip/2016/06/21/connecting-datagrip-to-ms-sql-server/
https://stackoverflow.com/a/36257052/2000323

>Changing the font does not appear to work

Could you please describe the steps you perform and the result you see? Thanks.

>The blue outline you get around suggestions/errors in the text editor is really obnoxious and too close to the text making it hard to read

Could you attach a screenshot? Do you mean the border for the current statement? Please see https://stackoverflow.com/a/45104755/2000323

>F5 does not run the query but brings up a copy prompt - i guess a default preference but a little weird from VS/SSMS land
>ctrl+enter constantly prompts to choose a selection to run, why not just the whole script?

Please see https://www.jetbrains.com/help/datagrip/writing-and-executing-sql-statements.html#configure_execute on how to execute the query and choose the default behaviour for this action.

0
Comment actions Permalink

>Changing the font does not appear to work

Could you please describe the steps you perform and the result you see? Thanks.

I go to File > Settings > Editor > Font > Change the font dropdown and hit Apply. Now I see "current editor font: blah defined in colour scheme" But as a new user I have no real clue what that means I just expect the font i pick to override everything else.

This is the border I'm talking about:

https://i.imgur.com/wImdYSk.jpg

It's right up on the text and actually obscures what its attempting to highlight.

Execute selection would be nice, I have not got a clue as to what smallest/largest statement execution is.

 

The whole UI is just very very confusing.

0
Comment actions Permalink

Thesimo, please see post Box Around Sql Code for instructions on how to get rid of the box.

Regarding the ctrl-enter, it allows you to run just subqueries within a larger script. It is very handy, for me at least, during development to test along the way.

0

Please sign in to leave a comment.