Querious Release Notes

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. All reported issues with 3.1 have been fixed.

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.