When comparing Postico vs OmniDB, the Slant community recommends OmniDB for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” OmniDB is ranked 4th while Postico is ranked 9th.
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 Open source and actively developed
Pro PL/pgSQL Debugger
Pro Simple and intuitive interface for everyone.
An easy-to-discover tree panel to classify features/objects on left (with context menus if you don't know what you're doing). Tabs panels for ins and outs on right. That's it.
Pro Web-based, can be run locally or deployed on server
OmniDB is web-based and works similarly to pgAdmin 4. You can run the web server locally or deploy it on a server, and connect to it through a web browser.
Pro Multi-database
Supports PostgreSQL, Oracle, MySQL and MariaDB, with support in the pipeline for Firebird, SQLite, SQL Server and DB2.
Pro OmniDB has 2ndQuadrant as its main sponsor
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.
