The best MySQL tool for macOS
The best MySQL tool for macOS
Since Querious was initially released, there have hundreds of updates adding countless new features and improvements. Here are some of the changes made in Querious 3, if you're looking to upgrade from Querious 2.
The entire Querious UI has been updated to work seamlessly in Dark Mode on macOS Mojave and later.
Significant optimizations when multiple tabs are connected to the same server. Less memory is used, less CPU, faster connection for new tabs, reconnection, etc.
Significant improvement in handling of disconnecting and reconnecting to servers when the internet connection is lost.
Database Structure Comparison
Compare and synchronize database structure. Accessed through File —> New Database Comparison, select a Source and Target database, and a series of SQL statements will be generated that modify Source so that it has Target's structure.
URL-based Connection Integration
Added support for querious://connect/favorite and querious://connect/new to open new connections by clicking a link, allowing some automation integration with other tools. (See documentation in the Help menu.)
Better Replication Support
When executing create/alter/delete/drop/update/insert statements, Querious now prefers
USE `db` and drops use of explicit
`db`.`obj` naming so that these queries support server replication setups better.
Now supports servers with the NO_BACKSLASH_ESCAPES SQL mode turned on.
Added an option in the connection settings panel for enabling cleartext passwords (needed for some MySQL authentication plugins).
MySQL Plugin Path
Added a preference to specify a path to MySQL plugins used for authentication.
Added a preference for whether the host's SSL certificate needs to be verified.
Added an option in the connection settings panel for specifying the authentication plugin.
Changed the connection settings layout so the choice between TCP and Unix Socket is more distinct. Also better avoids an issue when "localhost" and "127.0.0.1" are confused in connection settings.
Group by Object
Tables, Functions, Events, etc can now be grouped into folders according to their type rather than all being in one list.
Customize Row Size
Rows in the primary sidebar can use a small or large size, or can be sized according to the system preference for sidebars.
Items in the primary sidebar can now be marked as favorites through the contextual (right-click) menu, which sorts them to the top of the list.
Colored Connection Tabs
Querious was the first to introduce coloring as a way to distinguish between connected servers. This has been refined and expanded so that the connection color is shown on tabs when active and hovered over.
Window Tab Menu
Added a contextual menu when right-clicking on tabs in the tab bar (Close other Tabs, Move to New Window, etc).
Added an option to "rename" databases in the sidebar. "Renaming" in MySQL requires moving tables to a new database, but this makes that clearer.
The "focused" database popup at the top of the primary sidebar is now a fuzzy-matching field with a drop-down list which is quicker to use.
Connection Tab Labels
Added preference to show connection name and selection in the tab label.
Transfer Error Status
The status view in the window title bar area has a new error indicator button which is more visible if there's an issue when a transfer (import, export, duplicate) fails.
"Boolean" columns can now display a checkbox. See the preference in Preferences → Results for tinyint and bit columns.
Field Value Popover
When editing a value in a column, the field value panel is no longer a sheet, but a less obtrusive resizable popover that's quicker to use.
Easier Show All
Adds a remove button next to the first/only filter in the Table Content view, making it faster to get back to showing all rows.
Copy SELECT SQL
The "Show All"/"Find" button in the Table Content view now has a menu attached to it to copy the equivalent SELECT statement or open the query in the Query View.
Added a new preference for JSON to be edited in the field value panel rather than inline in the table.
Added a preference for the default string search operator in the Table Content view.
Added a preference for how the width of columns is calculated; by title or by data.
See Field Names, Types.
The relationship graph now optionally shows table columns fields and types, as well as their PK/FK status.
Export as PDF
The relationship graph can now be exported as a PDF.
Better, Faster Layout
The relationship graph has improved layout with orthogonal lines and loads faster.
Syntax Color Themes
Added color themes, including a default one for dark mode. See Preferences.
Added a new "Minify SQL" formatting option which removes extra space and comments in the SQL.
New SQL Formatting
All-new SQL formatter with more options (stripping comments and indenting). Easily triggered with Cntrl-F.
Stop/Continue on Errors
Added a preference for whether Querious continues, stops, or asks what to do when an error is encountered while executing multiple queries.
Export Slow Queries
The Slow Queries log file can now be exported to be opened elsewhere.
Easier SSH Settings
Added a button in the Server Access connection settings panel to copy from the SSH Tunnel.
Export Errors Log
The Server Errors log file can now be exported to be opened elsewhere.
See Raw Log Text
The Server Errors log view can now show the raw text of the log, particularly if it can't be parsed correctly.
Hide Sleeping Processes
The Process list can now hide sleeping connections to make it easier to see busy processes.
The Primary Key view's popup allows easily creating a new column that will be the autoincremented column, instead of having to add the column first in the Columns view
Better SQL Formatting
The CREATE statement in the View Structure view is now formatted for better readability.
Save Export Settings
Export settings can be saved and loaded through an action menu in the export panel.
Entire Server Exports
There is a new "Entire Server" option for SQL exporting which allows multiple databases and even users to exported to the same file. This is one way to essentially dump the contents of the entire server at once.
SQL exporting has feature equivalence to the newer mysqlpump utility.
File Name Template
Added a 2-digit year template option for export file names.
Create Table on Import
It is now possible to create a new table directly from a CSV/Tab file being imported.
Import Default Values
When importing CSV, empy column values in the file can instead import as specified default values.
Import from .gz
Importing from compressed gz files is supported.
Export to .gz
All exporting can now export directly to compressed gz files.
Added a fuzzy matching filter field so it's easier to find the items to export.
Handle Import Errors
Added an option for whether Querious continues, stops, or asks what to do when an error is encountered while importing. SQL can ask on any error, while CSV importing can only ask for some. Some errors will still cause the import to fail.
Added several SQL export options, such as 'Include Definer Clause', Use 'INSERT IGNORE', and 'Use single transaction'.
View Dependency Ordering
When exporting as SQL, views are exported in dependency order so they don't cause problems when the SQL is imported.
When exporting SQL, spacebar toggles the checkbox of selected rows, for quicker exporting.
Duplication is more reliable due to better handling of dependencies and faulty SQL where the CREATE VIEW syntax still referenced the old database leading to an error..
Trigger creation is now the last step in duplication so that triggers are not fired when inserting data which lead to issues. One example is a trigger which auto-populates another table from the first table's data, leading to a duplication of data because it was already inserted when copying table data explicitly.
Still More Reliability
Removes the DEFINER and SQL SECURITY clauses so that duplicating between servers where the user does not exist will work.