Querious Release Notes

Version 3.3.2
October 10, 2022 - Build 303012

Fixes

• Addresses a crash in certain circumstances when editing a table index.

Version 3.3.1
October 2, 2022 - Build 303011

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.

Version 3.3
August 17, 2022 - Build 303000

New! Vertical Form Editor

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.

New! Table Content Saved Searches

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

New! Multi-Column Sorting

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.

New! More Table Content

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

Changes & Fixes

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

Version 3.2.2
June 30, 2022 - Build 302007

Changes

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

Version 3.2.1
June 28, 2022 - Build 302006

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.

Version 3.2
February 24, 2022 - Build 302003

New! Settings Import/Export

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

New! Content View

• Hex and Binary literals (0x1234 / 0b0101) can be entered into binary columns directly in the Table Content results.
• 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 field-value editing panel can now be set in preferences to be either a popover or a modal sheet requiring explicit clicking of "Apply".

New! Query View

• 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.
• Can set the "Selected Database" in the Query view back to "None".
• Rows can now be deleted if they come from a single table and contain the table's primary key.

New! Miscellaneous

• 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.
• 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 Database Comparison window now has a "Settings…" button which lets you go back and change comparison settings without having to start a new session.

Changes

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

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.