Querious Release Notes

Changes

• Querious should now automatically `quote` all field names which conflict with MySQL keywords when entering them into a table index part list, instead of relying on the user to do this and failing with a beep.
• If an error occurs during SQL exporting because of a MySQL query error, that query is now shown with the error in all cases.
• Querious can save Export settings (see the Export panel). New in this version is a change to the behavior when loading a set of saved settings. If loading settings in an existing connection's Export panel, it'll always use that connection for the export. If opening the "queriousExport" file directly (outside of any connection), it'll open a new connection window to the Saved Connection specified in the queriousExport file it can be found, otherwise it'll show an error. Previously it was more difficult to utilize an export preset on a different connection.
• When connecting Server Access through SSH, it will give a much more detailed reason for why the authentication failed, listing all possible authentication methods, what it tried, and exactly how they failed.
• The querious://connect URL scheme allows using cleare text authentication and specifying the authentication plugin.

Fixes

• Solves a problem when importing from some SQL files where it could complain the file's string encoding was invalid partway through the export.
• Whenever a Database Comparison starts, it ensures that it grabs the current CREATE statement of each schema object. Before if you compared, went back, made changes elsewhere, and then compared again, it would still use CREATE statements from the very first compare.
• Fixed a missing Dark Mode appearance for the Table Indexes column list.
• Fixes a display problem of the NULL/BINARY/etc indicator images in the Table Content when the window moved between Retina and non-Retina screens.
• Database Comparison window title actually fits the text now instead of being cut off.
• With Database Compare, going back and recomparing now shows the correct selection.
• Stability improvements for rare Database Relationships view crashes.
• Long-named fields in the Table Content search would prevent the +/- buttons from being visible to add a second column to search on.
• Importing from a compressed SQL file now correctly shows "Import preview limited to approximately 1 MB" at the end of the preview data as it does with uncompressed files.
• Build 303011 addresses a Dark Mode issue in the registration window of the original build 303010.

New

• The Table Content view now has a vertical/form editor. There are single and dual column layouts, and keyboard navigation (Page Up and Page Down) to cycle between selected rows while maintaining focus in the selected field.
• Table Content searches can now be saved and re-used (across launches), accessible in the first search field's popup menu.
• Database tables can have a default Table Content saved search set, which will be used when the table is first viewed.
• Added an "Add <field> to Search…" menu item to the Table Content view's contextual menu. You can also right-click on a table column for the same.
• The context menu in Table Content now has a menu item for copying all of the values for a given column, each on its own line.
• The context menu in Table Content now has a menu item for copying DISTINCT values for a given column, each on its own line.
• The Table Content view now explicitly supports multi-column sorting. Right-click on a column header to add a second column to the sort. Visual controls are then available.

Changes

• In the Query view, if the cursor is after the query delimiter (;) and there is no query following it on the same line, then that "before" query is now the "current" query and executable. (Before it was considered not within that query and the Run button was disabled.)
• The Table Index Columns view now surrounds MySQL keywords with backticks as a hint to the user that these need to be backticked in the entry field.
• Querious's connection restoration at launch does not depend on the System Preferences —> General —> "Close windows when quitting an app" setting, and instead only depends on the Querious preference.

Fixes

• Set Default Values to NULL on import now behaves as expected.
• Fixes the issue with the Table Content search popup controls having an I-beam cursor instead of an arrow.

Changes

• Addresses an extension of an issue fixed in 3.2.1 (302006) when importing CSV could lead to a crash.

Changes

• Fixes an error where some fields with an empty string value were shown as NULL.
• The Export Settings panel shows an error message if a file password is not entered when exporting passwords, rather than silently keeping the passwords out of the file.
• When clicking outside of the table index columns popover, it now will commit the changes by default instead of cancelling. Pressing Return and Escape will still commit and cancel respectively.
• Stability fixes:
• – when adding a new row, and editing a field value in the popover editor
• – when importing CSV to a new table with NULL default values
• – when closing a connection tab that has a saved query selected in the Query view
• – when deleting a saved query and then closing a connection tab that was viewing that same saved query
• – when quitting Querious
• – when changing the current line color to a non-RGB color

