DbVisualizer کے پرانے ورژن – تمام ورژنز

Improvements
Database Objects Tree
Start quick search in the Databases tab from the currently selected position
Export
Add the ability to set a default sheet name for Excel exports
Grid Component
Make the time component optional when entering timestamps in the grid
Bugs Fixed
Auto-Completion
Auto-complete gives no suggestions after unrecognized keywords in CASE
Auto-complete may miss valid column suggestions in statements that contain multiple USING clauses
Connection Setup
Can't choose a file when configuring file-based databases
DB Support: Oracle
Incorrect script generated when adding a datafile without a filename (OMF)
DB Support: PostgreSQL
Error fetching constraint DDL in PostgreSQL
Export/Import User Settings
SSH configurations are not included when exporting mounted connections
Favorites
Error when renaming items in the Favorites tab
Grid Component
Error when moving columns in the grid
OS Support: Windows
Application title is missing in the Windows taskbar
Query Builder
Various JOIN-related fixes in the query builder
SQL Commander
Pressing Alt+Left and Alt+Right may not switch tabs as expected
Pressing the End key is not recorded in macros
Refreshing metadata may incorrectly report a read-only result set as editable
Tabs may be lost or ungrouped when moving tab groups between windows
SQL Log
Error when saving large log files
Security
Connection may fail with a missing master password error when no master password is configured

Improvements
AI
Support for AI models with adaptive thinking capabilities
Bugs Fixed
AI
AI chat history gets out of sync when switching between chats
Missing database schema details in the AI context
DB Support: Oracle
Temp files are listed multiple times in Oracle
Files
OS Support: Windows
Network drives appear empty in the Files tab until a refresh is triggered
Installation/Update Installation
Restarting after an application update opens the default workspace instead of the previously active workspace
Monitor
Monitored queries are not initialized on application start
Performance/Stability
Unexpected error upon background task completion
Unexpected error when OS theme changes
SQL Commander
Error when closing a tab with an ongoing query
SQL Commander tabs within closed tab groups are lost after an application restart

New Features
AI
Contextual AI actions in SQL Commander
Support for multiple vendors and models in the AI assistant
App Logging
Add audit logging for executed SQL statements
DB Support: Amazon Athena
Add basic support for Amazon Athena
DB Support: InfluxDB
Add basic support for InfluxDB
Grid Component
Add map visualization for geospatial data
Notifications
Introduce in-app notifications
SQL Commander
Add support for tab groups in SQL Commander
Vim mode in SQL Commander
Improvements
AI
Run query from the AI assistant
Check for Update
Implement in-app updates when checking for updates manually
DB Support: Db2 z/OS
Extract view DDL in Db2 z/OS
DB Support: Hive
Update the Apache Hive template to use the official standalone driver
DB Support: SQL Server
Mark non-online databases in the database objects tree for SQL Server
Database Objects Tree
Add quick search for database connections in the Databases tab
Driver Manager
Add support for Maven artifact classifiers
Update template drivers
Grid Component
Improve the functionality, performance and UX of the quick filter in grids and trees
SQL Commander
Enhance the connection selector in SQL Commander to support search and hierarchies
Implement smooth scrolling between editor tabs
Security
Add an option to accept and trust any certificate within a validation chain
Value Viewer
Add support for editing JSON values in the Value tab
Add syntax highlighting for JSON and XML values in the Value tab
Bugs Fixed
DB Support: PostgreSQL
MAINTAIN grant isn't displayed correctly in the Grants tab for PostgreSQL
Database Objects Tree
Possible error when removing a database connection
OS Support: Linux
SQL Editor
Editor font isn't scaled correctly on Linux
OS Support: Windows
SQL Editor
Editor loses input focus when activating rectangular selection on Windows
OS Support: Windows
Value Viewer
International characters are not always displayed correctly in the Value tab on Windows
Performance/Stability
Possible error during application startup
Workspace
Maximized window may be restored on the wrong monitor

