When comparing QueryPie vs SQL Notebook, the Slant community recommends QueryPie for most people. In the question“What are the best SQL Clients for Windows?” QueryPie is ranked 3rd while SQL Notebook is ranked 14th.
Ranked in these QuestionsQuestion Ranking
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~
Not sure about Linux but it works on Windows and Mac just fine!
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.
Free and open source.
Con Requires creating an account
Requiring an account is rare on SQL IDEs...
Con Still in beta
Con No visualization
Con Some queries do not work
Did some tests with PostgreSQL 9.5 and some complicated queries did not work.