Major new features and changes:
- Experimental SQLite Support
- Refreshed Modern UI
- Preferences Reorganization
- Customizable Keyboard Shortcuts
- Table Content Conditional Highlighting
- Smarter SQL Autocomplete Suggestions
- Easier Character Set / Collation Changing
- Database Relationship Layout Improvements
- Database Structure Comparison Presets
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.
In this Querious 4 beta, Querious currently has support for working with SQLite databases. While the SQLite functionality should be fully functional, it is considered "experimental." Please please send feedback regarding any concerns or issues you discover to support@araelium.com
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).
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.
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
- 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.
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.
PLEASE NOTE that this is a beta version of Querious which is still undergoing final testing before its official release. As with all beta software, these betas are provided "as is" without any warranty, express or implied. While every effort is of course made to ensure they are stable, you may encounter bugs/glitches or other problems. If you do find any issues or have feedback of any kind, please do send an email to support@araelium.com!