Improvements
Installation/Update Installation
OS Support: Linux
Sign RPM and DEB installers
SQL Commander
Expand the Alt+Click pinning area to the entire tab header
Bugs Fixed
Auto-Completion
Auto-complete dialog may produce an error on some locales
Auto-complete may ignore connection-level settings
DB Support: PostgreSQL
"Show Only Default Database/Schema" doesn't always work for PostgreSQL
Possible error when connecting to PostgreSQL
DDL Generator
Generated DDL should quote column names automatically where necessary
Git
Possible intermittent error when performing Git operations
Grid Component
Possible error when editing data in the grid
Installation/Update Installation
OS Support: Linux
Can't browse to an alternative installation directory on Linux
Performance/Stability
Possible error during startup
Query Builder
Some relations are not visible in the query builder
Tool Properties
Unsaved changes warning may be displayed though no changes were made

Improvements
DB Support: Exasol
New keywords and other improvements for Exasol
DB Support: Mimer SQL
Support for deferred foreign key constraints and other improvements for Mimer SQL
DB Support: Redshift
Automatically handle invalid entries in search_path when working with Redshift
SQL Commander
Add an option to keep existing result set tabs without pinning them
Bugs Fixed
AI
Possible error during login
Auto-Completion
Auto-complete doesn't work following the USING clause
DB Support: Azure SQL
JSON columns are not listed in the database objects tree for Azure
Possible error when trying to connect without specifying a default database in Azure SQL
DB Support: DB2 LUW
Possible error in the DBMS Output tab when working with Db2
DB Support: PostgreSQL
Export may generate incomplete DDL for check and unique constraints in PostgreSQL
DB Support: Snowflake
Warning during connect when using recent versions of the Snowflake driver
Database Objects Tree
Original connection is displayed after using Duplicate Database Connection
Possible error when removing a database connection
File Chooser
File chooser may forget the last used directory
Files
Expanded nodes in the Files tab are not always restored after restart
Possible error when moving entries in the Files tab
Git
Possible error when switching between branches in the Git Log tab
Grid Component
Possible error when editing values in the grid
Possible error when previewing PDF documents in the Value tab
Value tab may get out of sync with the current selection in the grid
Installation/Update Installation
Automatic updates don't always work when using a proxy
SQL Commander
Possible error when switching between tabs in SQL Commander
Tabs can accidentally be pinned when switching between them

New Features
AI
Introduce the AI assistant
DB Support: Impala
Add basic support for Impala
DB Support: Neo4j
Add basic support for Neo4j
File Chooser
Introduce the OS native file chooser
Improvements
Connection Setup
Create missing SSH configurations when mounting a database connection folder
Mount database connection folders using drag and drop
DB Support: Azure SQL
Avoid multiple authentication prompts when working with Azure
DB Support: Databricks
Add support for streaming tables in Databricks
Simplify connection setup for the authentication flows available in Databricks
DB Support: Informix
Make is possible to import data into temporary tables in Informix using @import
Driver Manager
Update template drivers
Grid Component
Add an action to copy grid selection as a Markdown table
Installation/Update Installation
Add an option to install DbVisualizer for the current user only
Java
Bundle Java 25 with installers
Performance/Stability
Improve application performance when working with many editor tabs
Improve application startup time
SQL Commander
Add a predefined variable for current clipboard contents
Quickly access recently used database connections in SQL Commander
Bugs Fixed
Auto-Completion
"Fully Qualify Objects" may generate incorrect completions
Incorrect suggestions or error when auto-completing columns in a derived table
Connection Setup
Driver type may be reset when editing multiple database connections
DB Support: ClickHouse
Error during connect when using the latest Clickhouse driver
DB Support: Snowflake
Error during connect when using the latest Snowflake driver
TIME values are saved incorrectly when editing in a grid or using parameterized queries
Database Objects Tree
Database connection filters may be lost
File Chooser
OS Support: Windows
Performance/Stability
File chooser may be slow or freeze the application when running on a Windows environment with mapped network drives
General
Main window isn't maximized on application start
Git
Git operations can fail if the application is set up to use the system proxy but it is not available
Grid Component
When pasting table data into a grid, only changed cells should be highlighted as updated
Performance/Stability
Application interface doesn't appear on startup
Performance/Stability
SQL Commander
Application may freeze when working with a large script if Show Tab Lines is on

