This looks interesting (via the description and screenshot in the comments...the site is down as of this writing), but what does this provide that pgAdmin (http://www.pgadmin.org/) doesn't?
(By comparison, I tend to enjoy using phpMyAdmin for MySQL.)
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.
It can be used to connect to heroku instances also, which is useful.
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.
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.
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.
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.