Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FR] more user friendly SQL editor #248

Open
mrx23dot opened this issue Feb 10, 2022 · 0 comments
Open

[FR] more user friendly SQL editor #248

mrx23dot opened this issue Feb 10, 2022 · 0 comments

Comments

@mrx23dot
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant