display sql files after hedisql started

[expired user #10716]'s profile image [expired user #10716] posted 7 years ago in Feature discussion Permalink

'PL/sql developer' has a feature called 'Files', and you can specify a path, then everytime the 'PL/sql developer' is started, the sql files located in the path specified by you will also be displayed, and I can double-click the file to load and open it and maybe execute some sql clause. And if I have many grouped frequently used sql file, it will save the time to open those files one by one. It's a very useful feature. I wonder whether this feature can be added to hedisql?

Both 'PL/sql developer' and 'navicat for mysql' have these kind of feature, and you may see it in the attachements.

2 attachment(s):
  • img01
  • img02
ansgar's profile image ansgar posted 7 years ago Permalink

Different applications have similar features often implemented differently. HeidiSQL also has a "Files" feature, but it's called "Snippets", and they are displayed in the right sided box on each query tab:

  • this lists all files located under "C:\ProgramData\HeidiSQL\Snippets\" (the path is customizable)
  • to create a new snippet, type or load something into the query editor, then click "Save as snippet" in the context menu
  • new files are automatically displayed under the "Snippets" tree node
  • doubleclick a snippet to load it into the editor
  • rightclick a snippet for more options
[expired user #10716]'s profile image [expired user #10716] posted 7 years ago Permalink

I have tried the 'Snippets' feature before, but I don't know there is a context menu on it. So I just clicked it and all the sql clauses was inserted into the current cursor, which was not I want. But now I can just click the 'Load' menu on one of snippet, and the file will be loaded in the current tab. But if I make some changes without saving it to file, when I load another file, then the changes will disappear without any confirmation. Can I set something like 'auto saving' in hedisql? I didn't find it.

Please login to leave a reply, or register at first.