Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing SQLGate 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 SQLGate is ranked 9th. The most important reason people chose QueryPie is:
The default color is dark and comfortable for the eyes.
Specs
Question Ranking
Pros
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
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 Logon
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.
Con Requires creating an account
Requiring an account is rare on SQL IDEs...
Con Still in beta
Con No visualization
