Querious Release Notes

Version 3.1.4October 11, 2021 - Build 301010

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"

Version 3.1.3August 18, 2021 - Build 301008

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.

Version 3.1.2August 9, 2021 - Build 301006

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.

Version 3.1.1August 5, 2021 - Build 301005

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.

Version 3.1August 2, 2021 - Build 301001

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.