5 ms·
As per OpenSCG: http://www.openscg.com/2013/10/postgresql-studio-1-0-is-out/ http://www.openscg.com/2013/10/postgresql-studio-1-0-is-out/ The standard bearer f
by jalan 13y ago
As per OpenSCG: http://www.openscg.com/2013/10/postgresql-studio-1-0-is-out/ 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.
- radiowave 13y agoCurrent version of pgAdmin adds support for connecting via ssh, though I haven't had cause to try using it yet.
- auxbuss 13y agoIt works. I've used pgAdmin's ssh support for years. It can be used to connect to heroku instances also, which is useful.
- marcosdumay 13y agoSo, instead of making a database connection through the internet, you tunnel it over http? What can you gain by doing that?
- 3825 13y agoLooks 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 https://teampostgresql.herokuapp.com
- asdasf 13y agoYou don't need a VPN, pretty much any server running postgresql is also running sshd.