When comparing OmniDB vs SQLGate, 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 SQLGate is ranked 9th.
Ranked in these QuestionsQuestion Ranking
Pro Open source and actively developed
Pro PL/pgSQL Debugger
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.
Supports PostgreSQL, Oracle, MySQL and MariaDB, with support in the pipeline for Firebird, SQLite, SQL Server and DB2.
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 OmniDB has 2ndQuadrant as its main sponsor
Pro Quick data analysis
Functions; filter, sort and group on grid / Copy, past, sum and statistics functions like excel.
Pro Saves time with autocomplete & template functions
Pro Fast processing and easy customization
They put out weekly updates, so there are new and impressive functions being added pretty consistently.
Pro Supports cloud-based DB such as AWS & Azure
Pro Includes PL/SQL editor and debugger
Pro ER diagrams
Entity Relationship database diagrams limitations are: only supports reverse engineering, and can not export to formats other than .erd
The logon process after starting up the application is rather long winded (tested with PostgreSQL, no defaults shown for e.g. port number).
Con Free version is limited
e.g. only 10 tables allowed in ERD designer.