Querious icon

Querious 3

The best MySQL tool for macOS

New Features and Improvements in Querious 3

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.

General

Dark Mode

The entire Querious UI has been updated to work seamlessly in Dark Mode on macOS Mojave and later.

Optimized Connections

Significant optimizations when multiple tabs are connected to the same server. Less memory is used, less CPU, faster connection for new tabs, reconnection, etc.

Reconnection

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.

Compatibility

Now supports servers with the NO_BACKSLASH_ESCAPES SQL mode turned on.

Connection Settings

Cleartext Authentication

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.

SSL Certificate

Added a preference for whether the host's SSL certificate needs to be verified.

Authentication Plugin

Added an option in the connection settings panel for specifying the authentication plugin.

Better Clarity

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.

Connection Window and Sidebar

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.

Favorite Objects

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).

Rename Databases

Added an option to "rename" databases in the sidebar. "Renaming" in MySQL requires moving tables to a new database, but this makes that clearer.

Better Focusing

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.

Table Content

Checkboxes

"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.

JSON

Added a new preference for JSON to be edited in the field value panel rather than inline in the table.

Search Operator

Added a preference for the default string search operator in the Table Content view.

Column Widths

Added a preference for how the width of columns is calculated; by title or by data.

Database Relationships

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.

Query View

Syntax Color Themes

Added color themes, including a default one for dark mode. See Preferences.

Minify SQL

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.

Server View

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.

Structure View

Easier Autoincrement

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.

Import & Export

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.

mysqlpump Equivalence

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.

Object Filtering

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.

New Options

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.

Spacebar

When exporting SQL, spacebar toggles the checkbox of selected rows, for quicker exporting.

Duplication

Improved Reliability

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..

More Reliability

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.