Querious Release Notes

Version 3.1August 2, 2021 - Build 301001

📣 UPDATE: This updated build has all 3.1 features and changes. All users of 3.1 build 301000 should update to this version.

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.