Version 4.0.7
October 13, 2023 - Build 400051

New

• Adds a new option to supply the password for a MySQL connection from the result of an external command or shell script. This is particularly useful where the a time-limited password is retrieved from a remote authentication server (ex: AWS IAM).
• The View —> Jump to Column action is now accessible when right-clicking on a the rows lists in the Table Content and Query results views.
• Jump to Column now flashes the column being jumped to so it's even more visible.
• Can create a new SQLite file via the File menu.

Changes

• Previously for all MySQL imports, the connection's SQL_MODE had NO_AUTO_VALUE_ON_ZERO removed if present. Now, this only occurs when importing from CSV/Tab. When importing SQL, the SQL_MODE is left alone at the server's default value to preserve the expectation that you'd have when executing the same queries in the Query view for instance.
• In the Query view, the status of the selected result shows both the time to execute the selected query and all queries.

Fixes

• Fixes the active Key Bindings set chosen in Preferences/Settings not "sticking" the next time Querious was relaunched.
• Fixes an issue where the 2nd+ search popup in the Table Content view might have the incorrect title displayed even though the correct field is selected in the menu.
• Fixes rare crashes, including: when the connection is dropped in the middle of reconnecting, when using an SSH tunnel to connect, when loading a saved export configuration.
• Solves some minor display issues in the Table Content's column sorting popover window.
• Fixes a small issue leading to a small bit of CPU usage in the background after using import or export.

Version 4.0.6
September 7, 2023 - Build 400047

Changes

• Fixes missing geometry types in the Columns view.
• Addresses a change in 4.0.5 which would sometimes cause delays when moving between views in Querious.
• Table Content search addresses a query problem for "is" and "is not" comparisons.
• The Query view's Table Reference sidebar now also shows views.
• Misc fixes and work for stability when encountering rare errors.

Version 4.0.5
August 17, 2023 - Build 400046

Changes

• A new Selected Database selector in the Query view that uses a popover instead of a filterable menu. This improves speed, reliability, and future compatibility because of inconsistencies and changes within macOS.
• Improves query formatting for joins, such as LEFT OUTER JOIN.
• Copying results from the query results table should no longer have issues when table columns are aliased.
• Fixes updating a field value in the Query view results, not showing the new updated row.
• Fixes a syntax error when converting a MySQL table's character set.
• Several fixes for stability when encountering rare errors.

Version 4.0.4
August 3, 2023 - Build 400043

Fixes

• Added menu items to the Editor menu for going to previous/next row group in the Content view. Also configurable keyboard bindings in preferences.
• Fixes an issue importing saved connections from a file where nested folders weren't restored properly.
• Fixes an issue on macOS 11 with the saved connection settings database when upgrading from version 2.x or 3.x of Querious.
• Fixes the Database Content view's "Recount All" button not working for non-MyISAM tables.
• Fixes a crash when a certain kind of error happens when exporting table data due to a memory issue when reporting the error.
• Fixes a crash when viewing the Slow Queries log.

Version 4.0.3
July 5, 2023 - Build 400039

Fixes

• Fixes an issue where items in the primary sidebar may have been missing, particularly after reconnecting.
• Fixes an issue when copying from query results where multiple columns have the same name.
• Addresses a SQL syntax issue in SQL exports for TRUNCATE statements.

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.