flamerobin icon indicating copy to clipboard operation
flamerobin copied to clipboard

[FR] more user friendly SQL editor

Open mrx23dot opened this issue 3 years ago • 0 comments

Based on my experience with DBeaver/MsqlWorkbench the built in SQL editor could improve a lot.

  • common sql scripts could be stored in the database tree, this is handy for maintenance, faster then always finding them in file browser
  • CTRL+F5 should run currently selected SQL line ending with ';' (defacto standard)
  • F5 should run whole file (defacto standard)
  • ALT+cursor up/down could move selected lines one line up/down (standard in IDE-s)
  • CTRL + F could search in the query result (find in columns)
  • columns shouldn't expand to max data len by default, in case we have many column/long data
  • pointing to a cell could display a hint with full content of cell (in case doesn't fit column)
  • sorting of visible result columns without re-executing the script with SORT BY
  • float is displayed with extra trailing zeros: 4784690960000000000.000000 wastes space
  • monospace font would be ideal by default
  • full line highlighting would be very useful in case selecting cell and scrolling horizontally
  • when editing a cell and clicking on commit the status window closes, which is annoying, it's useful to see what's happening, I would recommend having 3 windows always open: text editor, result table, status. Please see it in DBeaver.
  • commit operation doesn't mention how many rows were updated
  • not sure if possible but a time profiling button, showing me why a simple "select first 10 *" takes 10secs on a remote server (query execution path is only 60ms)

Just to make life easier in the long term. flamerobin is still the fastest editor compared to even the commercial ones. Cheers

mrx23dot avatar Feb 10 '22 11:02 mrx23dot