Bugs Fixed
DB Support: ClickHouse
Misleading warning when saving table data in ClickHouse
Some integer types are sorted as strings in ClickHouse
DB Support: Databricks
Create/Alter Table doesn't work with recent versions of the Databricks driver
DB Support: Redshift
Error when expanding DistKey and SortKey nodes in the database objects tree for Redshift
Git
Unmerged paths error in the Git tab
Grid Component
Time zone setting isn't handled correctly in result grids
Monitor
Monitored queries are not reloaded automatically
Visibility of monitored queries isn't always reflected correctly in the Files tab
OS Support: macOS
Application fails to start on old versions of macOS
Double-clicking in the title bar of the main window doesn't work on macOS 26
Performance/Stability
SQL Commander
Potentially slow metadata lookup when displaying data from an anonymous subquery
SQL Commander
Can't reload a result set after reconnect
SQL Commander
UX/UI
Flickering in the connection, database and schema dropdowns in SQL Commander

Improvements
DB Support: Exasol
Add support for PREPROCESSOR script type in Exasol
Driver Manager
Detect new versions for drivers that contain multiple artifacts
UX/UI
Activate hovered sidebar button during drag and drop
Bugs Fixed
Auto-Completion
Auto-complete gives no suggestions following a qualified function call
Auto-complete may fail to find matching tables
DB Support: MongoDB
Error when switching to text mode in the Document tab in MongoDB
DB Support: Oracle
Error when modifying a scheduler job in Oracle
DB Support: PostgreSQL
Indexes on partitioned tables are not always displayed in the database objects tree for PostgreSQL
Data tab
Tables are not qualified when copying filter SQL
Database Objects Tree
Unable to expand database connections after drag and drop
Export/Import User Settings
Recent paths are not included in the export
Grid Component
Timestamps with microsecond precision are truncated to milliseconds when editing in the Value tab
SQL Commander
Can't close all pinned tabs at once
Possible exception in the read-only result set indicator
SSH
SSH connection errors are reported as application errors
Table Data Editor
Should not have to select key columns when inserting into a table that has no primary key
When updating a table row, permissions for DELETE are checked instead of UPDATE

New Features
Connection Setup
Add support for shared database connections
Git support for database connections
DB Support: MongoDB
Add support for creating, editing and deleting documents in MongoDB
DB Support: Valkey
Add support for Valkey
UX/UI
Introduce the sidebar layout
Improvements
Auto-Completion
Performance/Stability
Improve auto-complete performance when working with large schemas
DB Support: Exasol
Add new keywords for Exasol
DB Support: MongoDB
Display indexes in the database objects tree for MongoDB
Optimise performance when working with complicated data structures in MongoDB
Redesign the data grid for MongoDB
Driver Manager
Update template drivers
Git
Add support for three-way merge in Git
SQL Commander
Highlight matching curling braces in the editor (similarly to parentheses)
Select row count for the current query in SQL Commander
Bugs Fixed
Auto-Completion
Inconsistent quoting of table alias when auto-completing a column name
Connection Setup
Can't clear existing connection properties in some cases
Database connection may fail due to wrong delimiters
DB Support: ClickHouse
Error when displaying a data set containing JSON in ClickHouse
DB Support: Databricks
Decimal values may be truncated when importing data in Databricks
Exception when connecting to Databricks using the latest driver
DB Support: MongoDB
Can't connect to MongoDB with an empty user name
DB Support: Oracle
Export table doesn't work for global temporary tables in Oracle
DB Support: PostgreSQL
Possible error when using Connect and Execute in PostgreSQL
DB Support: Presto
Result sets are always read-only in Presto
DB Support: SQL Server
Database profile error for SQL Server 2000
Database Objects Tree
Exception when moving connections in the Databases tab
Driver Manager
Possible exception in Driver Manager
Git
Remove confirmation after reload in the Git tab
Grid Component
Image preview in the grid can be wrong when a new row is added
Procedure Editor
Package navigator may open a wrong location in the source code
SQL Commander
Query may fail to execute after deselecting database in SQL Commander

