Querious 5

Querious now has extensive support for PostgreSQL databases!

• Full support for Tables – content, columns, indexes, keys, constraints, sequences, and triggers.
• Views and Materialized Views
• Functions and Procedures
• Import/Export – CSV, Tab, JSON (export-only), and SQL
• pg_dump and pg_restore – Dedicated views with really great UIs
• Server Replication View – confirm replicas are keeping up
• Server Users/Roles – view and edit
• Server Variables – configure server settings
• Server Extensions — view and install/uninstall
• Server Activity – view and kill running processes
• Server Locks – monitor every open lock on the server
• Server Index Usage – discover better indexing opportunities
• Server Statements – find costly queries to optimize
• Server Status – overall health and status
• Schema Diagnostics – scan your schema to find structural problems that tend to cause trouble later
• Schema Types – view custom types
• Schema Sequences – view sequences
• Note that currently "Duplicate" and "Compare" are not supported for PostgreSQL.

You can now register Querious using your Araelium Account, License Key, or an Access Key given to you by a team leader. When registering using your Araelium Account, Querious will always automatically use your latest license, and you are able to use the new Query Assistant service. Querious Team licenses allow organizations to distribute revocable access keys to team members, giving organizations more control. For more about team licenses, see the website.

• Server Access now has a clear permission switch for allowing Querious to read local log files which are protected with elevated file permissions. Reading files is now done using a new "Querious Privileged Helper" tool.
• Server: Index Usage – discover better indexing opportunities
• Server: Error Log – improved style, usability, parsing of error codes and subsystem, group repeated messages, more
• Server: Locks – inspect blocked connections
• Server: InnoDB Status – structured layout and summary bar
• Server: Users overhaul – better layout, filtering, and better MySQL 8+ support.
• Server: Slow Queries – Added helpful tooltips
• Server: Query Analyzer – analyze a single query's execution plan
• Server: Query Digest – find which query patterns cost the server most time and I/O

• Schema Diagnostics – scan your schema to find structural problems that tend to cause trouble later
• Schema Index Usage – discover better indexing opportunities in this schema
• Schema Info – new view showing data usage, numbers of objects, and schema settings

The Relationship View has been dramatically overhauled!

• Three all-new layouts for better table arrangement, with customizable spacing.
• Drag and reposition tables! Your custom positions are saved.
• Rubberband selection for repositioning multiple tables at a time.
• A new interactive minimap quickly orients you within the overall graph.
• Zoom by swiping (scroll wheel) while holding option.
• Pan by swiping (scroll wheel) as before, or command-drag.
• Foreign Key edges now connect directly to the PK/FK fields.
• Visual tweaks to improve clarity.

• A new super-handy Relationships sidebar view displays tables related through PK/FK links (directly or as ancestors), and provides very fast jumping between them. For example: select an Order row, and quickly jump to that order's Account or LineItems.
• The vertical form editor's two-column layout now has resizable columns (remembered per-table, double-click to reset), and a quick "Go to Column…" button.
• Leave JSON columns unloaded by default with a new app preference/setting.
• Customize specific columns to be Unloaded in the Table Content View Properties. Have a big column you never care about the values for? Set it to be Unloaded.
• MySQL UUID type support with a new MySQL preference to interpret binary(16) as a UUID, and display it as a UUID string in results.
• Performance optimizations so Table Content scrolling is much smoother in large lists.
• Adds a preference to display row numbers next to each row.
• Improves the appearance of conditional row highlighting.

Table Columns

• Filter the columns list by name.
• Sort the columns list by name or by the table's natural column order.
• Shows which columns are PK/FK. Clicking jumps to the related key.
• New value list editor for enums and sets which is much more usable. Supports Cut/Copy/Paste/Select All, drag reordering, you can paste in multi-line text to insert multiple values, etc.
• Specify MySQL column default values using an SQL expression.
• Appearance improvements with better list resizing and wider spacing, Added/Removed/Modified columns now have coloring applied to their whole row to show the status, and the details area is now resizable.

Others

