Major new features and changes:
- 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. (See documentation in the Help menu.)
- A number of internal optimizations for stability, consistency, and performance.
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.
- 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.
- 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.
- 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.
- "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.
- 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.
- 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.
- 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.
- 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.
- Fixes faulty SQL where the CREATE VIEW syntax still referenced the old database leading to an error.
- 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.
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 firstname.lastname@example.org or send a tweet to @AraeliumGroup!