New Features

• Added File —> Settings —> Import/Export Settings, where you can select saved connections, queries, preferences, etc, to be exported into a single encrypted file for easily transferring all settings to a new machine (including connection passwords).
• Adds better autocomplete suggestions when using table aliases. (eg "SELECT * FROM myTable t WHERE t." shows myTable column names)
• Can search for queries within the Saved Queries and Recent Queries list.
• Can drag saved queries to Finder to create SQL files.
• Connections can now be made to remote Unix sockets through an SSH tunnel.
• Table columns in the Table Structure view can be copied and pasted between different tables.
• Can set the "Selected Database" in the Query view back to "None".
• Hex and Binary literals (0x1234 / 0b0101) can be entered into binary columns directly in the Table Content results.
• The Database Comparison window now has a "Settings…" button which lets you go back and change comparison settings.
• Binary columns can be edited as plain Text in the field value editor window. (Interpreted with a specified text encoding.)
• Geometry columns are selected in their native binary form and displayed either as hex or Well-Known Text, according to a new preference.
• There is a new Geometry editor in the field value editor window which will edit geometry columns as Well-Known Text.
• The Table Indexes view now allows typing in "functional key parts" (expressions) when supported by MySQL. You can also specify an index part being ASC or DESC.
• The field-value editing panel can now be set in preferences to be either a popover or a modal sheet requiring explicit clicking of "Apply".
• In the Query view, rows can now be deleted if they come from a single table and contain the table's primary key.

Changes

• When importing CSV and SQL, the SQL_MODE is explicitly set to an initial known state to avoid conflicts with ANSI_QUOTES and NO_AUTO_VALUE_ON_ZERO.
• When duplicating databases and tables, the SQL_MODE is explicitly set to a known state to avoid conflicts with ANSI_QUOTES.
• In Database Comparison, if the "Ignore definer" setting is turned on, the generated script will not have an definer clause for either CREATE or ALTER statements of views, functions, or procedures.

Fixes

• SPATIAL indexes can now be created in the Table Indexes view.
• The Database Content view's list of tables has updated column widths to account for changes on recent OS versions.
• After having changed the value of a non-writable column in the Query view, the previous (real) value is restored instead of looking like it was actually changed.
• After having changed the value of an editable column in the Query view, the row is updated to reflect that new value instead of maintaining the old value.
• Fixed visual issues in the Compare Databases settings window.
• Searching binary columns in the Table Content view works as expected.
• Can no longer incorrectly drag the Quick Connection item in the saved connections list.
• The autocomplete window shows the data type of columns when it can.
• Updates and corrects the appearance of the autocomplete window.
• Addresses sometimes too-narrow columns in the Table Structure view.
• Works around a problem in macOS Big Sur which would sometimes cause a crash after executing a query in the Query view.
• Works around the view definition sometimes being empty in the View Structure view because it is blank in INFORMATION_SCHEMA.VIEWS.
• Fixes a crash when trying to save a data file (CSV/Tab) document.
• Fixes a crash that would occur when trying to load a Function or Procedure's Structure View when the connected user did not have permission.
• Fixes issues with functions/procedures in the database comparison's generated script, where some bits may have had "(null)" in SQL.
• Can rename artificial foreign keys again.
• About Window style fixes on Big Sur and later.

Fixes

• Copying rows as SQL in the Query view doesn't format the SQL incorrectly.
• An error message instead of a crash (in rare cases) now occurs if there's an issue updating a field value in the Query view.
• Fixes a crash when importing a large CSV file, using batches, and a parsing error (because of poor file formatting) occurs.
• Does not allow choosing the source server as the destination server when Duplicating a database, except by choosing "Current Server"

Changes

• Clicking a foreign key jump button the second time after results are loaded doesn't go to the wrong row.
• Trying to change the value of an "unloaded" value works again. (A new error message in 3.1 uncovered a previous issue with this.)
• Fixes an issue where dragging a saved connection to the end of the list would cause it to disappear.
• Selecting the menu item to set a value for multiple rows at a time works again.
• Setting a value to NULL using the contextual menu item in the Table Content view works again.

