flamerobin
flamerobin copied to clipboard
[FR] more user friendly SQL editor
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