Version 4.0.2
June 26, 2023 - Build 400031

Fixes

• Fixes an issue where items in the primary sidebar may have been missing, particularly after reconnecting.
• When selecting and deleting all of the visible rows in the Table Content view, the list of rows may have redrawn in such a way that it appears the rows were not actually deleted.
• Fixes the "Duplicate" button in the Duplicate Schema Object sheet not being initially enabled after changing to copying to another server.
• Fixes a potential for an error when when copying the result rows of a query in the Query view.
• Fixes an issue restoring a custom (non-saved) Querious 3 connection inside of Querious 4.
• Fixes an issue where the create and update syntax for table indexes may have incorrectly specified the index was invisible.
• A number of small changes for stability improvements and other minor issues.

Version 4.0.1
June 20, 2023 - Build 400026

Fixes

• Fixes the Server Access settings view not accepting settings changes.
• Fixes an issue which would prevent connecting to a remote MySQL server by Unix socket forwarded through an SSH tunnel.
• Fixes a crash that could occur when exporting/transferring data and closing windows.
• Addresses an inconsistency in displaying Foreign Key jump buttons (the arrows) in the Table Content view when using Back/Forward navigation.
• Fixes a crash that could occur when right-clicking on an Unloaded column in the table content vertical editor.
• Fixes an an issue where copying rows as SQL would have NULL values for Unloaded blob columns instead of having loaded the actual value first.

New! Querious 4.0

June 11, 2023 - Build 400019

New! General, Appearance, Preferences

• Requires macOS 11 or later
• Refreshed user-interface appearance, matching current macOS interface expectations. New window toolbar and primary sidebar appearance, with many little refinements all over.
• All new Preferences/Settings window appearance and refined organization for easier discovery of various settings.
• New preferences for main sidebar icon/row sizes, light/dark mode appearance behavior, and for hiding internal MySQL databases (mysql, information_schema).
• New customizable key bindings / keyboard shortcuts for menu items in the menu bar. Key binding sets can be transferred between devices.
• Added menu items for Previous/Next Editor, which switches between main subviews. (ex: Table Columns, Keys, Info, and also switches between query tabs in the Query view)

New! Content View

• Added "Conditional Highlighting" to the Table Content view properties. This allows you to color an individual field's or the entire row's text or background based on the values of the data.
• Table Content search conditions now each have a checkbox so they can individually be temporarily disabled.
• Table Content search popup now lets use use fuzzy text filtering to quickly find the field you want to add a condition for.
• The JSON field value panel allows choosing between single and multiline JSON formatting, as may be required for data destinations.
• Adds a new Row Spacing preference for result lists to be Compact (squeeze in more data) or Expanded (a bit more relaxed on the eyes).
• Added a Copy Value menu item to the contextual menu in the Table Content and Query views.
• Much faster setting of the value of a particular column among multiple rows at the same time when the table uses a single column primary key.
• When copying rows from the Table Content or Query views, you can now choose which columns will be copied.
• The Procedure Content view has a different layout for entering the procedure's parameters, including more room, a placeholder hint for the procedure's parameters, and syntax coloring.

New! Query View

• Querious now has much smarter context-sensitive MySQL autocomplete.
• Autocomplete is now fully asynchronous, so it doesn't ever slow down typing, and uses fuzzy completion for faster/more efficient selection of the term to autocomplete.
• The autocomplete suggestions window has a new appearance and shows more information like routine parameters and return type.
• A new preference allows for disabling autocomplete inside of comments.
• The Query view Select Database popup now lets use use fuzzy text filtering to quickly find the database you want to select.
• The Query view result list shows the number of queries that remain to be executed.
• Tweaks the behavior of the text selection navigation when pressing Option-[Left/Right Arrow] to be a little more "SQL-friendly" by stopping at a few more (logical) boundaries between syntax elements.
• The Query view sidebar filtering now also searches the query itself. The name is searched fuzzily but the query contents must contain the exact filter string.
• Recent queries have a longer chunk of the query used for the name. 60 characters instead of 25.

New! Structure View

• Table Columns allows changing the character set and collation of multiple columns simultaneously.
• Table Columns allows changing the character set and collation of columns to the table default rather than their own.
• When choosing a different table collation in the Table Info view, you can choose to change only table's default collation (for fields which do not specify an explicit collation), or to also convert all existing fields to use this new collation.
• The columns list popover when editing a Table Index now has query syntax coloring and autocomplete of the column names. As a reminder, this list is an SQL phrase (not just a simple list of fields) as MySQL supports expressions within this list.
• The Routine Structure view has a new layout which cleans up how parameters are shown and edited, making it much easier to work with.
• Newly-added columns in the Table Columns view that have the same character set and collation as the table, now will use the table-level values, instead of creating field-level equivalent values.

New! Database Structure Comparison

• You can now save and reload database comparison presets to make it much faster to perform the same comparison again and again, as is common between a development and production server.
• A new "Swap" button enables swapping the Target and Reference in the database comparison setup.
• The "Compare Database…" menu item in the primary sidebar in the Content or Structures views will now actually select that database in the comparison setup now, making it more efficient to set up.

New! Database Relationship View

• The Database Relationship view now as an all-new appearance. It now also defaults to showing only tables with primary/foreign-key relationships, and only the PK/FK fields, for a much clearer organization.
• Double-clicking on a table in the Database Relationship view will focus on tables directly related to it.
• The contextual menu when right-clicking on a table in the Database Relationship view offers a "Go to…" menu item which will jump to that table in the Table Content view.

New! Miscellaneous

• Adds a new option in MySQL exporting of SQL for preserving the SQL_MODE for CREATE statements of triggers, routines, and events.
• Exported SQL files no longer include a query to set the SQL_MODE to any value. Without the file executing this statement, then upon import in Querious, the SQL is executed with the default SQL_MODE of the server itself. This overall behavior ensures that, for example, imported triggers are created with the server's default SQL_MODE value.
• Adds a Copy Name menu item to the primary sidebar's contextual menu.
• Can right-click on a selection of multiple schema objects in the left sidebar and select to open them in new tabs/windows. (Previously only one at a time was supported.)
• The Records Document filter conditions now each have a checkbox so they can individually be temporarily disabled.
• SQL Documents now have a popup for changing the SQL variant. Currently the choices are MySQL and SQLite.

New! Experimental SQLite Support

Querious now has early support for working with SQLite databases. While the current SQLite functionality is intended to be fully functional (though does not support some Querious features such as Duplication and Database Structure Comparison), it is considered "experimental." This support can be enabled in Querious's SQLite preferences panel.

Fixes

• Adds missing "New Event" menu item to the Connection menu in the menu bar.
• Uses macOS file coordination to avoid any issue where Dropbox, Google Drive, etc could corrupt the saved Connection Settings file (an SQLite database).
• Loads any unloaded field values first before copying rows from the Table Content view.
• Copying rows as SQL (in Table Content or the Query view) does not include MySQL generated columns.
• Fixes the Table Content row limit field in the table properties popover not actually applying changes.
• Fixes an issue where Database Structure Comparison could leave some SQL with a stray period when database names were removed from the SQL.
• Fixes an issue in Database Structure Comparison where it was incorrectly including the INVISIBLE keyword for some tables in the generated SQL.
• Numerous improvements for stability and minor issues.