I certainly don't know what PostgreSQL Studio is like, but I think there's a lot of room for improvement in user-interface with pgAdmin. I tried using it but quickly gave up. It requires way too many mouse clicks to see the things I want to see.

(By comparison, I tend to enjoy using phpMyAdmin for MySQL.)

As per OpenSCG: http://www.openscg.com/2013/10/postgresql-studio-1-0-is-out/

The standard bearer for PostgreSQL GUIs is pgAdmin, but that requires people to make a database connection across the internet which they may be reluctant to do if they don’t have a VPN of some sort set up. The right thing is to have a web-based GUI allowing users to connect to their database through a browser. PhpPgAdmin is an option, but many of the new PostgreSQL users I’ve talked to like the newer look and feel of sites like Heroku and are turned off by the UI of phpPgAdmin.

So, instead of making a database connection through the internet, you tunnel it over http? What can you gain by doing that?

Looks like what I wanted is already here. I think I can now learn Postgres on a Chromebook which just has a web browser. (I had created a free database on heroku previously.)

https://teampostgresql.herokuapp.com

Current version of pgAdmin adds support for connecting via ssh, though I haven't had cause to try using it yet.

It works. I've used pgAdmin's ssh support for years.

It can be used to connect to heroku instances also, which is useful.

You don't need a VPN, pretty much any server running postgresql is also running sshd.

pgadmin is a postgres adoption prevention mechanism, hopefully this tool will be developer friendly, and stable.

I have to be the only person on the planet that actually likes pgadmin.

The biggest problem with PGAdmin is it prioritizes the least used features, pushes them in your face, while burying the things you probably use most.

It's about ten clicks to make a simple query. It's nearly as many just to see what columns a table has.

The same thing in Seqeuel Pro? Two or three clicks. Max.

It literally just took me four clicks (one of them a double-click on the database server in the tree pane; so, yes, if you want to get pedantic, I pressed the trackpad five whole times) — inclusive of launching the app — to issue a query:

  1. Launch the app
  2. Double-click the db host to connect
  3. Dismiss the dialog box prompting me to install the server instrumentation tools
  4. Click the SQL magnifying glass icon in the toolbar.

That third click could be eliminated from ever being required again with the addition of checking the "don't show this dialog box again" box before dismissing the dialog.

So, best case, three clicks — four if you click on the "OK" button on the password dialog, instead of hitting enter. Yeah, PgAdmin isn't the prettiest tool on the planet, but demonstrably false hyperbole is unbecoming.

1. Launch the app. 2. Click the host. This apparently selects it. 3,4. Double click the host to force it to connect. 5. Click OK on the login screen even though it's set to "Store Password". 6. Click to select the proper database. 7. Click to magnifying glass. 8. Find the query window, which has a tendency to show up in really awkward places if you remove your second screen, click to drag it back somewhere useful, such as visible on your screen.

It feels like ten because of all the steps that are totally unnecessary. Sequel Pro, by contrast, doesn't have a separate query window, you never need to find it, and will connect automatically.

PgAdmin seems to ask an awful lot of stupid questions, and there's no way to turn them off. The "Don't show this dialog again" setting for each, as you mention, would help a lot in this department.

I used it for my book (Instant Postgres Starter) mainly because I wanted to show a cross-platform UI that would look consistent. Day to day I don't use it. Maybe if it was awesome I would but I don't feel hamstrung by the CLI tools--the opposite, really.

Nope.