Changes

• Saved connections can be reordered again.
• Fixed a failure when duplicating a database with ANSI_QUOTES turned on in the server's SQL_MODE.
• Other small fixes.

Changes

• When duplicating a table between servers, generated columns are skipped.
• When exporting to CSV/Tab from Query Results, the "Next" button is no longer incorrectly disabled in some cases.
• Deleting the entire value in the Table Content search field no longer immediately triggers a search.
• The structure view for procedures no longer "cleans up" the parameters string, instead leaving it and all comments intact.
• Exporting or copying query results or table rows to CSV/Tab was not working in 3.1.
• Changing a field value in the Query results view was not working in 3.1.

New Features

• User interface polishing for macOS Big Sur and Monterey.
• When exporting to SQL, you can now specify queries to export the results of, instead of selecting tables etc.
• When exporting to CSV/Tab, you can now specify queries to export the results of, instead of selecting a table.
• Added "Jump to Column…" (in the View menu) to let you jump to a specific column in the selected table content / query results.
• Added a fuzzy matching filter field to the Saved Connections sidebar.
• When editing the value of a field with the value editor popover, there is now an "SQL" tab for entering a raw SQL value expression to set the value to.
• Tab files can be imported into a new table.
• CSV/Tab imports can now use UPDATE statements instead of INSERT or REPLACE (as long as the table has a specified primary key which is included in the file as well).
• Importing CSV/Tab includes an option to ignore "footer" rows which occur after an empty line in the file.
• The Server Users view lets you set privileges on Views.
• The Server Processes view can kill or stop multiple processes at the same time.
• The Server Processes view will run the RDS kill function if the server is identified as RDS.
• Enum/Set fields in the Table Content view autocomplete their values when typing them.
• Table Content columns remember their widths across launches.
• Double-clicking a column divider in the Table Content view will resize the column to its default size.

Changes

• Optimizes the Table Content view loading of foreign keys, which may result in much faster loading.
• The window asking for where to export from (Current Results or the Database) has been redesigned to be easier to use.
• Column selection for CSV/Tab export has some labeling for clarity, and defaults to all columns being included in the file.

Fixes

• If a table doesn't exist when exporting SQL, the error is displayed rather than silently ignored.
• Works around a bug in macOS Big Sur that doesn't update the window titlebar color tinting effect.
• Fixes an issue when trying to make a database a favorite in the main sidebar.

Changes

• Initial release with native support for Apple Silicon.
• Addresses some minor Big Sur user interface issues.
• JSON columns in the Content view can be search for with "contains" and "like"
• Fixes a recent issue where geometry sub-types were being shown only as GEOMETRY in the Columns view.
• When importing CSV/Tab, if an unmapped destination table field has no default value and is also NOT NULL, then Querious tries to pick a reasonable default for the column (ex: 0, empty string).
• Addresses some issues where the choice to ignore errors on import wasn't being respected.

Changes

• Fixes an issue where in some locales, Querious would incorrectly state you needed to renew the license to use an update.
• Fixes an issue in View structure comparison where the resulting ALTER query may have a list of fields which are out of order from those in the SELECT statement.
• The database connection used during importing is ensured to be closed immediately after importing is finished instead of being held until the progress entry is removed.
• Ensures that CSV importing works even if a column header is an empty string.
• Other minor fixes.

Changes

• Added the "New connection" item to the sidebar in the connection view.
• When reconnecting to a server (after the internet connection is lost, for example) you can re-enter the MySQL password if needed.
• Fixes a rare crash when importing into a new table and the CSV file has no column headers.
• Fixes a recent issue with setting the connection encoding.
• Changing the type/length properties of a column with no default value, will leave the default as not set.

Changes

• The list of query result statuses in the Query view now has a tooltip which is the query.
• When exporting SQL queries in the Query view, the file always has an sql extension on it.
• Fixes a crash which would occur for first time users on launch.

Changes

• Includes improvements to knowing about new updates to Querious after the license's upgrade period has elapsed.
• Avoids a crash which could occur when the field has focus for editing the text value next to a checkbox in the Table Content view, and then clicking the checkbox itself.
• Reverses a side effect new to 3.0.6 which would unexpectedly create an 'AuthenticateSSH' log file in some cases.

