Querious Release Notes

Changes:

• Added a connection option in the saved connection settings panel for enabling clear text authentication.
• Works around a bug in macOS Mojave which causes the text view in the Query view to be too wide and scrolled to the right.
• Fixes mistakenly identifying certain columns as being gnereated when connected to MySQL 8, which could result in timestamp fields missing in exports.
• Addresses a change in MariaDB 10.2.27+ which would cause Querious to quote some default values (eg NULL) in the Table Structure view.
• Copying rows as SQL will properly use REPLACE INTO if chosen.
• Fixes the Nickname filename template token from always being disabled in the export panel.
• Fixes the Table Structure view from ending focus in the Generated Column Expression field when typing into it.
• Improves query highlight accuracy in the Query view when selecting a result.
• When reconnecting, if an SSH error occurs, the SSH log should be available for review.
• The Table Content view won't show the same error multiple times when a new row to be inserted causes an error.

Changes:

• Allows the connection to use SSL without specifying any other SSL options. If SSL is selected in the connection settings, SSL will be required
• Addresses a performance issue when using connection settings folders.
• A few visual fixes for Mojave.
• Fixes a potential crash when loading the Query view in Mojave.
• The Table Structure view allows entering a full function call as the default value, such as CURRENT_TIMESTAMP(6)

Changes:

• Fixes an issue with SSH tunnel CPU usage on Mojave for real this time.
• A few stability improvements, including for Mojave.

Changes:

• The Table Content, Function/Routine Content, and Query views better size the columns in the results tables to fit the available area when possible.
• The Database Content view reapplies sorting by row count if necessary as the table rows are recounted.
• General stability improvements, including for Mojave.

Changes:

• Addresses an issue with high CPU usage after having made a connection through an SSH tunnel on macOS Mojave.

Changes:

• Addresses a recent issue in the Query view where cancelling a query could lead to a hang.
• Optimize Table correctly closes the waiting panel and shows the error if the connection times out, like all other operations do.
• The Server Error Log can parse RFC 3339 dates which addresses an empty-looking log.
• Improvements for MySQL 8 geometry type display.
• Fixes some rare crashes.

Changes:

• Connection compatibility with both MySQL 5 and MySQL 8.
• The Connection Timeout preference applies to the SSH tunnel connection timeout too.
• Optimizes "Open Quickly" so it returns relevant results more quickly for "database.xyz" type searches.
• Fixed a problem preventing correct updating of values in read-write Views.

New:

• Can now view any text field value as JSON in the field value panel.

Changes:

• When clicking Refresh in the left side primary sidebar, it now reloads tables etc when the sidebar is focused on one database.
• Fixes a problem where duplicating a database could fail because of an object name error.
• Fixes the Server Variables view not being able to set certain values because of a type conflict.
• Fixes a few chopped-off buttons in High Sierra.

New:

• Addresses connection authentication issues when using atypical authentication plugins, and with MySQL 8.
• Table Info has the ability to set the table charset/collation to the database's default whatever it is.

Changes:

• Updated JSON formatting in the field value panel so it doesn't end up with odd-looking floating point numbers.
• MySQL doesn't change the default table encoding as expected when using CONVERT if the table has no textual columns. Querious now makes sure it does.
• Fixes text selection from being reset in the comments view for Table Columns when typing.
• Dramatically improves window resizing speed in many places (for example when in the Users view).
• Improves user column-level privilege loading in the Users view.

Changes:

• Fixes a problem where Querious appeared to "forget" passwords saved in Keychain.
• Fixes a recent bug in the Table Structure Triggers view where triggers weren't shown.

New:

• If your MySQL password expires, Querious will now let you reset the password before continuing instead of simply cancelling the connection with an error.
• Added Table Content —> View Options panel which lets you specify per-table default sort order and row limit, in addition to hiding specific columns (which was available before). This is accessible through the action menu below the table rows.
• Querious should now be able to use SSH aliases for the SSH tunnel when connecting to a server. Previously the aliases only would work if you also specified the username instead of just the alias host. Please send feedback if there's a case that does not work for you.

