Well if a Java application will be able to go via SSH to VPS and to the remote database?
Determine the choice of development language and framework for the implementation of desktop applications for Windows, which could, entered username/password to connect to the remote server via SSH, navigate there through the folders and a full-fledged work with files to change to extract the folder from the archive, delete files, start mysql with the command line parameters. In addition, it must be able to work with the local file system - to add to the archive folder, copy files via SFTP to a remote server to the desired folder and save your settings somewhere preferably in nosql storage, requiring no additional driver installation on the computer and libraries.
The Java programming language suitable for this task? And what testing framework in Java to choose to start developing. The program basically is simple - select a folder to zip archive, send the remote address to connect to the remote server, unpack the sent items folder, to make changes in some configuration files.
I have been in your Arsenal of php and Vue2.js but I would like to make a universal solution.
And what DB will advise you to save your settings, logins, settings addresses.
Still need to learn Java with this project and decided to start.