Ability to remember the last SQL script path when saving scripts to a custom folder

[alexvto]

Is your feature request related to a problem? Please describe.
I prefer to save all files related to a project into a custom folder, with relevant names, for instance C:\PROJECTS\Project_ABC\VERIFY_CLAIMS_DATA.sql, so I can take periodic backups of only one folders for all my projects.

Describe the solution you'd like
It would help if DBeaver would remember the last save location (C:\PROJECTS\Project_ABC) , instead of directing me every time to C:\Users\MYNAME\AppData\Roaming\DBeaverData\workspace6\General\Scripts.
Since I woold work on Project_ABC for a few hours or days, all scripts would be saved in C:\PROJECTS\Project_ABC;
later, when I would switch to Project_DEF, after saving the first script in C:\PROJECTS\Project_DEF, DBeaver should remember the Project_DEF location.

Describe alternatives you've considered
A way to configure this behaviour, for instance a Preferences dialog that says "Save your script in the default location or select a folder"

Thank you for considering this.

[alexvto]

Also, maybe add "Save As" to the right click menu in SQL Editor ?

[arhayka]

@alexvto Thank you for the idea! We'll discuss it with a team.

[arhayka]

Hi @alexvto
I see two ways that can help you save scripts more conveniently:

1. You can create a new project, uncheck the Use default location option, and specify a custom project location. All scripts in this project will be saved in the selected project folder.
   https://dbeaver.com/docs/dbeaver/Projects/#creating-a-project

2. Use the “Save As” option. Go to Main Menu → File → Save As. DBeaver remembers the location of the last saved script, making it easier to save subsequent scripts in the same place.
   If you use this option frequently, you can assign a shortcut in Preferences → User Interface → Keys by using the Binding field.