• Modifying Table Indexes now highlights the index row to show it's been modified, and shows Apply and Revert buttons.
• Modifying Table Foreign Keys now highlights the foreign key row to show it's been modified, and shows Apply and Revert buttons.
• New layout for the Table Info view which is more organized with the sidebar.
• The Function and Procedure structure view layout is more organized with the sidebar.

JSON

• Database rows can now be copied to the clipboard as JSON.
• The contents of a table can be exported to JSON, either as an object array, values array, or a table object, and either compact or pretty-printed.

CSV/Tab

• When importing CSV/Tab, there is a new "Values" view, allowing customization of value conversion and defaults. If the source file has data in the wrong format, let Querious do some transformation to make it the right format before importing.
• Convert date formats – (ISO/RFC/SQL/Unix Timestamp/Custom Format String/etc).
• Convert numerical formats – (dot decimal vs comma decimal).
• SQL expression Values – Use an expression to define the value to be imported, either to generate a new value or transform the file's field value.
• Handle Empty values – For empty values in the file, specify if the imported value should be: Empty or a Default value.
• Disable Foreign Keys – A new import option to avoid issues when INSERTs in the file are in the wrong order of foreign key dependencies.
• Disable Unique Checks – A new import option to speed up imports when there are no duplicate keys.
• Choose from a list of types supported by the server, when specifying the column type for a New Table created during import.

SQL

• Improvements in MySQL and SQLite .sql file export to fix some minor inconsistencies. No one issue is major, but combined they level up the exporter's correctness.
• Most significantly, the statements within the SQL file are ordered more correctly based on dependencies, even if unique and FK checks are disabled.
• During MySQL export, it now releases the global read lock after creating an InnoDB snapshot, which lets other connections write to the tables during the export. Only if the tables being exported include a MyISAM table is the lock held for the duration.
• Importing to the database no longer automatically creates a transaction, yielding full control over transactions to the sql file itself.

General Transfer and Duplicate

• The import/export/transfer error window is now bigger and resizable, with a more clear display of the failed query, row, and log.
• The import/export/transfer progress window is now wider and more readable, splitting status onto multiple lines.
• Double-clicking the operation in the progress window will now reveal the exported file in Finder, or show the error. (Equivalent to clicking on the small "Reveal" button.)

• Requires macOS 13.2 or later
• Refreshed user-interface, matching current macOS Tahoe and Golden Gate interface expectations. Querious now uses the new window toolbar and sidebar appearances, with new control sizing and spacing, and many little refinements all over. Querious now also uses a native right side "inspector" sidebar in several views.
• Settings/Preference panels are now organized into groups.
• There's an all-new update checker/panel which can display all previous versions, and can display multiple newer versions to choose from (if available).
• All newly-added/modified passwords are saved to your Keychain as "synchronizable" passwords which will now be available in iCloud Keychain as well. Simply updating an existing saved connection will also move its password to be available in iCloud Keychain.
• The View → Go to Previous/Next Editor menu items now use Cmd-Shift-comma/period by default for quick keyboard navigation between subviews like Columns, Indexes, etc.

Appearance Customization

• Adds a new preference for turning on/off tinting of the titlebar with the connection color.
• Adds a new setting for what's displayed in each connection tab: Connection color's swatch, connection icon, tinting with the color, name, host, etc
• Change the size of buttons/labels/controls application-wide.
• Set the font size of general lists, application-wide, and even choose an amount of extra spacing.
• Result Row spacing options are now: Compact, Regular, and new "Large" for more breathing room.

