List of problems and new features

Whlie using the tool I've collected few problems  and possible features which would make the tool even better.

Problem list:
p1) "Narrow down on typing" when using option "Surround With"
If you have several live templates that starts with the same name 0xdbe automatically grabs the first one. In the picture bellow when typing letter 's' the first item will be evaluated.


p2) Detailed error description
Error descriptions returning from the engine are really scarce and sometimes I have to run the query in sql developer to get more information about it. Example of a locked account in 0xdbe can be seen in the pic.


p3) "Split vertically" refreshes both views (oracle package development)
If developing directly on the database it can happen that you can lose uncommitted changes if "Split vertically" is selected. Reason for that is that 0xdbe refreshes both objects/views.


p4) Painful development with oracle procedures
Static code analysis in most cases does not detect any issues which often leads to corrupted packages (no errors detected, scarce error descriptions, etc..)


Feature list:
f1) Basic calculations on selected numeric field in data viewer (picture example from excel)


f2) Show number of columns in the result set of the data viewer for the executed query

f3) Highlight different cells comparing previous and current row
This feature comes very handy when dealing with loads of columns


f4) Execute query at cursor level
This  option would be useful when dealing with several nested queries but  executing just some of them. Currently I am solving this issue by  expanding the selection and using a shortcut for "execute selected". The  drawback is that I have to expand the selection 7 times before covering the  desired result. The square in the bellow pic shows the query that I want  to run. Cursor is marked in yellow.



f5) Visual distinction between private and public procedures
In sql developer distinction is done by obscuring private methods



Attachment(s):
f3_diff.png
p1_narrow_down.png
p2_error_desc..png
p3_split.png
f4_curs_level_exec.png
7 comments
Comment actions Permalink

Picture for the first feature.



Attachment(s):
f1_basic_stats.png
0
Comment actions Permalink

Any feedback on this?

Another strange behaviour occurs with bookmarks. I do not know how but I managed to bookmark a line twice (one reference is probably null). After 0xdbe was restarted the problem has gone.



Attachment(s):
p5.png
0
Comment actions Permalink

Hello,

Thank you for your feedback very much! Sorry for deplayed reply, please see below.

p1) "Narrow down on typing" when using option "Surround With"


It looks like you are using custom "Surround With" **live template**. In this case you can choose it(your own live template) via dedicated shortcut for Live Templates: Crel+Alt+J, then you will be given menu with only Live Templates and will be able to choose needed template without conflict. If you want to choose action from "Surround With" menu use corresponding mnemonics: 1, 2, 3 etc. Other solution is no select **Disable mnemonics in menu** and **Disable mnemonics in controls** options in Settings | Appearance & Behaviour | Appearance menu or change live template abbreviation.

See also related threads in there YouTrack tickets:
https://youtrack.jetbrains.com/issue/IDEA-127318
https://youtrack.jetbrains.com/issue/IDEA-101364 - feel free to vote for this one

p2) Detailed error description


IDE returns the error codes (and associated text from the server). Can you please give examples of the same error in 0xDBE and SQL Developer for some situation? I will file an enchantment requests in out tracker.

p3) "Split vertically" refreshes both views (oracle package development)


Thank you, created the https://youtrack.jetbrains.com/issue/DBE-1330 . Please vote (see https://intellij-support.jetbrains.com/entries/23368682 if you are not familiar with YouTrack)

p4) Painful development with oracle procedures
Static code analysis in most cases does not detect any issues which often leads to corrupted packages (no errors detected, scarce error descriptions, etc..)


Please file YouTrack issue for specific cases providing the example so that we could fix each one. Thanks.

f1) Basic calculations on selected numeric field in data viewer (picture example from excel)


Thank you! Created the https://youtrack.jetbrains.com/issue/DBE-1331 . Please vote.

f2) Show number of columns in the result set of the data viewer for the executed query


Do you mean the number of each column? When this functionality would be needed for you? Note that you can choose to display column names here https://db.tt/asQmqtPx

f3) Highlight different cells comparing previous and current row
This feature comes very handy when dealing with loads of columns


Do you mean some specific selection feature only for rows next to each other or just to be able to select any cell?

f4) Execute query at cursor level


Please vote for https://youtrack.jetbrains.com/issue/DBE-297 for executing current statement under cursor.

f5) Visual distinction between private and public procedures
In sql developer distinction is done by obscuring private methods


Please vote https://youtrack.jetbrains.com/issue/DBE-1332

Another strange behaviour occurs with bookmarks. I do not know how but I managed to bookmark a line twice (one reference is probably null). After 0xdbe was restarted the problem has gone.


This is know issue, please follow the https://youtrack.jetbrains.com/issue/IDEA-98718

0
Comment actions Permalink

Hi,
here are some additional informations about the issues:

p1) Like I could read from the link "speed search" would provide ambiguity so I will try to use mnemonics instead.

p2) Example in the attachment is from sql developer. The difference is that sql developer shows the cause of the error too. Maybe a feature of setting a level of logging would come handy.

f2) Here I was thinking just about a simple count of total number of column in the query that would be located in the data viewer area near the slider displaying row range. Hiding elements from data viewer that you do not use frequently would be nice to have too.

f3) Comparison would take previous and current row and then compare cells in their correspodning columns. Cell from the current row that has different value in a previous row would be collored.



Attachment(s):
p2_error_details_sql_developer.png
p2_error_details_0xdbe.png
0
Comment actions Permalink

Thanks for your feedback.

>p2)

Created the https://youtrack.jetbrains.com/issue/DBE-1599 . Please vote for the request.

>f2)

See http://i.imgur.com/oTdz3es.png . Does it help?

>f3)

Please vote for https://youtrack.jetbrains.com/issue/DBE-1105

0
Comment actions Permalink

f2) yes that would help but probably its position would bring some confusion in combination with arrows for row pagination?

0
Comment actions Permalink

You are very welcome to file a suggestion at https://youtrack.jetbrains.com/issues?q=%23DBE+ for the best way of implementing this.

0

Please sign in to leave a comment.