December 11, 2023
Changes since 23.2:
- New drivers:
- ScyllaDB
- AlloyDB
- Azure Cosmos (Cassandra)
- Dameng
- JDBCX driver
- General:
- We switched to Eclipse 2023-09 as a base platform
- Integration with the different cloud file systems was added
- Restore defaults` on preference pages now resets to actual default preferences
- Reset UI settings was fixed on macOS
- A refresh button was added to the “Generate DDL” dialog
- Comments in generated DDL now can be disabled (configurable)
- Countdown visualization before auto-close was added for idle transactions
- Extra tips were added in connection keep-alive configuration
- The default file encoding was changed to UTF-8. This affects all external tools integration.
- Web-based authentication is now can be opened in the embedded browser
- Tips of the day were updated
- Constraints rename was fixed
- Idle transaction rollback notification was fixed
- App crash when running on Wayland was fixed
- java.compiler and java.scripting modules were included in bundled Java
- Eclipse 2023-09 plugin API is now supported
- General UI:
- Scroll bars were added on the connection page, and other wizards
- When exporting a project, a warning about replacing an existing project was added
- The issue with broken quotes in localization files was resolved
- Rollback countdown flashing was fixed
- Database Navigator:
- Filtered object visualization was added
- Script names are sorted alphabetically
- Script folder opening was fixed
- Click in empty space handle was fixed
- SQL Editor:
- SQL console can be saved as a script
- Aliases proposals for tables with joins were improved
- Auto-completion for complex SQL queries was improved
- Enhanced smart completion is enabled (configurable)
- Code completion for update statements was added
- Smart completion and replacements of quoted expressions were fixed
- Syntax coloring and code completion: smart columns and alias recognition were added (experimental)
- Autocompletion of column names with special characters was fixed
- Output panel display in the statistics tab was fixed
- Selected query execution was fixed
- Queries with CTE execution were fixed
- COMMIT/ROLLBACK statements are now recognized as transaction state change statements
- The issue with big string contents editing (JSON, XML) was resolved
- JSON formatting in the separate editor was fixed
- JSON functions keywords were added to the SQL Assist
- Ctrl+Alt+6 shortcut was changed to Ctrl+Alt+T
- Quoting of identifiers with special characters was fixed
- Representation of errors on query execution was fixed
- Reconnecting of open editors when switching between Simple and Advanced view was fixed
- Script statistics configuration was extended
- Tabs closing in the horizontal mode were fixed
- Script to connection association save was fixed
- Redundant errors on opening SQL Editor for the first time were removed from the logs
- Numerous improvements in single-tab results visualization were made
- AI:
- A new AI Chat tool was added
- Azure OpenAI support was added
- AI completion bugs were fixed, and the configuration UI was redesigned
- Data Editor:
- Multiple query results can now be displayed vertically
- `Go to column` (Ctrl+Shift+G) action was added
- Column search was added to the Metadata panel
- Users can add a shortcut for setting row color
- Grouping panel now shows the actual executed SQL
- Big content representation end editing was limited to 1MB (configurable)
- Message about content representation size limit was fixed
- The issue with the empty table after opening the Calc panel was resolved
- Setting row color for the result set was fixed
- The background color reset was fixed
- App freeze in binary editor was fixed (MacOS)
- Copy from row bellow/above command was fixed
- The issue with hiding the wrong column from the context menu was resolved
- Numeric formatting was fixed for floating point numbers
- The decimal rounding error was fixed
- Filter value search was fixed
- Advanced Copy as HTML with spaces in the column names was fixed
- The numeric value “infinity” representation was fixed
- ER Diagrams:
- Crow’s foot and Bachman notations were added
- The issue with duplicate relations on the diagram was fixed
- A diagram notations switcher was added
- Connections rendering was improved
- Issues with the notation switch were resolved
- One-to-one connection rendering was fixed
- Diagram update on metadata changes was fixed
- Automatic re-layout on notation or routing change was fixed
- Execution plan:
- The white background in the dark theme was fixed
- Disappearing icons were removed
- Data transfer:
- Columns automating mapping is now configurable
- Excel (XLSX) export now supports columns auto-fit
- The file import toolbar was redesigned
- Attributes names for quoted attributes are handled correctly
- “Copy as HTML” result presentation is improved
- The issue with unquoted column names was resolved (in Data Import)
- The library for XLSX export/import was updated, and many minor issues were resolved
- Data import tasks were fixed for schema-less databases
- Columns value transform expressions evaluation was fixed
- All data transfers were migrated to a new IO API
- Error “Data transfer IO error” was resolved
- “Native clients” were renamed into “Local clients”
- An update on conflict behavior was improved (now it respects indexes too)
- Database restore was fixed
- The list of supported variables was updated
- Schema compare:
- Change tree results of migration can be exported in a text file
- Schema migration error was fixed
- Dark theme support was improved
- Data compare:
- Comparing tables with no columns but keys was allowed
- Database tasks:
- Tasks loading for missing database objects was fixed
- Issue with output file name after multiple executions of data export task was resolved
- Missing line break was added to the task log file
- Tableau: Refresh in Tableau tab was fixed
- Connectivity:
- Azure AD authentication was added for PostgreSQL, MySQL, and SQL Server
- Driver download UI was improved: already downloaded driver files are colored in grey
- JDBC drivers maven artifacts resolve was fixed
- The “Propagate driver properties” option was added to the driver settings
- SSH connection page validation is enhanced for jump servers
- Complex JDBC driver support was improved (context classloader + driver cache)
- Driver download error handle was fixed
- ‘Check for new driver version’ setting save was fixed
- Security:
- Many drivers were upgraded to avoid vulnerabilities: Neptune, Redis, Cassandra, Couchbase, BigQuery, Athena, Kafka, and YugabyteDB
- The master password dialog was redesigned, and users can select what to use: master password or integrated security
- Security pages in Preferences were improved
- The Export functionality and Version Update can now be completely disabled.
- Accessibility
- Screen-reader support was improved (JAWS)
- Editor tab names reading was fixed
- Amazon Neptune driver: vulnerable dependencies were updated
- Athena driver was updated to version 42-2.1.1.1000
- Apache Arrow: the promt to download already downloaded driver was removed
- AWS Neptune driver was upgraded
- Clickhouse:
- Array map representation was fixed
- IPv4 data representation was fixed
- Google Spanner: table DDL generation was fixed
- DB2 LUW: trigger editor was fixed
- DB2 driver was upgraded to version 11.5.9.0
- Databricks: The issue with national encodings was resolved
- Greenplum:
- The issue with case-sensitive table names was resolved
- FFL for function parameters was fixed
- External tables representation was fixed
- Foreign key creation was fixed
- Exasol: customer group creation was fixed
- Firebird:
- Several keywords were added
- Default values for procedure parameters are now displayed
- The Infux icon was changed
- Materialized: system schemas loading was fixed
- MongoDB:
- UUID representation was fixed
- AI Smart Assistance was fixed
- MySQL:
- The driver version was upgraded to 8.2
- MySQL5 driver is available
- Session manager now shows info from performance_schema
- Unsupported engine types are replaced with the default one
- OceanBase:
- The views editor was supported
- Routines and procedure parameters read were fixed
- OpenEdge: root catalog is now hidden; data export was fixed
- Oracle:
- Partitions support was added: the ability to manage partitions via UI
- Materialized views indexes management was supported
- Materialized views permissions and dependencies view were added
- Comment for the created column was added
- Column alter DDL was fixed (NULL clause)
- Search package bodies as packages were supported
- Comments were added to the newly created columns
- PostgreSQL:
- Default privileges presentation and editing were supported
- The foreign tables folder was added
- Backup/restore native tools execution was fixed
- Procedure parameters validation was added to the debugger
- `Europe/Kyiv` timezone support was fixed
- The issue with the VARCHAR limit change was fixed
- Function comment delete support was added
- Sequences permissions reading for quoted roles were fixed
- Foreign key DDL was fixed (MATCH FULL)
- Enum data type reading performance was enhanced
- Incorrect restore was fixed
- Foreign key creation was fixed
- Redshift:
- Backup/Restore tools were deprecated and removed from UI
- Spectrum tables loading was fixed (for custom driver configurations)
- SQLite: required columns creating was fixed
- SQL Server: extra dialect keywords were added
- Snowflake:
- Driver was updated to 3.13.25
- Materialized views are now supported
- Schema create UI was enhanced
- The numeric data display was fixed
- Teradata: Secure Zones presentation was improved
- Trino: Views DDL support was added
- Localization:
- Brazilian Portuguese translation was fixed
- Chinese Simplified translation was updated