I like the sql editor built into DBVis; auto complete and other features work well. But sometimes I need to make pretty aggressive changes to the script and would like to use a more full featured editor for a few minutes.
I would like a hot key to press while I am in the sql editor that will bring up my choice of editor with the file. Then when I exit the editor the file is placed back into the built in editor.
Right now I cut and paste the script between the editor and the built in editor; This is okay, but it is tedious and a bit error prone.
Shelling out to VS Code to edit a Snowflake stored proc with all the VS Code editing goodies built in but actually managing the running of the stored proc within the DbVis environment would be awesome thing.
We will look into this in an upcoming maintenance version.
I quite often find my self comparing script files side by side. I usually do this with jDiff plug-in and jEdit. Or I make changes using regular expressions but I have to admit, I did not check DbVis capability with respect to this.
I guess I would be fully satisfied if DbVis checked if a file has changed on disk when the open file gets focus be it because DbVis regains focus or a tab switch. In case of a change on disk, I would like DbVis to ask what to do, reload possibly discarding changes in DbVis thereby, do nothing or exclude the file from being checked permanently or until the next reopen of the file. I am thinking along the feature of jEdit less. kate is much less flexible there.
Thanks for the suggestion. I've added your vote for this feature.