News for hackers. Stuff that matters.
Re:Ask HN: How is your experience with Oracle, Postgres and ... by breakingcups on Friday June 12, 2015 @07:30AM (#9705189)
PG: Great in theory, virtually no GUI tooling that's up to the task. MSSQL: Excellent, wish it ran on Linux.
Re:Ask HN: How is your experience with Oracle, Postgres and ... by samspenc on Friday June 12, 2015 @10:13AM (#9705965)
Have you tried Aqua Data Studio? Its not just for PG - can connect to quite a few different DB types and works really nicely with all of them.

Aqua is commercial software, but pretty inexpensive, and we use it at my company to connect to the different databases we work with.

Re:Ask HN: How is your experience with Oracle, Postgres and ... by breakingcups on Friday June 12, 2015 @10:27AM (#9706057)
I haven't yet, I might look into that.
Re:Ask HN: How is your experience with Oracle, Postgres and ... by tuyguntn on Friday June 12, 2015 @08:44AM (#9705473)
Could you elaborate, why PG is great on theory? I have mostly worked with only PG and have little experience with MSSQL, but latest versions of PG is really great.
Re:Ask HN: How is your experience with Oracle, Postgres and ... by breakingcups on Friday June 12, 2015 @10:30AM (#9706079)
Well, reading about all the features PG has makes me very excited. Purely querying from PG also makes me happy thus far. What I'm uneasy about is administration (backups, etc.).

I guess part if it is also that I'm very used to the MS tooling, which is truly superb. This makes some of the administration steps for PG seem a bit outdated and clunky, which could be a very unfair bias from my side.

Maybe another way of putting it would be that the core is great, but the edges a bit rough for my spoiled, delicate hands.

Re:Ask HN: How is your experience with Oracle, Postgres and ... by icebraining on Friday June 12, 2015 @06:42PM (#9709029)
Have you looked at third-party tools? Postgres may not come with everything builtin, but it supports the necessary underlying features for external tools like Barman[1] to work.

[1] http://www.pgbarman.org/

Re:Ask HN: How is your experience with Oracle, Postgres and ... by subrat_rout on Friday June 12, 2015 @06:16PM (#9708899)
What about pgAdmin3. I have been using is for last two years and it gets the job done.