Changes

• Fixes query/SQL text fields (like in the Query view) being scrolled slightly to the right and wider than it should be.
• When editing a table row, Querious will assign NULL instead of `default` to a field with no entered value when "No Auto Value on Zero" SQL mode is on.
• In the Query view, "Explain" does not use the "EXTENDED" keyword for MySQL 8+ which does not support it.
• The Table Indexes view should show all index types now even if the storage engine is unknown (ex from a MySQL variant).
• Open Quickly has the correct Dark Mode appearance.
• Addressed a scenario in the Query view where connections to the server might increase, so Querious is maintaining a large list of idle connections.
• Fixed SQL syntax errors in Database Comparison's generated synchronization script.
• When importing CSV to the database, if an error occurs and you click "Continue", it doesn't hang on importing the rest of the data.
• Fixes an issue only on Big Sur when trying to rename an item in the left sidebar.
• Fixes a memory leak when importing or exporting.

Changes

• Added a new option in Database Comparison to remove occurrences of the Reference database's name from CREATE statements for added objects.
• Changes the Database comparison's generated script so that views are last, so that tables referenced by views are sure to exist.
• Truncating tables uses a USE statement rather than `db`.`table` so that it preserves replications.
• Fixes some query errors when dropping the primary key or adding a new autoincrement column when there is no primary key.
• The Values list popover for editing enum/set values in the Table Columns view no longer exhibits weird behavior after having deleted an enum value which was being edited
• Changing column types when importing CSV into a new table respects the newly set type.
• Other minor fixes.

Changes

• Fixes table cells in the Table Content view sometimes showing a foreign key jump arrow when they shouldn't, specifically when the selection is a MySQL View.
• Fixes the overlap of a table field value and the Foreign Key jump arrow button in the Table Content view.
• Works around an issue in macOS to expand the drag area for resizing the last table column in the Table Content view, so that it doesn't get superceded by the drag area for resizing the window.
• Fixes the Focus on Database field fuzzy filtering mismatching in some cases.
• Small improvement to the minimum table field cell size in the Table Content view.
• Deleting the database which is currently focused no longer tries to still reload the table previously selected.
• Now includes NO_AUTO_VALUE_ON_ZERO in the SQL_MODE when duplicating a database.
• Fixes the Database Comparison view not respecting the checkboxes for ignoring certain steps when generating the script.
• A number of small visual fixes for Dark Mode.
• Addresses issues in database synchronization script execution.

Changes

• Fixes scrolling/resizing issues in the Database Relationships view when zoomed out.
• The import panel now displays the compression format of the file, and does not let it be changed because it's unnecessary.
• When modifying a saved connection in the connection view, it no longer has the color carry over from the previously-selected saved connection.
• Fixes an issue in the previous version where the Query view's results summary wasn't updated while more queries were executed.
• Fixes a few rare crashes when importing.
• Fixes a rare crash when exporting encounters an error on the server.

Changes

• Fixes database structure comparison having extraneous parenthesis in the SQL for primary keys.
• Fixes an issue resulting in "row 50 not having the correct columns" in the CSV import preview.
• Fixes the final case of NULL indicator being small on non-Retina displays sometimes.
• Fixes the missing Save/Revert buttons for saved queries in the Query view.

Changes

