(Some of) What's New in Querious 4
New! Experimental SQLite Support
Major under-the-hood work has been done to potentially support select database systems beyond MySQL, while still retaining all of the character and great interface Querious is known for, and not sacrificing the existing specificity for MySQL. To this end, Querious currently has support for working with SQLite databases. While the current SQLite functionality is intended to be fully functional (though does not some Querious features such as Duplication and Database Structure Comparison), it is considered "experimental." Please please send feedback regarding any concerns or issues you discover to firstname.lastname@example.org
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)
- 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.)
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).
- When copying rows from the Table Content or Query views, you can now choose which columns will be copied.
- Added a Copy Value menu item to the contextual menu in the Table Content and Query views.
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 sidebar filtering now also searches the query itself. The name is searched fuzzily but the query contents must contain the exact filter string.
- 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.
- Some of the menu items in the action menus of the sidebar in the Query view (New Tab, Close, Save) can now have customizable keyboard shortcuts.
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.
- 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.
- Adds a new option in MySQL exporting of SQL for preserving the SQL_MODE for CREATE statements of triggers, routines, and events.
(Some of) What's New in Querious 3.3
New! Vertical Form Editor
The Table Content view now has a vertical/form editor. There are single and dual column layouts, and keyboard navigation (Page Up and Page Down) to cycle between selected rows while maintaining focus in the selected field.
New! Table Content Saved Searches
- Table Content searches can now be saved and re-used (across launches), accessible in the first search field's popup menu.
- Database tables can have a default Table Content saved search set, which will be used when the table is first viewed.
- Added an "Add <field> to Search…" menu item to the Table Content view's contextual menu. You can also right-click on a table column for the same.
New! Multi-Column Sorting
The Table Content view now explicitly supports multi-column sorting. Right-click on a column header to add a second column to the sort. Visual controls are then available.
New! More Table Content
- The context menu in Table Content now has a menu item for copying all of the values for a given column, each on its own line.
- The context menu in Table Content now has a menu item for copying DISTINCT values for a given column, each on its own line.
(Some of) What's New in Querious 3.2
New! Settings Import/Export
Added File —> Settings —> Import/Export Settings, where you can select saved connections, queries, preferences, etc, to be exported into a single encrypted file for easily transferring all settings to a new machine (including connection passwords).
New! Content View
- Hex and Binary literals (0x1234 / 0b0101) can be entered into binary columns directly in the Table Content results.
- Binary columns can be edited as plain Text in the field value editor window. (Interpreted with a specified text encoding.)
- Geometry columns are selected in their native binary form and displayed either as hex or Well-Known Text, according to a new preference.
- There is a new Geometry editor in the field value editor window which will edit geometry columns as Well-Known Text.
- The field-value editing panel can now be set in preferences to be either a popover or a modal sheet requiring explicit clicking of "Apply".
New! Query View
- Adds better autocomplete suggestions when using table aliases. (eg "SELECT * FROM myTable t WHERE t." shows myTable column names)
- Can search for queries within the Saved Queries and Recent Queries list.
- Can drag saved queries to Finder to create SQL files.
- Can set the "Selected Database" in the Query view back to "None".
- Rows can now be deleted if they come from a single table and contain the table's primary key.
- Connections can now be made to remote Unix sockets through an SSH tunnel.
- Table columns in the Table Structure view can be copied and pasted between different tables.
- The Table Indexes view now allows typing in "functional key parts" (expressions) when supported by MySQL. You can also specify an index part being ASC or DESC.
- The Database Comparison window now has a "Settings…" button which lets you go back and change comparison settings without having to start a new session.
(Some of) What's New in Querious 3.1
- User interface polishing for macOS Big Sur and Monterey.
- Added a fuzzy matching filter field to the Saved Connections sidebar.
New! Importing and Exporting
- 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.
- 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.
New! Table Content
- 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.
- Added "Jump to Column…" (in the View menu) to let you jump to a specific column in the selected table content / query results.
- 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.
New! Server View
- 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.
(Some of) What's New in Querious 3
- Requires macOS 10.12
- Added Dark Mode support for 10.14+
- Significant optimizations when multiple tabs are connected to the same server. Less memory is used, less CPU, faster connection for new tabs, reconnection, etc
- Should now support servers with the NO_BACKSLASH_ESCAPES SQL mode turned on.
- Added support for querious://connect/favorite and querious://connect/new to open new connections by clicking a link, allowing some automation integration with other tools.
- A number of internal optimizations for stability, consistency, and performance.
New! Database Structure Comparison
- There is an entirely-new feature to compare and synchronize database structure. Accessed through File —> New Database Comparison, select a Source and Target database, and a series of SQL statements will be generated that modify Source so that it has Target's structure.
New! Connection Window
- Connection color is shown on tabs when active and hovered over.
- Added preference to show connection name and selection in the tab label.
- Added a contextual menu when right-clicking on tabs in the tab bar (Close other Tabs, Move to New Window, etc).
- Shows an error icon next to the transfers button in the window toolbar when there's a failure.
New! Connection Settings
- Added an option in the connection settings panel for enabling cleartext passwords (needed for some MySQL authentication plugins).
- Adds a new preference to specify a path to mysql plugins used for authentication.
- Adds a preference for whether the host's SSL certificate needs to be identified.
New! Primary Sidebar
- Tables, Functions, Events, etc can now be grouped into folders according to their type rather than all being in one list.
- Rows are sized according to the system preference for sidebars.
- Items can now be marked as favorites through their contextual (right-click) menu, which sorts them to the top of the list.
- The "focused" database popup at the top of the primary sidebar is now a fuzzy-matching field with a drop-down list. It should be quicker to use.
New! Table Content
- "Boolean" columns can now display a checkbox. See the preference in Preferences → Results for tinyint and bit columns.
- Adds a [-] remove button to the first/only filter in the Table Content view, making it easy to click that to remove the filter rather than having to select "Show All" from the popup menu.
- Added a new preference for JSON to be edited in the field value panel rather than inline in the table.
- The field value panel is no longer a sheet, but a less obtrusive popover.
New! Database Relationships
- The relationship graph now optionally shows table columns fields and types, as well as their PK/FK status.
- The relationship graph can now be exported as a PDF.
- The relationship graph has improved and faster layout.
New! Query View
- Added color themes, including a default one for dark mode. See Preferences.
- Added a preference for whether Querious continues, stops, or asks what to do when an error is encountered while executing multiple queries.
- All-new SQL formatter with more options (stripping comments and indenting). Easily triggered with Cntrl-F.
- Added a new "Minify SQL" formatting option.
New! Server View
- Can now export the Slow Queries log file.
- Can now export the Server Errors log file.
- The Process list can now hide sleeping connections.
- The Server Errors log view can now show the raw text of the log, particularly if it can't be parsed correctly.
New! Structure View
- The Primary Key view's popup allows easily creating a new column that will be the autoincremented column.
- The CREATE statement in the View Structure view is now formatted for better readability.
- It is now possible to create a new table directly from a CSV/Tab file being imported.
- When importing CSV, empy column values in the file can instead import as specified default values.
- Importing from compressed gz files is supported.
- Added an option for whether Querious continues, stops, or asks what to do when an error is encountered while importing. SQL can ask on any error, while CSV importing can only ask for some. Some errors will still cause the import to fail.
- Added several SQL export options, such as 'Include Definer Clause', Use 'INSERT IGNORE', and 'Use single transaction'.
- SQL exporting has feature equivalence to mysqlpump.
- All exporting can now export directly to compressed gz files.
- Export settings can be saved and loaded through an action menu in the export panel.
- There is a new "Entire Server" option for SQL exporting which allows multiple databases and even users to exported to the same file. This is one way to essentially dump the contents of the entire server at once.
- When exporting as SQL, views are exported in dependency order so they don't cause problems when the SQL is imported.
- Added a 2-digit year template option for export file names.
- Duplication is more reliable due to better handling of dependencies.
- Trigger creation is now the last step in duplication so that triggers are not fired when inserting data which lead to issues. One example is a trigger which auto-populates another table from the first table's data, leading to a duplication of data because it was already inserted when copying table data explicitly.
- Removes the DEFINER and SQL SECURITY clauses so that duplicating between servers where the user does not exist will work.