Sessions and Multiple Connections

Sessions and Multiple Connections

Sometimes is very useful to have SQL files attached to different connections.

On version v0.19 session files were introduced along with the ability of attaching and detaching connections from files.

Session files

Session files are files that are attached to a connection.

You can use the setting sqltools.autoOpenSessionFiles to enable or disable session files to auto open when you open a connection.

If sqltools.autoOpenSessionFiles is enabled, every time you open a connection, a session file will be opened attached to the selected connection.

In addition, you may specify a folder where session files are saved using the setting sqltools.sessionFilesFolder.

Also, switching to files that are attached, the respective connection is automatically set as active.

Now imagine that you have a SQL file open and you want to attach to a connection to execute all queries against that connection. You can manually attach and detach a connection from/to your SQL file.

Thats a new feature and still need more feedback to evolve. If you have any ideas and suggestions, please open an issue to help us to keep the project evolving!