Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing DBeaver vs SQLGate, the Slant community recommends DBeaver for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” DBeaver is ranked 1st while SQLGate is ranked 9th. The most important reason people chose DBeaver is:
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Specs
Question Ranking
Pros
Pro Cross-platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Pro Free
It is licensed under GPL v2.
Pro Works for many types of databases
MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source.
Pro Follow foreign key to their primary key
If you have a table with a foreign key you can click on it to see the table row where this key references to.
Pro Formatted text view
It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A.
Pro Easy to use, clean neat inteface
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
Cons
Con Never-ending function errors
Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1).
Con Cannot view function
Con Trigger edition
Until version 3.5.8 you can not edit triggers, only view (since 3.5.6).
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.
