DbVisualizer

What's new in this version:

DbVisualizer 24.2.3
- Add an action to create types in PostgreSQL
- Add an action to create domains in PostgreSQL


DbVisualizer 24.2.2
Improvements:
SQL Commander:
- Display execution duration in the tooltip of the result tab

Fixed:
- 'Max Rows" should not be applied to updates within undelimited statement blocks in SQL Server
- Exception in "Drop Package"
- "Alter Table" doesn't work for certain versions of MariaDB and SingleStore
- Error when saving stored procedures in Redshift for certain driver versions
- PRINT statements are not always reported in the Log tab
- Exception when generating column constraints in SQLite in certain cases
- "Create Sequence" generates incorrect SQL in Snowflake
- Function DDL may be incomplete in Snowflake
- JSON values are interpreted as parameter markers in Snowflake
- "Quote Text Value" is not set correctly when loading export settings
- Column type is set to "Custom" when exporting numbers to Excel
- The choice of font may be lost after application restart
- Package navigator does not show all procedures/functions
- Not able to save procedures and functions for some languages
- Table and columns names are not always qualified properly in Query Builder
- Rows in the "Conditions" tab in Query Builder may be clipped
- Error in the generated HAVING clause in Query Builder
- Possible visual artifacts when hovering the "Sticky" control in SQL Commander
- Actions in the "Find and Replace Toolbar Actions" category are not listed correctly in the key bindings editor
- Availability check for Maven repositories in Tool Properties doesn't work when a proxy is used
- Possible exception on application start when checking OS theme settings


DbVisualizer 24.2.1
- Change log not available for this version


DbVisualizer 24.2
New Features:
- Add support for creating persistent database connections using dbviscmd
- Add support for Azure Synapse Analytics
- Add support for the Cassandra JDBC Wrapper driver
- Add basic support for Databricks
- Navigate between procedures and functions in the package body editor
- Add support for generating MERGE statements when exporting data as SQL
- Add support for trimming text values when exporting data
- Add actions to select the previous/next statement in the editor (Ctrl+Alt+Up/Down)
- Automatic theme switching
- New dark and light themes
- Introduce new scalable icons
- Automatically qualify columns when the column name alone is ambiguous
- Add support for SVG images in the cell viewer and the data grid
- Improve the response to "PKIX path building failed"
- Add support for generated columns in MySQL in Create/Alter Table
- Add support for sequence name in auto-generated columns in PostgreSQL
- DB Support: Greenplum Add support for Greenplum 7
- DB Support: Greenplum
- DB Support: PostgreSQL
- DB Support: Redshift
- DB Support: Yellowbrick Display table constraints under the corresponding table node in the database objects tree
- DB Support: PostgreSQL Add support for roles in PostgreSQL (replacing users and groups)
- DB Support: Redshift Add support for materialized views in Redshift
- DB Support: Snowflake Handle additional table types in Snowflake (dynamic, event, hybrid and iceberg tables)
- Database Objects Tree In the database objects tree, add an indicator to nodes where all sub-nodes were hidden by an active filter
- Export Use SQL syntax highlighting in the preview section in Export Grid
- Automatically suggest file extensions when exporting data
- General Improved support for arrays
- Grid Component Display newlines and tabs as symbols rather than whitespace in text values in the data grid
- Multi-thread image preview generation
- SQL Commander With auto-commit off, show the actual statements when warning the user about uncommitted updates
- Add support for a list of choices in custom variables
- SQL Editor Add a button for newline in Find and Replace
- Support newline, tab and uppercase/lowercase manipulation in Find and Replace
- Handle identifier delimiters based on database type instead of user configuration
- Security Add the option to reset master password also when a master password is required

Fixed:
- Area Details
- Auto-Completion Auto-Completion may fail when operators are used in the SELECT clause
- Auto-completing a column in a sub-select may insert an alias from the outer query
- Auto-completion doesn't work after INSERT INTO
- Auto-completion doesn't work with the USING join syntax
- The auto-completion popup may behave strangely if a database error occurs when loading table metadata
- Create/Alter Table
- DB Support: PostgreSQL NOT NULL can be omitted in the DDL for auto-generated columns in PostgreSQL
- DB Support: ClickHouse Can't list databases in older versions of ClickHouse
- DB Support: Exasol Incorrect SQL generated by the "Create User LDAP" action in Exasol
- Export/Import User Settings Passwords are not included when exporting/importing SSH configurations
- Key Bindings Some of the assigned key combinations may stop working until the application is restarted
- OS Support: macOS Expanding database nodes using the keyboard may result in the spinning beachball on macOS Sonoma
- Query Builder When loading a query containing an unsupported operator into the query builder, it is replaced with "="
- SQL Commander "Enter Data for Variables" dialog does not reflect the initial state of boolean variables
- SQL Editor Multi-caret select may exclude the first line when clicking outside of the editor
- The delete key doesn't work in multi-caret mode
- Tool Properties "Show Password" doesn't work for authentication type Public Key in Tool Properties->SSH Configurations