The URL scheme (querious://) is useful for integration into automated scripts and launcher systems, and has been enhanced in this version.

• Querious now supports the "standard" mysql:// and postgresql:// URL schemes to connect to server. (This integrates Querious into Postgres.app for example.)
• A new app preference lets you deny or request confirmation of every new connection to a server made by any URL.
• querious://connect/new supports every connection setting, so advanced temporary connection setups are possible.
• querious://connect/saved supports overriding the saved connections' database/schema/password values.
• With the "query" parameter, you can have Querious automatically open and set the SQL in the Query view.
• An opened connection can be assigned an "id", and later URL calls can refer to that same id.
• Added a new querious://query action which will open the query in the Query view in an already-open (id=) connection.
• querious:// now supports registering Querious with a team access key.

• When deleting a saved connection, it now confirms if you also want to delete the passwords for it or not. Previously it always deleted them.
• Importing app settings (connections, preferences, color themes, etc) with "Replace existing settings" turned on, now asks for confirmation before actually replacing them.

• Faster tab loading speed and switching between some views.
• SQL Exporting: Improvements to the ordering of DROP/CREATE/INSERT statements, and schema objects as a whole, to avoid dependency issues, even if technically avoided by disabling FKs etc.
• SQL Importing: Querious no longer creates a transaction before executing the file. Transactions are now left entirely up to the SQL file itself, to avoid issues with transaction nesting, silent errors, and premature commits.
• The Duplicate schema object panel now sets the "database" field to the connection's default database when you select a different connection.
• The old Artificial Foreign Keys feature that was in Querious since v1.0 has been removed. AFKs were intended for use with MyISAM tables which do not support actual Foreign Keys. While still potentially useful in rare circumstances, the vast majority of production databases now use InnoDB and removing AFKs makes it much easier to create features that rely on FKs.
• The Schema → Structure → SQL Structure / Export view has been removed because it was effectively redundant. Use File → Export instead.

• Table Content search and sort are now saved as part of the navigation state.
• The Table Content view now consistently applies the default PK sort order.
• The vertical editor's filter now applies correctly when changing rows or the layout.
• The keyboard shortcut (Ctrl-W) for closing a query tab in the Query view now works.
• Error messages now always include the related query when there is one. (This was always intended, but the query was sometimes missing.)
• From the Query or Server views, "Go To…" now reopens the Content view even when the table is already selected in the Content view's primary sidebar.
• Fixes an issue where copying selected rows in the Table Content view (as CSV or JSON etc) would only load the "Unloaded" values for a single row, and not copy the remaining rows.
• Fixes an issue where a "Duplicate" transfer might say it couldn't connect to the destination because it didn't have the password.
• Hides the "Compression" option when copying rows to the clipboard because it was illogical to show.
• The MySQL server Error Log was chopping off the message of the last entry.
• SQL Exporting: MySQL SQL file exports now correctly turn on DISABLE KEYS.
• SQL Exporting: Writes comments and line endings correctly in all cases.
• SQL Exporting: Query results now omit "LOCK TABLE" when there is no named table available to lock.
• SQL Exporting: MySQL data-only exports now include the USE statement when exporting multiple schemas' data.
• SQL Exporting: MySQL exports now include DROP USER statements when that option is enabled.
• SQL Exporting: Preserves an empty value in the last column of a row during row exporting instead of writing it as NULL.
• SQL Exporting: MySQL exports now write NO_AUTO_VALUE_ON_ZERO to preserve 0-value IDs.
• SQL Exporting: The SQL_MODE preservation written into the file now saves the actual mode to the temporary variable instead of NULL.
• SQL Exporting: SQLite exports now apply ignore_check_constraints with the correct sense.
• SQL Exporting: When exporting query results, it gets the table name (for the INSERTS) from the first column that has a table name, and now throws an error if none exists. Previously it would assume the first column always had a table name.
• Importing: When importing to the database, a failed MySQL USE statement now correctly fails the entire import.
• Importing: SQL files now properly support encodings other than UTF-8.
• Importing: CSV/tab files now detect the Unicode BOM more accurately.
• Importing saved connections which already exist can no longer accidentally delete the password.
• Duplicating a saved connection no longer causes the original to forget its password (while the new one had it).
• SQLite: Importing records into SQLite with "Insert Ignore" no longer fails with a SQL syntax error
• SQLite: "Explain Query" now shows the query plan instead of either failing or showing bytecode.
• SQLite: Truncating a SQLite table no longer fails with a SQL syntax error.
• Fixes a number of small memory leaks.
• Numerous other improvements for quality, stability, and minor issues.