Improvements
DB Support: MongoDB
Further optimisations of read performance when working with MongoDB
DB Support: PostgreSQL
Display triggers under views in the database objects tree for PostgreSQL
Driver Manager
Tool Properties
Test authentication when checking availability of Maven repositories in Tool Properties
Bugs Fixed
Auto-Completion
Auto-complete dialog may be closed too early when working with editor templates
Auto-complete dialog may show up blank
Auto-Completion
DB Support: Denodo
Auto-complete doesn't work when using Denodo
Auto-Completion
DB Support: Google BigQuery
Datasets from all projects are displayed when using auto-complete in BigQuery
Connection Setup
Removed connection properties are not always saved
Test Connection doesn't work for some databases
Unable to set sensitive driver properties to a blank value
DB Support: Exasol
Monitor
Error in the Monitor tab when working with Exasol
DB Support: Firebird
References
References graph isn't displayed correctly for Firebird
DB Support: H2
Export Schema always qualifies table names in foreign keys in H2
Incorrect DDL is generated for columns with type DOUBLE in H2
DB Support: H2
References
References graph can appear without links in H2
DB Support: PostgreSQL
Missing primary key in table DDL for PostgreSQL
DB Support: Snowflake
Missing output when creating a programmatic access token in Snowflake
Files
Expanding large folders in the Files tab can be slow
Unrelated editor tabs are closed when deleting a file in the Files tab
Wrong sort order in the Files tab
Grid Component
Error when editing an array in the Value tab
Incorrect encoding is used in the JSON viewer
OS Support: Windows
OS theme detector may be blocked by AppLocker on Windows
Query Builder
JOIN is not always generated automatically in Query Builder
References
Nullable columns not marked in the references graph

Improvements
Grid Component
Add support for opening the current data grid in a web browser
Bugs Fixed
Auto-Completion
Auto-complete fails after a CASE statement followed by a column alias
Exception when using automatic auto-complete in disconnected state
Possible exception when expanding editor templates
Auto-Completion
DB Support: PostgreSQL
Auto-complete doesn't handle DISTINCT ON correctly
DB Support: MongoDB
Not all memory is released as expected when working with MongoDB
File Chooser
Possible exception when saving a script as a bookmark or monitor
Files
Expanded nodes in the Files tab are not restored after restart
Query Builder
Broken JOINs may be generated for some databases in Query Builder

Improvements
DB Support: Oracle
Add support for exporting materialized views in Oracle
DB Support: Snowflake
Add actions to drop tasks and streams in Snowflake
Grid Component
Add an option to choose grid or editor font in the Value tab
Add an option to open grid viewers in separate windows
SQL Commander
Streamline tab actions and add "Close Tabs to the Right"
Bugs Fixed
Auto-Completion
Exception in the auto-completion popup
DB Support: Cache
Result sets are always read-only when working with InterSystems Caché
DB Support: DB2 LUW
Error when retrieving explain plan in Db2
EXCLUDE/INCLUDE NULL KEYS is missing in index DDL in Db2
DB Support: MongoDB
Loading a result set is slow when working with MongoDB
Reloading a table in MongoDB becomes slower over time
DB Support: Oracle
Slow response times when fetching data in Oracle for certain types of scripts
DB Support: PostgreSQL
Incorrect DDL for custom enum types in PostgreSQL
DB Support: SQL Server
Error when expanding the Databases node in older versions of SQL Server
Errors in profile actions in SQL Server
DB Support: Snowflake
Performance regression when fetching data in Snowflake
DB Support: Sybase ASE
Possible exception when saving binary and text data in Sybase ASE
Grid Component
Always allow Text and Text (Wrapped) in the Value tab
Monitor
Chart settings are not saved for data monitors
SQL Commander
Cannot select catalog and schema for some databases in SQL Commander