Fixes:

• Fixes a crash which could occur when deleting a table, and later using the Go Back navigation command to go back to that deleted table's content view. (If you ever experienced a crash during navigation, this is almost certainly why.)
• Fixes Slow Query Log queries appearing as binary when connected to a MySQL 5.7.x server using the table as the source.
• Fixed an issue where exporting SQL could not include certain selected items.
• Fixes potentially missing delimiters in SQL exports around event CREATE statements.
• Fixes an issue where updateable (read/write) MySQL views weren't letting value changes propogate back into the table.
• Fixes double-prompting of saving for primary key changes when switching to another view without saving.
• Fixes broken connection view layout which occurred only on OS X 10.10.
• A few difficult-to-pin-down crashes were finally found and fixed. Overall they were rare, but they were the most common crashes experienced in Querious, so this greatly moves Querious towards being even more rock solid.

Changes:

• Querious now prefers utf8mb4 connection encoding when supported so that all Unicode text (including emoji for example) is handled properly. This is still a preference.
• The Add Table panel now has popups for choosing the encoding and collation like the Add Database panel does. It defaults to whatever the database's charset and collation are.
• Fixes line-wrapped text in the Query view possibly being outside the entire bounds of the text view.
• Fixes a bug in the Table Structure Columns view where changing the charset/collation of a field might refuse to change.

Changes:

• Fixes an issue only on OS X 10.10 and 10.11 where the interface would feel very sluggish, particularly in the Query view.
• Fixes a problem with missing relationships in the Database Relationships view
• SSL file paths now expand the tilde in the path if present.
• Enables a MySQL client connection option to allow LOAD DATA LOCAL.
• Removes double enclosing of table names in the LOCK TABLES statement when using Duplicate.
• Optimizes query syntax coloring.

Changes:

• Memory and performance improvements related to autocomplete suggestions.
• Eliminates a case where changing a 'decimal' column to another type may end up producing an invalid ALTER statement.
• Removes double enclosing of primary key column names in the Table Keys editor.

New:

• SSL connections to a server can now be tunneled through SSH.
• Added a preference so binary columns can be interpreted and displayed as ASCII text.
• Added Export and Import Saved Queries menu items to the "Saved Queries" menu in the Query view.
• Added a new per-connection Background Tasks list. Imports and Exports now show in this list, which appears as a popover, available by clicking on the same button as before in the status area in the window toolbar as was used to display the Imports and Exports window.
• Table Operations (flush, check, analyze, optimize, repair) now all show an indeterminate progress sheet rather than blocking and spinning the cursor while the operation takes place. If the option to "Stop Waiting" is chosen, the tasks now appear in the connection's Background Tasks list.
• The confirmation panels for editing table rows, removing keys, indexes, triggers, etc now show the query that would be performed.
• The Table Columns and Indexes & Keys views now do background loading of data and saving of changes and a progress indicator is shown. These processes are also interruptable; For example, when making changes to indexes on a large table, you no longer have to wait for it to be done, and can instead navigate elsewhere.
• Added Table Operations menu to the contextual menu in Table Status view.
• Added Cmd-R to trigger the "Reconnect" button (Return was already the shortcut)
• The "Visible Columns" popover in the Table Content view has an "uncheck all" button if the table has a primary key. (All fields but the primary key are unchecked.)
• Added more contextual menu items in the Table Content view (Show Columns, Refresh, Import/Export, etc)
• Added "Focus on Database" menu item in primary sidebar in the Content and Structure views when right-clicking on a database.
• Added an expanded text view for Routine structure parameters since the params may not fit in the single-line text field.
• In the Table Content view, the filter controls can now always be selected with keyboard focus. Cmd-Shift-F moves focus to the first popup.
• Added "Use REPLACE instead of INSERT" and "Include TRUNCTATE before table data" options for SQL exports.
• In the Query editor, when in certain SELECT ... FROM contexts, it'll now suggest all database names too, not just all tables and all views, when there is no db selected.
• Query view autocomplete recognizes "db.table.<cursor>" better and suggests items in that table.

Changes:

• Significantly optimized the indexing of database, table, column, etc names for use in autocomplete suggestions in the Query view. These results are also saved between various of Querious to reduce how often they must be indexed. This internal list can be rebuilt manually if needed using the "Rebuild Index" menu item in the "Connection" menu.
• If there's an import or export error, and the query or log text is longer than 5 KB, Querious now writes the error to a file on the Desktop, because loading the large query into Querious was taking too long to do the text layout in the alert sheet. This is a temporary workaround for that until the performance issue in the Querious UI can be solved appropriately.
• If setting the password of a user produces a MySQL error, the query is included in the error message alert
• Miscellaneous performance optimizations in the interface.

Fixes:

• The Server Access SSH key file is now remembered.
• Resolved an issue where you might have needed to manually specify the cipher list when connecting to some servers.
• Fixes an issue where if a table had a filter applied with rows showing, and then you modified the table structure, going back to the filtered table results would show all rows instead of the correct filtered ones.
• When exporting rows from the Query view using "Current Results," it'll no longer sometimes fail with an error saying the rows can't be found in the database.
• Using "Query Formatting —> Format" in the contextual menu of the editor on queries in the Query view containing non-ASCII characters now works appropriately.
• Fixes an issue where removing autoincrement from a column was failing because it was incorrectly modifying the "Not Null" property.
• Fixes CSV files not importing if the last row's final column has a blank record.
• Duplicating a table, with JSON columns in it, between servers now will not result in a query syntax error.
• The CREATE statement for exported views correctly does not include the explicit `databaseName`. when preceded by a left parens.
• Fixes an issue when modifying the first column's name in the Table Structure view.
• Fixed an issue in Table Columns Structure if a set or enum's default value is NULL and clicking on the pulldown to choose a different value.
• The combo box cells in the Table Columns Structure view draw properly (working around a macOS bug) when the system is using the Graphite appearance.
• Closing a window tab with unsaved changes works properly again.
• If Querious encounters a file permissions error when writing Saved Queries to disk, and error message is now dislayed.
• Many miscellaneous fixes for memory performance and stability improvements.

New:

• SSL connections to a server can now be tunneled through SSH.

Fixes:

• Fixes a behavior introduced in beta 6 where the database indexer sometimes created a large number of connections, leading to MySQL errors.

New:

• Added a new per-connection Background Tasks list. Imports and Exports now show in this list, which appears as a popover, available by clicking on the same button as before in the status area in the window toolbar as was used to display the Imports and Exports window.
• Table Operations (flush, check, analyze, optimize, repair) now all show an indeterminate progress sheet rather than blocking and spinning the cursor while the operation takes place. If the option to "Stop Waiting" is chosen, the tasks now appear in the connection's Background Tasks list.
• In the Table Content view, the filter controls can now always be selected with keyboard focus. Cmd-Shift-F moves focus to the first popup.
• Added a preference so binary columns can be interpreted and displayed as ASCII text.
• Added "Use REPLACE instead of INSERT" and "Include TRUNCTATE before table data" options for SQL exports.
• The results of Querious indexing the database (saving database, table, column, etc names) for autocompletion are now saved across launches. This internal list can be rebuilt manually if needed using the "Rebuild Index" menu item in the "Connection" menu.
• Optimized the indexer fetching of column names.
• In the Query editor, when in certain SELECT ... FROM contexts, it'll now suggest all database names too, not just all tables and all views, when there is no db selected.
• Query view autocomplete recognizes "db.table.<cursor>" better and suggests items in that table.

Fixes:

• Duplicating a table, with JSON columns in it, between servers now will not result in a query syntax error.
• The CREATE statement for exported views correctly does not include the explicit `databaseName`. when preceded by a left parens.
• If Querious encounters a file permissions error when writing Saved Queries to disk, and error message is now dislayed.
• Fixing crash caused by malformed NSLocalizedStringf when a connections database with too new of a version is opened.
• The combo box cells in the Table Columns Structure view draw properly (working around a macOS bug) when the system is using the Graphite appearance.
• Fixed an issue in Table Columns Structure if a set or enum's default value is NULL and clicking on the pulldown to choose a different value.
• When exporting rows from the Query view using "current results," it'll no longer sometimes fail with an error saying the rows can't be found in the database.
• Misc fixes for rare stability problems.

Fixes:

• Closing a window tab with unsaved changes works properly again.
• Miscellaneous stability improvements, including fixing a recent crash when doing imports or exports.

Fixes:

• Resolved an issue from beta 3 which could often cause a crash when doing imports or exports.

New:

• The "Visible Columns" popover in the Table Content view has an "uncheck all" button if the table has a primary key. (All fields but the primary key are unchecked.)
• Added more contextual menu items in the Table Content view (Show Columns, Refresh, Import/Export, etc)
• Added "Focus on Database" menu item in primary sidebar in the Content and Structure views when right-clicking on a database.
• Added an expanded text view for Routine structure parameters since the params may not fit in the single-line text field.

Changes:

• Performance optimization avoid reloading the current view when no row selected in the sidebar but a database is focused, and Querious learns of new tables in the database.
• If setting the password of a user produces a MySQL error, the query is included in the error message alert

Fixes:

• Fixes CSV files not importing if the last row's final column has a blank record.
• Fixes an issue when modifying the first column's name in the Table Structure view.
• The Server Access SSH key file is now remembered.
• Many small leaks and small stability improvements.

Fixes:

• Resolved an issue from beta 1 where connecting to some servers might yield an SSL error claiming it was required.

New:

• Added Export and Import Saved Queries menu items to the "Saved Queries" menu in the Query view.
• The confirmation panels for editing table rows, removing keys, indexes, triggers, etc now show the query as well.
• The Table Columns and Indexes & Keys views now do background loading of data and saving of changes and a progress indicator is shown. These processes are also interruptable; For example, when making changes to indexes on a large table, you no longer have to wait for it to be done, and can instead navigate elsewhere.
• Added Table Operations menu to the contextual menu in Table Status view.
• Added Cmd-R to trigger the "Reconnect" button (Return was already the shortcut)
• The "Visible Columns Popover" has an "uncheck all" button if the table has a primary key. (All fields but the primary key are unchecked.)
• Added more contextual menu items in the Table Content view (Show Columns, Refresh, Import/Export, etc)

Changes:

• If there's an import or export error, and the query or log text is longer than 5 KB, Querious now writes the error to a file on the Desktop, because loading the large query into Querious was taking too long to do the text layout in the alert sheet. This is a temporary workaround for that until the performance issue in the Querious UI can be solved appropriately.

Fixes:

• Fixes an issue where if a table had a filter applied with rows showing, and then you modified the table structure, going back to the filtered table results would show all rows instead of the correct filtered ones.
• Formatting SQL queries containing non-ascii characters now works appropriately.
• Fixes an issue where removing autoincrement from a column was failing because it was incorrectly modifying the "Not Null" property.
• Resolved an issue where you might have needed to manually specify the cipher list when connecting to some servers.

Fixes:

• Fixes authentication of SSH tunnels where the SSH key is password-protected. It seems some recent changes in macOS Sierra affected this.
• Fixes an issue where using the MySQL Host value of "localhost" when you should be using "127.0.0.1" could end up connecting by Unix socket in certain cases.
• Works around a bug in macOS Sierra where the Find Bar in the query editing text views would be cut off.
• Disables macOS Sierra's automatically-added extra tabbed-window mode menu item since it was non-functional anyway.
• Slightly offsetting icons in saved connections list so they look better when there are no folders.

🎈🎉 Querious 2 is now officially released, no longer in beta! 🎉🎈

Fixes:

• Fixes a crash when trying to set the SSH key in the Server Access settings in the Server view.