When comparing Postico vs QueryPie, the Slant community recommends QueryPie for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” QueryPie is ranked 7th while Postico is ranked 10th. The most important reason people chose QueryPie is:
The default color is dark and comfortable for the eyes.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Native experience and clean user interface
Postico is a native OS X app which is available through Mac App Store. The UI is fast, responsive and integrates seamlessly with the OS.
Pro Created by an experienced developer in the field
Postico is the successor of PG Commander, an older Mac Posgres GUI tool which is also widely used. They are both maintained by the same person.
Pro Clean and pretty UI/UX
The default color is dark and comfortable for the eyes.
Pro Multiple Query Tabs!
The multi-tab and multi-SQL-runs are great. It's always good to be able to compare results in one window instead of having to go through and re-run stuff.
Pro Fast Auto-complete
Pro Multiple Databases
They only support 2 at the moment (MySQL and MariaDB) but their social site says they'll be updating with more DBMSes in the near future which is pretty nice because I hate learning new GUIs~
Pro Cross-Platform
Not sure about Linux but it works on Windows and Mac just fine!
Pro Free!
Cons
Con No multiple query tabs in the free trial version
To be fair, multiple windows / tabs IS a feature. It's just part of the paid version.
Con Commercial
Postico is a commercial app, with a one-time fee of $35. There is a free trial available.
Con Requires creating an account
Requiring an account is rare on SQL IDEs...
Con Still in beta
Con No visualization
