Changes since 24.1.5:
SQL Editor:
Fixed highlighting of block $$ for functions and procedures when the semantic analysis option is enabled
Warning and errors handling and presentation was improved
Subquery semantic analysis was enhanced
Improved CREATE and DROP queries handling
Autocompletion for fully qualified names was fixed
Duplication of proposals with new completion engine enabled was fixed
Incorrect suggestions with new completion engine enabled were fixed
AI Assistant:
Added new model ‘gpt-4o-mini’
Removed deprecated model ‘gpt-3.5-turbo-16K’
Fixed query generation when enabled formatting
Data Editor:
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 present in the result set
Improved handling of fully qualified names in Grouping panel according to SQL dialect
Local links opening was restricted
Datatransfer: Data transfer windows width was fixed
Connectivity: Fixed verification of the 127.0.01 host when connecting via SSH
General:
Fixed flipping splash screen on macOS Sequoia
Foreign Data wrappers configurator was fixed
‘Open auth links in embedded browser’ setting was disabled by default
Search in Preferences was improved: added keywords for reopen, open, Hippie, autosave, and others
Fixed selection of wrong database when changing connection for database with similar 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
Databases:
Clickhouse: Filtering by the Date data type was fixed
MySQL: Error/output log dump was fixed
PostgreSQL:
Ordering by interval datatypes in the Data grid was fixed
Added regexp functions support in SQL Editor (thanks to @anton-erofeev)
Redshift:
Connection stability was significantly improved
DDL presentation was fixed
Role, User, and Group presentation was fixed
SQL Server:
SQL Server driver was updated to version 12.8.0
Fixed DDL and column display with custom data types
Localization: French localization was updated (thanks to @KawtharAlakri)
SQL Editor:
Added semantic analysis and Outline viewer support for CREATE and ALTER TABLE queries
Added presentation for warnings in semantic analysis results
Data type icons were redesigned
SQL error presentation was redesigned
‘Execute SQL Script’ option behavior was fixed
SQL Output for SQL scripts was fixed
Output panel opening was fixed
Column aliases can now be copied with Advanced Copy option (thanks to @dstivanov)
Column validation for UPDATE SET clause was fixed
Issue with invalid table name was fixed
If all tabs with query results are pinned, a new tab with a new query result is created
Data Editor: Paste into the table with no foreign key was fixed
Database Navigator:
Connection visualization was fixed
Navigator icons were redesigned
Connectivity: Connection page for custom drivers with the URL template was fixed
General:
Opening links to local files has been restricted due to a security issue discovered by @LuskaBol
Improved error handling when trying to use not allowed characters in project name
Databases:
Altibase: Non-schema objects like Job, Database Link, Directory, and Library are now supported (thanks to @zennken)
BigQuery: Database monitoring dashboards were added
GaussDB driver was updated to version 4-1.1 (thanks to @GaussDB-Fans)
MariaDB: Geometry data type is now supported
Ocient: Incorrect DDL generation was fixed (thanks to @mjsterckx)
SQLite: Full text search was improved
SQL Server: Saving changes in procedures was fixed
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
Smart mode for Blank line state delimiter was improved
Simultaneous query execution was fixed: if a query is already being executed, you can execute another query in a new tab only
Composite type field color became visible in the Dark theme
Completion analyzer performance was enhanced
Data Editor:
Inline editing of geometry fields was fixed
New keyboard shortcut Ctrl+Shift+Alt+C has been added to use the advanced copy option with the latest settings, without opening a popup window
Metadata Editor: Generate SQL option in the context menu was fixed
Connectivity: Closing idle connections and default timeout were fixed
General:
Users can import connections from SQL Workbench and DbVizualizer
Wayland support on Linux was fixed
Several code improvements have been made (thanks to @KonstantinRight)
Databases:
GaussDB driver was added (thanks to @GaussDB-Fans)
Couchbase: Legacy Couchbase driver was removed
CUBRID:
Execution plan was enhanced (thanks to @rathana-pvs)
Issue with Null datatype was fixed (thanks to @longhaseng52)
Creating partition option was removed (thanks to @longhaseng52)
InterSystems IRIS driver was updated to version 2024.1 (thanks to @isc-rsingh)
PostgreSQL: If the database name is empty, it will be set to the same as the username
SAP Hana: Additional system table prefix was added (thanks to @kai-morich)
SQL Server: Ability to upgrade/install the driver was fixed
SQL Editor:
Added ability to disconnect from the datasourse when all associated editors were closed (configurable)
New autocompletion engine was significantly enhanced
Autocompletion for derived columns in sub-queries was improved
Autocomplete suggestions inside literals in INSERT INTO were disabled
Execution of the corrected SQL script was fixed
‘Recent SQL script’ was renamed to the ‘Last edited SQL script’
Short/long object names completion configuration was redesigned
Metadata editor: Composite data types presentation was added for table columns
Data editor: JSON and XML panels performance was enhanced
Data transfer:
Compress option behavior was fixed
Wizard window auto-size was fixed
Task management: Broken exported file extension after the task editing was fixed
Dashboards: Project dashboard UX was improved
Connectivity:
Connections invalidation after sleep mode was added
Idle connections timeout was fixed
General:
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
SVG extension was moved to the PRO version
Authentication in embedded browser was temporarily disabled on Linux
Databases:
Altibase:
Added the ability to compile procedure, function, or package from the UI as well as truncate table and refresh materialized view (thanks to @zennken)
Added status of the view, materialized view, procedure, function, or package (thanks to @zennken)
Execution plan parsing error was fixed (thanks to @zennken)
Clickhouse:
DateTime32 formatting was fixed
IPV6 data presentation was added (thanks to @asifjoardar)
Complex structure display in the Data grid was fixed
CUBRID:
View creation was added to the UI (thanks to @longhaseng52)
Supported keywords for SQL Editor were reviewed and updated (thanks to @rathana-pvs)
Ability to edit Serial using UI was added (thanks to @longhaseng52)
DuckDB: Data edit was fixed
Microsoft Azure driver was updated to version 12.7.0
Oracle: DDL generation for Oracle Tablespaces was added (thanks to @pandya09)
PostgreSQL:
Specific functions were supported in the SQL Editor (thanks to @EastLord)
Metadata read was fixed
Redshift:
Metadata reading for indexes was disabled
Problems with broken connection were resolved
SAP IQ: Duplicated output messages were fixed
Teradata: Database name became optional for connection
Vertica: Incorrect query execution with the cursor at the end was fixed
Localization: Italian localization was updated (thanks to @Gnafu)
SQL Editor:
Performance in Smart mode of Blank line as a statement delimiter was enhanced
Ability to show all SQL scripts from the main toolbar was added
Syntax highlighting for functions with multiple arguments was fixed
SQL datatype color use was corrected
DROP statement support was added to Outline
Metadata Editor: Foreign Key creation dialog UIX 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
Customise and Save filter buttons were moved to the dropdown
Issue with too small Result Set Order/Filter Settings window was resolved
Rollback timer flickering was fixed
Query Manager: information about database schema and catalog was added to the detailed record view
Simple Structure Compare: issue with long file names was resolved
Connectivity:
Issue with default SSH connection timeout was resolved
Driver downloading problem reporting was fixed
General:
Incorrect button behavior in the confirmation dialog was fixed
Security credential encryption was enhanced (thanks to @longhaseng52)
Toolbar and Data Editor background on the Dark theme was improved
Smart commit mode indication was fixed
Issue with metadata cache reading was resolved
Automatic resize of connection dialog and tasks dialogs was fixed
Databases:
Clickhouse:
Complex structures handling was fixed
Clickhouse driver was updated to version 0.6.1
CUBRID: ‘db_server’ information was added to the Database Navigator
Oracle: Connection error in the application downloaded from the Microsoft Store was fixed
PostgreSQL: Dollar-quoted string parsing was fixed
SQL Server:
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
AI: GPT-4o model was supported
SQL Editor:
Auto-save editor setting was enabled by default
ILIKE keyword was supported
Support for unsigned numbers in GROUP BY clause was added
Syntax highlighting and outline viewer support parameter changes in SQL Processing settings
Links to the SQL Editor and Visual Query Builder were added to the Context menu
Buttons in the right toolbar were renamed
Print mode in ER Diagrams and Execution plan was fixed
Saving Diagram outside the workspace was fixed
Data Editor:
Information about table unique key is displayed in the grid
BETWEEN and LIKE keywords were added to filetr autocomplection
Data transfer:
Export of data with backticks was fixed (thanks to @diashalabi)
Export of binary columns in JSON format was fixed
General:
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
Creating a view from the UI was fixed
Buttons display when creating new dashboard was fixed
New table creation was fixed
The following drivers were updated:
Firebird to version 5.0.4
Redshift to 2.1.0.29
Informix to 4.50.JC10W1
Databases:
Altibase: Search for server properties was added (thanks to @zennken)
BigQuery: Ability to see bytes billed in Statistics panel in the Data Editor was added
Cubrid:
Execution plan coloring was enhanced (thanks to @hwany7seo)
Ability to create a table via UI was added (thanks to @longhaseng52)
DDL display for a view was added together with the ability to display the list of indexes, synonyms, serials, triggers, and procedures (thanks to @longhaseng52)
Ping query for keep connection alive was added (thanks to @rathana-pvs)
Partition display was added (thanks to @rathana-pvs)
PostgreSQL:
If database field in connection settings is empty, user name is used as a database name
Work of ‘Use fully qualified names’ setting was fixed for views
Redis: Key settings were fixed
Redshift: Constraint creation was fixed
Vertica: Stored procedures handling in SQL Editor was fixed
Changes since 24.0.5:
SQL Editor: issue with extra linefeed during autocompletion was fixed
Data Editor: loading data when fast scrolling using the keyboard was fixed
Database tasks:
Maximum execution time option was added
Tasks running from non-default workspace was fixed
Connectivity:
‘Azure AD’ was renamed to ‘Microsoft Entra ID’
Links to database support documentation were added for many databases
Automatical termination of the shell command script ‘Before connect’ was fixed
General:
Crash when closing detached editor tab in another window was fixed
‘Restore default’ for Metadata read, Client identification settings was fixed
.projects and .settings folders became findable in Projects when the application is used as an Eclipse plugin
Truncated notifications were fixed
Projects:
Disconnecting a database from the Project view was fixed
Opening a bookmark after changing the application language was fixed (thanks to @SASUKE38)
ERD: loading diagrams for drivers with broken foreign keys support was fixed
Database Navigator:
Color of the table statistics was changed to visible in the dark theme and became configurable
Deleting connection option in the context menu was renamed to ‘Delete connection’
Databases:
CrateDB: table DDL was fixed
Databricks: authentication with personal access token was added
DB2i: procedure creation was fixed
DuckDB: aliases autocompletion was fixed
H2: foreign keys presentation was fixed
Oracle: JSON data type support was improved
PostgreSQL: support of fully qualified names in DDL was fixed
Localization:
German localization was updated (thanks to @maxbobse)
SQL Editor:
Smart mode for statement delimiter was improved
Default option for the setting ‘Blank line is statement delimiter’ was changed to ‘Always’
Cursor behavior during autocompletion was improved
Code highlighting issue with a quoted identifier in case of no connection was fixed
High CPU usage for large script was fixed
Metadata Editor:
Highlighting for created entities was changed to green
Virtual foreign keys: reference table container selector was fixed
Database Navigator: CTRL+C and other shortcuts behavior after the application startup were fixed
AI (extension): custom scope performance was improved
General:
Opening editors for files with special symbols in names was fixed
Portable distribution of the application was fixed (config files location)
Licensing for some source files was fixed
Eclipse plugin: new database objects create was fix
Databases
DuckDB: Spatial data visualization support was added
Oracle:
Partition type display was added
Materialized view refresh was fixed
SQL Server: Default IDENTITY was changed to (1,1) (thanks to @Sgierek106)
Vertica: LOOP/END LOOP as a block and DECLARE were added to the syntax analyzer
SQL Editor:
Smart mode for Blank line is statement delimiter setting was fixed
Vertical button alignment was fixed
ER Diagrams: Keep layout selection was fixed
Data transfer:
Import from CSV with duplicated columns names was fixed
Parallel data transfer monitoring/cancellation were fixed
Dashboards:
Ability to drag and drop charts to another dashboard was added
Number of minor UI improvements were added
Connectivity:
SSH parameters validation on the Connection page was added
Editing of ‘Local host’ and ‘Remote host’ fields in the Port Forwarding section was fixed
Database connection timeout notification was fixed
Development: Redundant tests were disabled
Databases:
MariaDB:
GRANT OPTION privilege persistence was fixed
Schema privileges representation was fixed
SQL Server: trigger deletion was fixed
Teradata: link to the referenced table in the Metadata editor was added
Localization: French translation was updated (thanks to @Jean-BaptisteC)
General:
Language configuration in Windows installer was fixed
We have migrated to Eclipse 2024/06
General:
Migration from Toad for Oracle was supported
Sensitive information in the log files is now masked
SQL Editor:
Smart mode for ‘Blank line as statement delimiter’ option was added (enabled by default)
Sub-select autocompletion was added
Highlighting of column references in INSERT queries was fixed
Outline viewer opening was fixed
Issue with hidden text on macOS was fixed
Connectivity:
Space trimming when saving user credentials was added
Saving SSH configuration with missing AWS private key was fixed
Reconnecting via SSH tunnel was fixed
ER Diagrams: foreign keys presentation was fixed
AI:
AI assistant is enabled by default
Database metadata collection was fixed
Dashboards: disappearance of custom dashboards after version update was fixed
Connectivity:
Space trimming when saving user credentials was added
Saving SSH configuration with missing AWS private key was fixed
Reconnecting via SSH tunnel was fixed
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read more Privacy & Cookies Policy
