- 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
- Connectivity:
- Using multiple jumps tunnels when connecting via SSH was supported
- Enable tunnel sharing option was added
- Test connection was fixed
- SQL Editor:
- WHERE TRUE and SELECT UNIQUE support was added
- Error with single quoted string was fixed
- Syntax highlighting after active schema change was fixed
- Data Editor:
- Automatic row count option was added (thanks to @utsav1704)
- Metadata editor:
- Deleting table comments was fixed
- Linking with the editor was fixed
- General:
- Ability to collect log files from the interface was added
- Transaction rollback behavior was fixed
- Metadata changes were removed from the commit counter
- Autocommit in production databases was fixed
- Data transfer:
- Ability to specify header case in the target file was added
- Typo in the confirmation dialog was fixed
- Databases:
- Cubrid: Query plan feature was added (thanks to @rathana-pvs)
- Old MySQL drivers were repacked
- PostgreSQL: Jobs, roles, and system information were hidden in the Hide Folders mode
- SQLite: Deleting columns was fixed
- Connectivity:
- Shared SSH sessions support was added
- Connection via native proxy was fixed
- Dark theme support on the Connection page was improved
- SQL Editor:
- Highlighting, validation, and outline for INSERT, UPDATE, and DELETE were supported
- Incorrect cursor position during autocomplete was fixed
- QUALIFY keyword was supported (thanks to @ashu7896)
- Metadata editor: automatic reference column creation for a new foreign key was implemented
- Data Editor:
- Opening of a table with empty data was fixed
- SRID editing was fixed
- General:
- SVG icons support was added
- Error when checking checkboxes in the Formatting page in Preferences was fixed
- Disappearance of renamed project was fixed (thanks to @saikotek)
- Databases
- Dameng: Sequence creation was fixed
- DuckDB:
- Sequences, views, and table definitions were supported
- Ability to add comments via UI was added
- MySQL: link to the driver documentation was fixed
- RisingWave: non-working functions and folders were removed
- PostgreSQL: issues with scheduled jobs was resolved
- SQLite: errors when creating table was fixed
- SQL Server: redundant authentication types were hidden
- Sybase: stored procedures support was improved
- Teradata: procedures and functions DDLs reading was enhanced
- Localization:
- Romanian language support was added (thanks to @v613)
- French translation was updated (thanks to @Jean-BaptisteC)
Changes since 23.3.5:
SQL Editor:
- Nested CASE statements were supported
- Deleting queries from Outline was fixed
- Type casts support was improved
- Handling of right-click on collapsed query was fixed
- Expanding collapsed group after the code execution was fixed
Metadata editor: changing the key name when a constraint is changed
Data Editor: SRID switching in the Spatial data viewer was fixed
ER Diagram:
- Missing connection lines were fixed
- Mikami-Tabuchi routing type was disabled
AI:
- Comment presentation was improved
- Sending unique keys and indexes was fixed
Data Transfer:
- Export statistic was fixed
- Import blocking in case of table creation restriction was fixed
- Stack overflow on Linux was fixed
Connectivity: closing timeout for an idle connection was increased and disabled for embedded drivers
Security:
- Vulnerabilities display in Elasticsearch was fixed
- PosgtreSQL driver was upgraded due to CVE-2024-1597
General:
- Smart commit mode was enhanced: if the manual commit mode was enabled and just after it the query failed, the smart commit mode is enabled again
- Links between preference pages were fixed
- Issue with not found tables was fixed
- Release note display was corrected
- Driver libraries download was fixed
- Previous workspace format was supported
- Usage statistics popup was redesigned
Databases:
- DuckDB: WSL paths handling was fixed
- Greenplum: STRICT keyword was added to function definition
- Hana: Switch to the Kerberos authentication in the Connection page was fixed
- MariaDB: The exported JSON format was fixed
- MySQL and MariaDB:
- “Disable Triggers” option was added to the Context menu
- “Case-sensitive” option was added to the metadata search
- Databases with the same name but different name case are considered as different databases
- Oracle: generating DDL for triggers was fixed
- SQL Server: additional table properties were added for tables and views in the properties editor
- Yellowbricks icons and link to the website were changed
- SQL Editor:
- Syntax highlighting was improved
- Highlighting in nested queries and on query editing was fixed
- Scrolling with opened Outline was fixed
- Applying settings to Outline was fixed
- Order by i.* was supported in Outline
- Joined tables presentation in Outline was fixed
- AI: Ability to send object descriptions to OpenAI was added
- Data Editor:
- Scrolling multiple tab result was improved. You can scroll all result sets using Ctrl
- Fetch next page shortcut was changed to CTRL+ALT+N
- ER Diagram: Connections rendering was improved
- Data transfer:
- The Proceed button at the last step became more visible
- On conflict expression was added to INSERT statements
- Crash when importing CSV file was fixed
- Extra space before the semicolon in export to SQL was removed
- General:
- Close idle connection setting saving was fixed
- Application launch was improved
- Unexpected transaction ending was fixed
- Settings are applied to new connections without a restart
- User credential dialog was fixed
- Issue with the background task of the dashboard update was fixed
- Temporary directory creation was fixed
- Security: Added warning when trying to open an encrypted project and risk losing all connection credentials
- New driver:
- StarRocks database support was added
- Databases:
- MariaDB driver was updated to version 3.3.2
- Oracle:
- Keywords and schemes highlighting was improved
- Default subpartition type was added
- PostgreSQL:
- Creating a new table from the user interface was fixed
- Duplication of procedures was fixed
- Snowflake: VIEW keyword highlighting and validation was improved
- SQL Server: syntax highlighting was fixed
- Sybase:
- Stored procedure creation was added
- Using create view instead of Alter view was fixed
- Import with table mapping was fixed
- Localization:
- French translation was updated (thanks to @Jean-BaptisteC)
- Babel version was updated
- Metadata Editor:
- Constraint creation was fixed
- Editor performance on Linux was enhanced
- SQL Editor:
- Autocomplete for aggregate functions was added
- Arrays highlighting was added
- SELECT query validation was fixed
- Color and font settings with enabled semantic analysis was fixed
- Small font in the editor and result set was fixed
- Creating multiple parsing jobs was fixed
- Outline viewer:
- Composite types and arrays support and validation was added
- Data type decorations were added
- Error when saving SQL console as a script was fixed
- AI: Issue with using chat format in completion dialog was fixed
- Data Editor:
- Ignoring quotes option was added to Advanced paste
- Issue with multiple checks in filters was fixed
- ER Diagram: Self-connection rendering was enhanced
- Data Transfer:
- Delimiter selection when exporting in TXT format was added
- Target table change on the mapping page was fixed
- General: Idle connections behavior has changed, now they are automatically closed by default after some time
- New drivers:
- RisingWave driver support was added
- Cubrid driver support was significantly enhanced (thanks to @longhaseng52)
- Databases:
- Altibase:
- Adding and renaming constraint in metadata editor was fixed
- Reading data in columns with quote names was fixed
- Clickhouse: Legacy driver was fixed
- MySQL and MariaDB: ‘Grant option’ is checked only if grant permission exists
- Snowflake:
- Snowflake driver was updated to version 3.14.4
- Double-dash single-line comments highlighting was fixed
- Functions words were added to SQL Editor
- SQLite driver was updated to version 3.44.1.0
- TDengine: Unqoted table names presentation was fixed
- PostgreSQL: Option ‘Show all databases’ was moved to the main page in the Connection settings
- Redshift: Added extended support for stored procedures for early Redshift versions
- Misc:
- Links to download PRO version were added
- Ability to use waffle-jna in MariaDB, PostgeSQL, and Oracle was added
- Flipped splash screen on macOS Sonoma was fixed
- Metadata editor:
- Object creation dialog was redesigned
- SQL Editor:
- Autocomplete for INSERT statements was fixed
- Case sensitivity on highlighting and validation was fixed
- Duplicated table aliases in autocomplete were fixed
- Column aliases highlighting was fixed
- Dot character is not allowed again in variable name
- Data Editor: Column descriptions are displayed again
- Database Tasks: Display of task execution time was fixed
- ER Diagram: One-to-one connection rendering for unique/primary key was fixed
- Data Transfer:
- All columns can be marked as skipped when exporting data
- Statistics was excluded from exported data
- General:
- Changing the monospace font was fixed
- Unique key creation was fixed
- Finding local clients on Linux and macOS was improved
- Databases:
- Altibase support was added (thanks to @zennken)
- BigQuery: Structs and arrays are supported
- Dameng:
- Dameng driver was updated
- Users, roles, and categories are supported (thanks to @Stkai)
- MySQL: Path to the local client was fixed
- MySQL and MariaDB: Rendering columns with unique identifiers was fixed
- PostgreSQL:
- Schema permissions display was fixed
- Confirmation message for clean option of restore wizard was fixed
- SQLite: Import with ‘truncate target tables before load’ option was fixed
- SQL Server:
- Check constraint option was removed from primary/unique key creation page
- Displaying source in the index properties was fixed (thanks to @HansenChristoffer)
- SQL Server driver was updated
- Localization:
- Japanese localization was updated (thanks to @doew)
- Misc:
- Microsoft Store version was fixed
- Starting application when the workspace directory is a link was fixed
- Metadata editor:
- New database objects wizard was redesigned
- Primary/unique key can be created automatically along with new columns
- SQL Editor:
- Outline viewer of SQL queries structure was added
- Execution time format was improved
- Toolbar customization page opening was fixed
- Identifiers coloring was improved
- Autocomplete was fixed for multiline comments
- Accessibility: notifications can be read with a screen reader (JAWs, NVDA or Narrator)
- ER Diagram: connection errors handling was added
- Data Transfer: Incorrect links in settings were fixed
- AI: legacy OpenAI models were removed
- General:
- Incorrect links to help articles were fixed
- Redundant items were deleted from the Context menu
- Global network settings preferences page is available again
- Databases:
- ClickHouse: leagacy driver configuration was fixed
- Dameng: tablespaces are supported (thanks to @Stkai)
- Google Cloud SQL: redundant options were removed from the context menu
- MySQL: TLS 1.3 support was added
- MySQL and PostgreSQL: local native database clients can be found on macOS and Linux
- Teradata: metadata search was significantly enhanced
- Localization:
- Ukrainian localization was added (thanks to @CrazyTapok-bit)
- Italian translation was improved (thanks to @coluzziandrea)
- Portuguese localization 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.AcceptReject Read more Privacy & Cookies Policy