News for hackers. Stuff that matters.
Re:PostgreSQL vs. MS SQL Server by kidmenot on Thursday April 30, 2015 @09:43AM (#9464972)
Agreed on Navicat. pgAdmin doesn't quite cut it just yet.

Which sometimes made me wonder if, with Postgres becoming more popular by the day, there would be a market for a management tool cheaper than Navicat.

Re:PostgreSQL vs. MS SQL Server by msl09 on Thursday April 30, 2015 @09:57AM (#9465045)
Postgresql have such an amazing documentation and CLI that I prefer to use it over pgAdmin.
Re:PostgreSQL vs. MS SQL Server by toolz on Thursday April 30, 2015 @10:55AM (#9465430)
This is why I prefer postgres. Jumping into the CLI is easy and much quicker than mousing around some clustered up feature overloaded GUI.
Re:PostgreSQL vs. MS SQL Server by mmgutz on Thursday April 30, 2015 @10:25AM (#9465227)
Last I tried Navicat it didn't offer much over pgAdmin. The UI was more streamlined but that wasn't reason enough to switch to it. What features in navicat are must have and not found in pgAdmin3?
Re:PostgreSQL vs. MS SQL Server by danneu on Thursday April 30, 2015 @11:25AM (#9465629)
I use both Navicat and pgAdmin3 these days.

One thing I like about pgAdmin3 is the ability to only execute the query you have highlighted and also the scratchpad. It's nice for exploratory querying. In Navicat, I like switching between various tabs where pgAdmin3 makes me switch between windows.

Both have some hilarious idiosyncrasies. When one locks up for no reason, I generally just alt-tab to the other.

Recently I was using pgAdmin3 and set my production database color to red. I happened to notice that the color didn't repaint back to green when I switched to my dev database. And Navicat seems to consistently hang whenever the network dies or burps mid-action, requiring a command-line kill.

Idiosyncrasies. :)

Re:PostgreSQL vs. MS SQL Server by ironchef on Thursday April 30, 2015 @03:28PM (#9467108)
AquaDataStudio was my choice at the time. Expensive, but worked on pretty much all the DBMS I had to use at the time (which included oracle, pg, teradata, mssql, mysql to name a few).