• When exporting SQL, the SQL_MODE is explicitly set to an empty string so that ANSI_QUOTES cannot be applied by the server's settings, which makes the created SQL file usable on servers which do not have ANSI_QUOTES enabled, which is the norm.
• In Database Structure Comparison, the Ignore Table Auto Increment setting is honored.
• In Database Structure Comparison, the Ignore Table Auto Increment and Ignore Table Average Row Length settings are turned on by default.
• Fixes Records Document: Split, Join, and Go To panels not performing the intended action.
• Saved queries in the sidebar have their query start indicators in the line number gutter shown immediately.
• Saved queries in the sidebar have syntax coloring applied immediately.
• The Server Slow Query log only loads the last 20 MB from the file, like it does with the Errors log.
• Fixes the search operators not showing the correct list of available operators depending on the selected column, after having navigated between two different tables.
• Duplicating a row in the Table Content view with unloaded values loads them first so the values are properly duplicated.
• Binary columns which are foreign keys show the foreign key jump button again in the Table Content view.
• When editing a table field in the Table Content view, using the up and down arrows selects the cell in the previous/next row, but now also correctly selects all of the text so it can be edited, instead of having the cursor at the end or beginning of the field with no selection.
• Fixes the NULL indicator in a table value cell having the wrong scale when the window is moved between a Retina and non-Retina screen.
• When editing a table field's value, such as a NULL value, pressing escape doesn't doubly show the NULL indicator and the NULL value as text.
• Fixes a subtle and rare bug in CSV importing which could lead to a mistaken error about incorrect column counts.
• When saving a Records Document, it applies CSV enclosers properly according to the setting (always vs when needed).
• Opens saved connections with the exact same user and host, but having different databases, in separate sessions, so the tabs are named properly (with the separate saved connections' nicknames as expected).
• The Table Indexes view has the index columns list clip to the list's bounds rather than truncates to whatever tokens fit. This is a better indicator that "there's more not being shown".
• Fixes a rare crash when importing SQL.
• Solves a rare slowdown when searching in the Focus on Database field in the sidebar.

Changes

• Renames Source and Target in Database Comparison to Target and Reference for better clarity.
• Added "Add Connection Settings" to the popups in the New Database Comparison setup window.
• Added a confirmation before synchronizing structure in Database Comparison.
• Big performance improvement when scrolling in the Table Content view.
• Big performance improvement when scrolling in the Query view results.

Changes

• 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.
• All import/export/transfer operations, whether they succeed or fail, are shown when they finish.
• Added a new SSH Host option to the export filename template options.
• When duplicating a database, the SQL mode is set to ignore invalid dates so that existing values are duplicated properly.
• Contains fixes for the database comparison's generated synchronization script.
• Fixes a crash which could occur when selecting a value from an enum's popup menu, while the table cell was also focused for text editing.

Changes

• Allows SSH aliases for tunneling, without specifying a username.

Changes

• The primary sidebar icon size can be changed from using the system default (to always using small icons, like Querious 2).
• Fixed a crash when using the querious:// URL scheme.
• Fixed a rare crash when testing a saved connection in the connection settings panel.
• The SQL export option "Include DEFINER clause" applies to triggers.
• Created MySQL events are not immediately deleted by MySQL.

New

• Server Access connections through SSH now support elliptic curve keys.
• Added a button in the Server Access connection settings panel to copy from the SSH Tunnel.

Changes

• In the Server Error Log view, the log is now limited to 20 MB of the end of the file, addressing memory usage when the log is very very large.
• Refresh All also removes all cached table content in the current tab.

Fixes

• Creating a database doesn't result in an error. Broken in the previous beta.
• Modifying sidebar favorites is now synchronized across multiple tabs to the same connection.
• Fixes a crash which would happen when closing a connection tab while it was reconnecting
• Fixes a crash when editing text in the JSON editor.
• Fixes a problem where new/unconnected tabs would show a "Reconnect" button when waking up from sleep. Clicking the button would crash.
• If connecting through SSH fails, it doesn't still continue to try to connect to MySQL. Broken during the beta.
• Connects to the initial database when opening a new connected tab. Broken during the beta.
• Hopefully finally found and got all the edge cases of tabbing between columns the Table Columns view working.

Changes

• Includes changes to many create/drop/insert/update/alter statements to prefer the USE statement to specify the database, allowing the queries to propogate across replicated slaves.
• Adresses an issue introduced in the previous beta when connecting to custom Unix socket files.

Changes

• When the machine awakes from sleep, there is much improved handling of the auto-reconnecting when the network is available.
• Small interface tweaks to the connection settings layout so the choice between TCP vs Unix is more prominent. When using Unix Sockets it will also automatically check for the standard MAMP socket file location when no path is explicitly given.
• For MySQL 8 when the table status is cached (the new default), it now shows the correct auto increment value by ignoring the cached value.
• Using a default value of CURRENT_TIMESTAMP etc for a column imported via CSV works correctly instead of it trying to import the literal string 'CURRENT_TIMESTAMP'.
• Fixes negative numbers being displayed as invalid JSON.
• Potentially addresses an issue leading to the error: "ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password'; Authentication requires secure connection." when connecting to MySQL 8.

Changes

• The Database Relationships graph updates appropriately if tables are modified since the last time it was viewed.
• Right-click and selecting Import… doesn't scroll the sidebar anymore.
• Fixes missing INSERT batching in SQL exports.
• OPTIMIZE results are converted to KB/MB/etc.
• Adresses tabbing behavior in the Table Columns view.

Changes

• Fixes a Dark Mode issue in View Structure.

Changes

• Added a preference for the default string search operator in the Table Content view.
• Open in New Tab correctly selects the right item in the sidebar again.
• Fixes the sometimes-missing import/export progress bar in windows.
• Fixed checkboxes in columns so they don't sometimes randomly show true when the value is NULL.
• You can now specify the authentication plugin used for MySQL in the saved connection settings panel, such as if you have a MySQL 8 server using the MySQL 5 authentication plugin (mysql_native_password).
• When selecting and deleting by word in a query field, the word boundaries should be more syntax appropriate. Ex: when the cursor is after "one.two" and pressing option-delete, it will delete leaving "one.", stopping at the period.
• When an item is to be selected in the sidebar (like when using Open Quickly) it's now scrolled to the top of the sidebar.
• In the Table Structure view, when changing the type of a column using the popup, while at the same time the name is currently being edited, it no longer loses the edited name.
• Shows system notification when import/export ends. For some reason they stopped showing.
• Fixes layout of the Run SQL Script sheet.

Changes

• Prevents the sidebar database "focus" field from opening the popup menu automatically at unwanted times.
• The recently-new "Show value suggestions menu" preference is now on by default.
• The table content fields shows the suggestions menu for enums and sets all the time, and by the preference appropriately for everything else.
• Dark mode fix for Foreign Keys list in the Structure view.
• Applies an earlier fix for the NULL value issue with MariaDB back to 10.2.6+ appropriately instead of just 10.2.27+
• Fixes infinite reloading across multiple tabs open to the same table in the Content view.
• The query is shown if there's an error when creating or updating a user.

Changes

• Avoids a crash in macOS Catalina when the open dialog for imports closes.
• Addresses clipping of characters and words in result lists when multi-line / taller fields are turned on in preferences.
• Avoids an infinite reload of table results when row caching is turned off and multiple tabs are viewing the same table.
• LEFT JOIN and RIGHT JOIN are indented properly when formatting queries.
• Reverts, for now, a prior change for routines' defintion SQL.
• SSL host verification is on by default for security. Can be turned off in Advanced preferences.

Changes

• Works around an issue in MySQL where routine create statements would replace escape characters with literal values
• The Table Structure view doesn't change numeric types to have a 0 default value if they're allowed to be null.
• Supports MySQL 8 syntax for changing password
• If creating a new user fails, the query is shown in the error.
• Changing a value in the Table Structure view and then pressing the Tab key correctly tabs between fields.
• Anything that changes the table cached content (eg, Truncating the table) correctly refreshes the view again.

Changes

• Fixes an issue with Registration.

Changes

• Fixes a crash when trying CSV import.

New

• Added a database "renaming" option in the main sidebar. (Actually duplicates because renaming a database isn't supported by MySQL.)
• Added a preference for how the width of columns is calculated in the Table Content view.
• Spacebar toggles the checkbox of selected rows in the schema object lists during the Export process.

Fixes

• The tab key cycles between columns within tables in the Table Content and Table Structure views appropriately.
• When editing a JSON-typed column, the JSON editor opens in the field value popover now, instead of Text.
• Fixes the User Privileges view, where clicking on the database/table/field-level permissions list was not working correctly.
• Addresses some Dark Mode issues.
• Shows the "NULL" default value suggestion in the Table Structure view where it was logically missing.
• A new Connection window opens at launch again when appropriate.
• Foreign keys popover loads the view and loads properly.
• The option to ignore constraints is enabled when deleting a database.
• When editing a value in the field value popover, when the popover closes, it doesn't try to save the value even if the value did not change.
• A number of stability improvements.

Changes

• Addresses some issues on macOS 10.12 and 10.13.
• The tab key in the Table Content view cycles only through cells in the selected row.
• Improvement in handling of reconnection after the SSH tunnel has been disconnected.

Changes

• Dark mode fixes in the Server view.
• Misc fixes and optimizations.

Changes

• Fixed a crash at launch for some.
• Some dark mode appearance fixes in the Query view.

General

• Requires macOS 10.12
• Added Dark Mode support for 10.14+
• Significant optimizations when multiple tabs are connected to the same server. Less memory is used, less CPU, faster connection for new tabs, reconnection, etc
• Should now support servers with the NO_BACKSLASH_ESCAPES SQL mode turned on.
• 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.
• A number of internal optimizations for stability, consistency, and performance.

Database Structure Comparison

• There is an entirely-new feature to 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.

Connection Window

• Connection color is shown on tabs when active and hovered over.
• Added preference to show connection name and selection in the tab label.
• Added a contextual menu when right-clicking on tabs in the tab bar (Close other Tabs, Move to New Window, etc).
• Shows an error icon next to the transfers button in the window toolbar when there's a failure.

Connection Settings

• Added an option in the connection settings panel for enabling cleartext passwords (needed for some MySQL authentication plugins).
• Adds a new preference to specify a path to mysql plugins used for authentication.
• Adds a preference for whether the host's SSL certificate needs to be identified.

Primary Sidebar

• Tables, Functions, Events, etc can now be grouped into folders according to their type rather than all being in one list.
• Rows are sized according to the system preference for sidebars.
• Items can now be marked as favorites through their contextual (right-click) menu, which sorts them to the top of the list.
• The "focused" database popup at the top of the primary sidebar is now a fuzzy-matching field with a drop-down list. It should be quicker to use.

Table Content

• "Boolean" columns can now display a checkbox. See the preference in Preferences → Results for tinyint and bit columns.
• Adds a [-] remove button to the first/only filter in the Table Content view, making it easy to click that to remove the filter rather than having to select "Show All" from the popup menu.
• Added a new preference for JSON to be edited in the field value panel rather than inline in the table.
• The field value panel is no longer a sheet, but a less obtrusive popover.

Database Relationships

• The relationship graph now optionally shows table columns fields and types, as well as their PK/FK status.
• The relationship graph can now be exported as a PDF.
• The relationship graph has improved and faster layout.

Query View

• Added color themes, including a default one for dark mode. See Preferences.
• Added a preference for whether Querious continues, stops, or asks what to do when an error is encountered while executing multiple queries.
• All-new SQL formatter with more options (stripping comments and indenting). Easily triggered with Cntrl-F.
• Added a new "Minify SQL" formatting option.

Server View

• Can now export the Slow Queries log file.
• Can now export the Server Errors log file.
• The Process list can now hide sleeping connections.
• The Server Errors log view can now show the raw text of the log, particularly if it can't be parsed correctly.

Structure View

• The Primary Key view's popup allows easily creating a new column that will be the autoincremented column.
• The CREATE statement in the View Structure view is now formatted for better readability.

Import

• It is now possible to create a new table directly from a CSV/Tab file being imported.
• When importing CSV, empy column values in the file can instead import as specified default values.
• Importing from compressed gz files is supported.
• 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.

Export

• Added several SQL export options, such as 'Include Definer Clause', Use 'INSERT IGNORE', and 'Use single transaction'.
• SQL exporting has feature equivalence to mysqlpump.
• All exporting can now export directly to compressed gz files.
• Export settings can be saved and loaded through an action menu in the export panel.
• 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.
• When exporting as SQL, views are exported in dependency order so they don't cause problems when the SQL is imported.
• Added a 2-digit year template option for export file names.

Duplication

• Duplication is more reliable due to better handling of dependencies.
• Fixes 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.
• Removes the DEFINER and SQL SECURITY clauses so that duplicating between servers where the user does not exist will work.