News for hackers. Stuff that matters.

A comment on SQL Tabs – Rich SQL Console for Postgresql.

Re:SQL Tabs – Rich SQL Console for Postgresql by craigkerstiens on Monday December 28, 2015 @10:03PM (#10804931)
If you're looking for a list of other clients some of the others ones include:

- Postico OSX - https://itunes.apple.com/us/app/postico/id1031280567?ls=1&mt...

- JackDB (web based) - https://www.jackdb.com/

- SQL Pro for Postgres - http://www.hankinsoft.com/SQLProPostgres/

- PGAdmin - Slightly outdated but still feature rich and fully cross platform - http://www.pgadmin.org/

And of course there's always psql which is all CLI, but incredibly flexible.

[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by tedmiston on Tuesday December 29, 2015 @02:44AM (#10805699)
To add my own daily use clients:

- PG Commander (free): a lighter version of Postico - https://eggerapps.at/pgcommander/

- Sequel Pro (donationware): a nice native GUI browser for MySQL - http://www.sequelpro.com/

[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by babebridou on Tuesday December 29, 2015 @03:50AM (#10805831)
Of course, when all else fails, you can always fallback to SQLDeveloper http://www.oracle.com/technetwork/developer-tools/sql-develo..., install the postgres jdbc driver https://jdbc.postgresql.org/download.html and ease into Postgres with your usual Oracle client.

It's especially useful if you're already using it on your day/consulting job as it naturally blends into the environment.

[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by cabraca on Tuesday December 29, 2015 @07:32AM (#10806398)
- DBeaver: Supports MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MongoDB, etc. http://dbeaver.jkiss.org/
[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by jonathankau on Tuesday December 29, 2015 @12:44AM (#10805428)
pgweb is also nice: https://github.com/sosedoff/pgweb

I'm excited to see all the work that's going into tools to work with Postgres :)

[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by mrmondo on Tuesday December 29, 2015 @02:50AM (#10805710)
This looks really quite nice, I wonder if I could swap out phppgadmin (used by some non-techie people) with it...
[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by muhic on Tuesday December 29, 2015 @05:23AM (#10806055)
+1 for pgweb. Their one-click Heroku deployment makes it easy to spin a dyno for db monitoring
[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by kweinber on Tuesday December 29, 2015 @10:50AM (#10807198)
I use Aqua Data Studio - http://www.aquafold.com It has gotten pricier over the years but I spend so much time in databases that it is worth sticking with a familiar tool that does a lot across all the different databases my clients use.
[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by infinite8s on Tuesday December 29, 2015 @04:42PM (#10809265)
Wow, Aqua Data Studio's visual analytics screen looks awfully similar to Tableau's: http://www.aquafold.com/aquadatastudio/diagrams/screenshot_v...
[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by fsiefken on Tuesday December 29, 2015 @02:35AM (#10805683)
pgcli is a good terminal alternative for psql with better autocomplete and vi mode support
[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by leeoniya on Monday December 28, 2015 @10:09PM (#10804950)
also, excellent, open source and portable pg (and mysql and mssql) client for windows:

http://www.heidisql.com/

[ Parent | on HN ]
Re:SQL Tabs – Rich SQL Console for Postgresql by chrisdhal on Tuesday December 29, 2015 @05:23PM (#10809474)
- Squirrel SQL - http://squirrel-sql.sourceforge.net/
[ Parent | on HN ]