Maybe give it a try?
Then it will become the swiss army chainsaw for DBdevs and DBA's.
I am happy with electron apps when quality is at the level of VScode.
Buy more RAM ;)
Think I'll stick to DataGrip personally, though I'd be interested to see some performance benchmarks to disprove my own comprehension of the quality of apps built primarily in HTML/JS/Electron.
Surely you don't use gmail or any other webmail or a web service?
Under the most charitable interpretation of the above, the Telegraph meant what it said, and only ever intended to use the data thus collected to optimize HVAC output to only those areas with enough human activity to warrant it.
But, you see, once they had the data about who was at their desk and who wasn't, it behooves them to act on it.
But why wait for evidence when posting "Micro$oft is evil" is more fun?
But that’s not at all what they said. The argument they used applies to anyone collecting data. Just like in the example they used.
For Europeans there is the GDPR.
This is also one of the things that AFAIK should be covered by the GDPR (contrary to the cookie banners with opt out that I personally expect will get their punishments soon.)
VS Code seems to have driven a lot of improvement to features most important to users based on this data.
Desktop apps are offline and so this is just gross. Make the app good by having a vision and employing domain experts, not trying to drive button click metrics or whatever.
I remember the file menu operations being hidden behind the round logo in the upper left corner.
The Microsoft ones are pretty good, for me at least :)
It's a developers tool
Remember, this behaviour (even if it is explicitly mentioned in the EULA) used to be called spyware and tools were created to detect and remove such things. Then the big companies caught on and spun it in the "but it's for the users!" direction, and now it's harmless? I see the "if you're using this and Azure you should trust Microsoft already" point, but this is presumably software that isn't for just interacting with Azure.
Given the sort of data that usually resides in databases, an application for interacting with them that will occasionally make connections out into the Internet just triggers suspicion regardless.
Seriously, even if performance of JS has been dragged kicking and screaming in to the 21st century now, the huge memory footprint of these abominations feels utterly wrong to me.
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.
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.
* This looks like a neat tool. Will check this out and compare it to DataGrip, Dbeaver etc.
* It's electron. This is terrible.
* There's analytics code in there. This is terrible.
Microsoft's VS Code is a good example - I've also been using Azure Data Studio for SQL Server for a while now, and have found it to be performant, extensible and nice to work with (it's surplanted SSMS for me). I've been hoping Microsoft would add Postgres support to Data Studio for a while, so I'm very pleased to see this.
well if you know postgres, you will know that at first there was pgadmin3, which was really fast and a really good/decent application.
However the desktop application is just garbage.
When compared against native applications, not at all.
I use it sometimes, because I have to, that is all.
I disagree. Compared to Visual Studio, for example, VS Coe flies.
I realise they have very different feature sets though, so it might not be the best comparison - but I even switched from a native Windows text editor (Notepad2) to VS Code because startup time is almost as fast as Notepad2, and in-use it's just as performant (sometimes moreso, such as regex on a large file) but with far more features. And it's cross-platform, so I can use the same VS Code I'm used to on Windows and my MBP.
Notepad++ and Sublime are instantaneous versus VSCode.
Sorry, this is another point I disagree with. As a developer I can appreciate the need to understand how an application is used, and to get diagnostic data when things go wrong. What is terrible is when you can't opt-out of telemetry, and when what is sent is completely opaque - that's not the case here.
Since I have to work with both postgres and ms sql on a daily basis I'm usually doing the database things in Dbeaver and move the code over to R/Python when I'm happy with the sql code.
You can disable the analytics with one line of config.
Starts up very quickly, doesn't have bunch of options and stuff but I think it has enough to be far more intuitive. I'd say the interface is almost comparable to SequelPro just not as polished. (Font sizing, space padding and column sizing. Small stuff but it does feel awkward to me.)
Microsoft really turned it around by supporting developers, IMO.
Being able to use the same tool for Postgres would be awesome (we use both Postgres and Redshift here, too); I've long felt that SQL Server's a god-awful DB with awesome tooling while PostgreSQL's an awesome DB with god-awful tooling, and now I'm looking forward to finally getting the best of both worlds.
I wonder if it's possible to create extensions for arbitrary ODBC and/or JDBC connections? If so, then that'd be yet another thing I could manipulate with ADS (our ERP exposes its database via a presumably-proprietary DB protocol for which they provide their own ODBC and JDBC connectors). It'd be awesome to have a properly-good one-stop shop for all my SQL-finagling needs.
Now if only I could integrate all this with Emacs somehow...
EDIT: alas, it does not seem to want to install correctly on Slackware, whether via ADS' extensions manager or by manually downloading/installing the VSIX package. Seems to hang on "Starting pgsql service", and any attempt to actually do anything throws a giant "Provider doesn't exist. id: PGSQL" error (and attempting to run queries anyway just throws "Error: No Handler Registered").
The main thing it can’t do well is export/import large databases but that’s what ‘pg_dump’ and friends are for.
Downloaded it, got it connected to my localhost Postgres server. Opened a script file, nice syntax highlighting, yay :)
Syntax error at or near "drop". Oh dear. Ah well, back to Code and psql it is...
I was a heavy pgAdmin3 user at $lastjob and the fact that clicking some elements would freeze it wasn't great. This looks to cache all details on connection.
The data view doesn't really work with very long text fields, maybe allowing users to edit those in a panel or modal could help UX.
Also, it doesn't really handles schemas, just prepend those to the table name, instead of treating it like a "folder". Schemas have permissions so we need to "see" those.
With the great hole that pgAdmin4 left, and with DataGrip being more on the heavy side, I think this app can grab a good share of users.
“The Postgres server can be hosted on-premises, in a virtual machine (VM), or from the managed service of any cloud provider.”
Data-tier Application Component Packages