Improvements
Git
Add support for using a proxy when connecting to a Git repository
Bugs Fixed
Auto-Completion
Possible exception when auto-completing within a CASE statement inside a subselect
DB Support: InterSystems IRIS
Auto-complete doesn't work when using InterSystems IRIS
DB Support: PostgreSQL
Exception when connecting to PostgreSQL using dbviscmd
SQL Commander
The database dropdown is not always refreshed after a cache reload
UX/UI
Possible exception when application theme changes due to OS theme change

Improvements
Git
Reorder Git repositories using drag and drop
Bugs Fixed
Auto-Completion
Possible exception when using auto-complete while disconnected
Connection Setup
Possible exception when trying to create a database connection
Contact Support
Possible exception when submitting a support request
DB Support: DB2 LUW
Schema names are incorrect when using Db2 12
DB Support: MySQL
Databases are not sorted correctly in the database objects tree when using the latest MySQL driver
DB Support: Snowflake
Can't use iceberg and external tables in Query Builder
Identifiers may be unnecessarily delimited when auto-completing
Data tab
Possible exception when using reload in the Data tab
Export
Text data may be truncated during export
Files
Improved performance when working with large folders in the Files tab
Quick filter doesn’t always find matching entries in Bookmarks and Monitors in the Files tab
Grid Component
Exception for large values of Max Scale in the Aggregates tab
Possible exception when closing a grid while the Record tab is open
Possible exception when editing data in the grid
Import
Column type may be auto-detected as array instead of string when importing table data
Navigator
Relations are presented incorrectly in the Navigator view
Performance/Stability
Possible exception on application shutdown
References
Reference graph does not work for tables containing multi-column foreign keys
SQL Commander
"Show in Files" not always enabled in SQL Commander
Possible exception in SQL Commander
Possible exception when generating a chart
Tab guidelines disappear when application font size is increased

New Features
DB Support: Denodo
Add basic support for Denodo
DB Support: Redis
Add support for Redis
Git
Add support for Git
Grid Component
Add a quick aggregation feature to data grids
Improvements
Auto-Completion
Implement auto-completion of catalog and schema names
Improve automatic quoting when using auto-completion
Improve case awareness in the auto-completion engine
Command Line Support (dbviscmd)
Add support for setting connection password and user id using dbviscmd
Connection Setup
Download driver artifacts automatically
Introduce "Test Connection" with support for SSH and file-based databases
DB Support: H2
Add support for JSON values in H2
DB Support: Snowflake
Implement tree and graph views for explain plans in Snowflake
Driver Manager
Update template drivers
Grid Component
Add an indicator with additional information when a result set is not editable
Improve handling of large data fields
Improve the value, record and aggregation views
Bugs Fixed
App Logging
Improve handling of warnings during application startup
Mask potentially sensitive driver properties in application logs
Auto-Completion
Auto-completion doesn't work as expected when using a combination of WITH and table alias
Auto-completion doesn't work correctly when TOP is used
Auto-completion should support multi-columns JOINs
Improve handling of CASE in the context of WITH statements
Improve handling of identifiers that contain numbers
DB Support: H2
TOP is not recognised as a keyword in H2
DB Support: Snowflake
Incorrect DDL is generated for hybrid tables in Snowflake
Export/Import User Settings
Exception when exporting settings to a directory that does not exist
Grid Component
Application freezes when loading BLOB data when presentation is set to "Value"
Some grids are not scaled correctly when using larger fonts
OS Support: Windows
Application may crash after reconnect when using Remote Desktop on Windows
Performance/Stability
Possible exception during application startup