It looks like the VSCode extension version is missing the connection and object explorer that the standalone app contains. That's unfortunate.
A few other issues:
Creating a connection from the command palette can not use a non-default port. You'll need to edit the settings file by hand to change that.
Currently no support for SSH tunnels (unless you launch a tunnel yourself from a terminal). I've opened a GitHub issue for that support.
When running a query it keeps asking me for a username for the connection, even though the username is configured in the connection profile.
I currently use datagrip, but I'd much prefer to stay within the vscode interface rather than switching between the two, as I'm much more familiar with the vscode keyboard shortcuts and command palette. It's never really obvious which connection a datagrip "console" is attached to.
I appreciate your efforts to put down missing functionality. Products evolve over time, cant expect everything in first cut and compare it with product which is staying for quite sometime
I don't really see how people are supposed to connect to databases without SSH tunnel support. Are you supposed to be connecting to your development localhost database or be inside corporate network where direct connection to the database is allowed?
Most people use a VPN of some sort when connecting to remote databases
Our DB servers don’t have any ports listening on the internet, not even SSH.
TLS can be enforced for DB connections (both pg and mssql support this), but that’s still prone to credential stuffing and the client machine isn’t usually authenticated. Lots of regulations generally require some extra security layer protecting connections to the DB.
A few other issues:
Creating a connection from the command palette can not use a non-default port. You'll need to edit the settings file by hand to change that.
Currently no support for SSH tunnels (unless you launch a tunnel yourself from a terminal). I've opened a GitHub issue for that support.
When running a query it keeps asking me for a username for the connection, even though the username is configured in the connection profile.
I currently use datagrip, but I'd much prefer to stay within the vscode interface rather than switching between the two, as I'm much more familiar with the vscode keyboard shortcuts and command palette. It's never really obvious which connection a datagrip "console" is attached to.