September 9, 2024
Changes since 24.1:
- General:
- Added the ability to disable all metadata queries. This can be useful for improving performance or reducing the number of queries to expensive databases.
- Wayland support on Linux was fixed.
- ‘Show scripts’ option was added to the SQL dropdown in the main toolbar.
- Establishing connection visualization was added to Database Navigator and Projects.
- Tooltip delay on macOS was reduced and became configurable.
- Saving script outside the Script folder was fixed.
- Authentication in embedded browser was temporarily disabled on Linux.
- Incorrect button behavior in the confirmation dialog was fixed.
- Security credential encryption was enhanced.
- Smart commit mode indication was fixed.
- Issue with metadata cache reading was resolved.
- Automatic resize of connection dialog and tasks dialogs was fixed.
- Ability to restore default settings was fixed in SQL Editor Formatting settings, SQL Editor settings, SQL Editor Commit type, Error handling settings, and Hex Editor default width.
- Buttons display when creating new dashboard was fixed.
- Improved error handling when trying to use not allowed characters in project name.
- Fixed flipping splash screen on macOS Sequoia.
- ‘Open auth links in embedded browser’ setting was disabled by default.
- Search in Preferences was improved: added keywords for reopen, open, autosave, and others.
- Fixed an issue with connection to the incorrect database for the case when databases in different schemas had identical names.
- Folder display in Simple view was fixed.
- Numeric (DWORD) type parameters in Windows Registry are now supported.
- ‘Ctrl+Alt+Left / Right’ hotkeys for ‘Previous Edit Location’ and ‘Next Edit Location’ were fixed.
- Added import of configured connections from MySQL Workbench and other third-party database management tools.
- SQL Editor:
- Problem markers with semantic error descriptions were added. You can click on the problem description in the tooltip to find out what is wrong with the query.
- INSERT, DELETE, UPDATE, DROP, CREATE, and ALTER statements execution in read-only mode was prohibited.
- Performance and behavior of the Smart mode for Blank line state delimiter were improved.
- Added ability to disconnect from the datasourse when all associated editors were closed (configurable).
- Auto-save editor setting was enabled by default.
- Simultaneous query execution was fixed: if a query is already being executed, you can execute another query in a new tab only.
- Fixed an issue when the pinned tab was replaced by the new query result.
- Autocompletion:
- New autocompletion engine was significantly enhanced.
- Autocompletion for derived columns in sub-queries was improved.
- Autocomplete suggestions inside literals in INSERT INTO were disabled.
- Completion analyzer performance was enhanced.
- Short/long object names completion configuration was redesigned.
- Autocompletion for fully qualified names was fixed.
- New completion engine was improved: fixed proposal duplication and incorrect suggestions.
- UI improvements:
- ‘Recent SQL script’ was renamed to the ‘Last edited SQL script’.
- Buttons on the toolbar at the right part of SQL Editor were renamed to Builder and Editor.
- Data type icons were redesigned.
- SQL error presentation was redesigned to fit the window size.
- Semantic analysis:
- Syntax highlighting for functions with multiple arguments was fixed.
- SQL datatype color use was corrected.
- Composite type field color became visible in the Dark theme.
- ILIKE keyword was supported.
- Support for unsigned numbers in GROUP BY clause was added.
- Added semantic analysis for DROP, CREATE, and ALTER TABLE queries.
- Column validation for UPDATE SET clause was fixed.
- Subquery semantic analysis was fixed.
- Fixed highlighting of block $$ for functions and procedures when the semantic analysis option is enabled.
- Outline viewer:
- DROP, CREATE, and ALTER TABLE support was added to Outline
- Syntax highlighting and outline viewer support parameter changes in SQL Processing settings.
- Execution of the corrected SQL script was fixed.
- ‘Execute SQL Script’ option behavior was fixed.
- SQL Output for SQL scripts was fixed.
- Output panel opening was fixed.
- AI Assistant:
- AI Assistance: GPT-4o, GPT-4-turbo, and GPT-4o-mini models are supported.
- Removed deprecated model ‘gpt-3.5-turbo-16K’.
- Fixed query generation when enabled formatting.
- Properties:
- Added presentation of structural data types in table Properties.
- Generate SQL option in the context menu was fixed.
- Foreign Key creation UI was improved.
- Data Editor:
- Indication of the table read-only/editable mode was added.
- Information about active unique key used for data edit was added.
- Information about table unique key is displayed in the grid.
- Keyboard shortcut Ctrl+Shift+Alt+C has been added to use the advanced copy option with the latest settings, without opening a popup window.
- Column aliases can now be copied with Advanced Copy option.
- Paste into the table with no foreign key was fixed.
- Inline editing of geometry fields was fixed.
- JSON and XML panels performance was enhanced.
- Issue with switching to the top row in JSON and XML viewers was fixed.
- Text glitches in XML presentation on macOS were fixed.
- ‘Customise’ and ‘Save filter’ buttons were moved to the dropdown.
- Issue with too small Result Set Order/Filter Settings window was resolved.
- BETWEEN and LIKE keywords were added to filter autocompletion.
- Rollback timer flickering was fixed.
- Some datatypes icons were changed.
- Fixed filtering on columns with spaces.
- Added an ability to render geometry shapes in their assigned color if a ‘color’ column is presented in the result set.
- Improved handling of fully qualified names in the Grouping panel according to SQL dialect.
- Local links opening was restricted.
- Background color on the Dark theme was improved.
- ER Diagram:
- Positioning of tables without connections in Orthogonal path routing was improved.
- Entity selection was fixed.
- Bridge on crossing lines rendering was improved.
- Print mode in ER Diagrams and Execution plan was fixed.
- Saving Diagram outside the workspace was fixed.
- Query Manager: Information about database schema and catalog was added to the detailed record view.
- Database Navigator icons were redesigned.
- Simple Structure Compare: Issue with long file names was resolved.
- Dashboards: Project dashboard UX was improved.
- Data transfer:
- Users can email large task result files by splitting them into multiple parts in zip format.
- Compress option behavior was fixed.
- Wizard window auto-size was fixed.
- Export of data with backticks was fixed.
- Export of binary columns in JSON format was fixed.
- Connectivity:
- It is now possible to use custom SSM Documents to connect to AWS databases.
- Closing idle connections and default timeout were fixed.
- Added ‘Session token’ field to AWS temporary credentials.
- Connections invalidation after sleep mode was added.
- Issue with default SSH connection timeout was resolved.
- Fixed verification of the 127.0.01 host when connecting via SSH.
- Connection page for custom drivers with the URL template was fixed.
- Databases:
- Altibase:
- Added the ability to compile procedure, function, or package from the UI as well as truncate table and refresh materialized view.
- Added status of the view, materialized view, procedure, function, or package.
- Execution plan parsing error was fixed.
- Search for server properties was added.
- Non-schema objects like Job, Database Link, Directory, and Library are now supported.
- BigQuery:
- Ability to see bytes billed in the Statistics panel in the Data Editor was added.
- BigQuery: Database monitoring dashboards were added only in applications for Windows.
- BigQuery: Legacy SQL dialect was supported.
- GaussDB driver was added.
- Cassandra: VECTOR data type is supported.
- ClickHouse:
- DateTime32 formatting was fixed.
- IPV6 data presentation was added.
- Complex structures handling was fixed.
- Filtering by the Date data type was fixed.
- CloudSQL – PostgreSQL: Connection via Cloud Explorer was fixed.
- Couchbase: Legacy Couchbase driver was removed.
- CUBRID:
- Execution plan was enhanced.
- View creation was added to the UI.
- Supported keywords for SQL Editor were reviewed and updated.
- Ability to edit Serial using UI was added.
- ‘db_server’ information was added to the Database Navigator.
- DDL display for a view was added together with the ability to display the list of indexes, synonyms, serials, triggers, and procedures.
- Ping query to keep connection alive was added.
- Partition display was added, creating partition option was removed.
- DocumentDB: Table creation via SQL Editor was fixed.
- DuckDB: Data edit was fixed.
- DynamoDB: Fixed comments handling when generating queries with AI Assistant.
- MariaDB: Geometry data type is now supported.
- MySQL: Error/output log dump was fixed.
- Neo4j: Filters and ordering were fixed.
- Ocient: Tables and views DDL generation was enhanced.
- PostgreSQL:
- Ordering by interval datatypes in the Data grid was fixed.
- Added regexp functions support in SQL Editor.
- Foreign Data wrappers configurator was fixed.
- Redis: Keys settings were fixed.
- Redshift:
- Metadata reading for indexes was disabled.
- Problems with broken connection with the Custom Trust Store were resolved.
- Datashare visibility was fixed.
- Constraint creation was fixed.
- Users and permissions display was fixed.
- Connection stability was significantly improved.
- DDL presentation was fixed.
- Role, User, and Group presentation was fixed.
- Salesforce:
- Reference panel opening was fixed.
- Exception on diagram opening was fixed.
- SAP IQ: Duplicated output messages were fixed.
- SAP Hana: Additional system table prefix was added.
- SQLite: Full-text search was improved.
- SQL Server:
- Saving changes in procedures was fixed.
- Issue with resultset primary key detection was resolved.
- Duplicated output when running stored procedures was fixed.
- NTLM Authentication was fixed.
- Datetime datatype representation was fixed.
- Fixed DDL and column display with custom data types.
- Teradata: Database name became optional for connection.
- Vertica:
- Incorrect query execution with the cursor at the end was fixed.
- Stored procedures handling in SQL Editor was fixed.
- The following drivers were updated:
- Apache Drill to version 1.21.2
- Clickhouse to 0.6.1
- Cassandra to 4.18
- Firebird to 5.0.4
- Informix to 4.50.10.1
- InterSystems IRIS to 2024.1
- SAP Hana to 2.20.17
- SQL Server to 12.8.0
- Redshift to 2.1.0.29
- Yugabyte to v4.15
- Localization:
- Italian localization was updated.
- French localization was updated.
- Altibase: