Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing SQLGate vs SQL Notebook, the Slant community recommends SQLGate for most people. In the question“What are the best SQL Clients for Windows?” SQLGate is ranked 7th while SQL Notebook is ranked 21st. The most important reason people chose SQLGate is:
Functions; filter, sort and group on grid / Copy, past, sum and statistics functions like excel.
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 Portable version
Pro Cross database queries
Any combination of data sources can be used together in the same SQL query, including cross-file, cross-database, and cross-server queries.
Pro Multi database
Microsoft SQL Server, PostgreSQL, and MySQL.
Pro Free
Free and open source.
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 Some queries do not work
Did some tests with PostgreSQL 9.5 and some complicated queries did not work.
