What PostgreSQL has over other open source SQL databases: Part II

Re:What PostgreSQL has over other open source SQL databases:... by djrobstep on Saturday October 24, 2015 @08:21PM (#10445408)

I absolutely love Postgres, for these and other reasons, but the one weak point is the official GUI client. It's garbage, and unfortunately it's one of the first things people ask me about when I encourage them to use Postgres.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by phunge on Sunday October 25, 2015 @12:06AM (#10445940)

I had the same sentiment. I eventually ditched the gui and went back to psql (the CLI) based on this advice: http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Pos...

The CLI is really really good for a CLI. Wagon is also good, my coworkers have been using it to pull data and like it a lot.

Overall love postgres, it's been 6 months (since starting a new job) and I'll never go back.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by reactor on Saturday October 24, 2015 @10:38PM (#10445733)

http://dbeaver.jkiss.org works pretty well for me

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by sandGorgon on Sunday October 25, 2015 @12:36AM (#10445986)

This looks awesome! Are you able to use the jsonb data types through this?

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by reactor on Sunday October 25, 2015 @02:27AM (#10446175)

I'm not sure as I'm not started playing with Jsonb yet! but give it a try.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by aw3c2 on Sunday October 25, 2015 @06:26AM (#10446537)

I never heard of this and I was looking for something like this for ages. Thank you!

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by DevX101 on Saturday October 24, 2015 @08:24PM (#10445413)

I just bought Postico. Best Postgres client I've come across so far for OSX. Would recommend if you're on a mac.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by devbug on Saturday October 24, 2015 @09:58PM (#10445644)

I just purchased Postico a few days ago. It's already money well spent. Obviously Postico needs time to ripen, but it's already been a huge productivity boost.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by leesalminen on Saturday October 24, 2015 @08:38PM (#10445444)

How does it compare to Sequel Pro for MySQL?

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by putlake on Saturday October 24, 2015 @09:05PM (#10445514)

Sequel Pro for MySQL is better because it's a more mature product. I've been using it for a while so there is a little familiarity bias.

I have also paid for Postico (before they launched on the Mac App Store). As far as Postgres clients go, it is the best.

Edit: When evaluating Postgres GUI clients, make sure they support the new JSON and JSONB data types.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by pacquiao882 on Sunday October 25, 2015 @06:44AM (#10446574)

For Windows users, HeidiSQL is a very solid open source client for interacting with Postgres.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by phaedryx on Saturday October 24, 2015 @08:35PM (#10445438)

I've been using Valentina Studio lately and like it so far. Postico looks good too.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by saltedshiv on Saturday October 24, 2015 @09:11PM (#10445532)

I use Navicat, its fantastic.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by eropple on Sunday October 25, 2015 @12:46PM (#10447373)

I've been a long-time Navicat user, but it has a lot of trouble with any Postgres-specific features. I kind of recommend Postico, even in its incomplete state, for wrangling Postgres.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by zenocon on Sunday October 25, 2015 @11:29AM (#10447123)

Use JetBrains 0xDBE -- still available now as early pre-release for free.

[ Parent | on HN ]