Changelog

New Features

• "Configure Data Extractor" adds more options: table names and field names in SQL INSERT can be quoted, datetime values can choose between native database format or quoted string format (YYYY-MM-DD HH:mm:ss), preview takes effect synchronously
• Data transfer supports InterSystems IRIS and Caché as transfer source and target
• Database lookup supports opening as tabs, allowing multiple lookup tasks to be retained simultaneously
• Redis value viewing automatically recognizes JSON content and formats the display
• SQL library automatically associates the target database when opening and importing saved SQL, inferred from existing files in the folder, the current tab, or the connection's default database, no longer fixed to an empty library
• Query tab titles display the current schema and catalog scope, making it easier to distinguish queries under different scopes
• Sidebar supports a shortcut key to disconnect, the key can be customized in settings
• Sidebar "Copy Display Path" action extended to all database types
• Added "Locate in Sidebar" to the right-click menu of tables and views in the object browser
• Added setting "Reload restored table data on open", automatically reloading when entering a restored table data tab, equivalent to pressing refresh

Improvements

• Table export also supports cancellation during the row count statistics stage before export, the UI cancel entry responds more promptly
• The export connection configuration dialog changed to a grouped tree display by sidebar, supporting expanding groups to check connections
• PostgreSQL concurrently races resolved addresses when establishing connections, making connection establishment faster and more stable on multi-address hosts
• The canvas surface flip of the query result grid is only performed when the backing store size changes, reducing unnecessary redraws and stuttering during scrolling
• The grid error prompt banner changed to full width and the body text is de-emphasized, making error messages more prominent and readable
• Plugin contribution panel card layout tidied up, badge rows automatically collapse when too long

Fixes

• Fixed the issue where DB2 queries containing large LOB/BLOB columns previewed by reading the full content, causing memory usage to spike and stuttering, large object previews now use SUBSTR truncation
• Fixed the issue where the TLS hostname was lost when connecting to ClickHouse through a proxy, causing handshake failure
• Fixed the issue where tables in DuckDB attached (ATTACH) databases could not resolve columns when using two-part table names, column information browsing and completion now work normally
• Fixed the issue where the view module of Sybase (JDBC connection) could not view DDL statements, view definitions are now loaded and concatenated in system catalog order
• Fixed the issue where table comments and field comments were lost when cloning tables in SQL Server
• Fixed the issue where Snowflake completion only resolved the default database, and table names could not be completed in non-default database modes, completion now resolves by the actual database and schema namespace
• Fixed the issue where SELECT pagination with duplicate columns reported an error in OceanBase Oracle mode, pagination rewriting preserves duplicate column projections
• Fixed the issue where object metadata in OceanBase (Oracle mode) was missing package bodies (PACKAGE BODY), and package bodies could not be displayed normally
• Fixed the issue where Vastbase (Massive Database) could not provide the old password when changing a user password, after changing one's own password the old connection credentials immediately become invalid and prompt to enter the new password to reconnect
• Fixed the issue where Redis could not view old-encoding hash types in Kvrocks, hash operations are now compatible with old encodings
• MongoDB collection table totals include typed BSON numeric columns, negative numbers follow the original semantics and are not included
• Fixed the issue where the Qdrant query editor mistakenly used SQL syntax highlighting and completion, now disabling inapplicable SQL language features
• Fixed the issue where the SQL worksheet did not use the actual query statement of the current page when exporting the current page to XLSX, the SQL worksheet format is also corrected
• Fixed the issue where each worksheet's own auto-filter settings were overridden by the global switch when exporting XLSX on the Web side
• Fixed the issue where the editor scrolled noticeably stuttery after selecting all of a long SQL
• Fixed the issue where copying negative pure numeric text cells was mistakenly prefixed with formula protection, the entire string of digits starting with a minus sign is now copied as-is
• Completed missing translation keys in the multilingual interface and cleaned up invalid keys, avoiding the interface displaying raw key names
• Fixed the issue where background wallpaper transparency was lost and hover tooltips did not restore normal colors after switching from dark theme back to light theme
• Fixed the conflict issue when saving SQL to the SQL library encounters a duplicate file name, saving now automatically increments the number and prompts
• Fixed the issue where the workbench HTML cache was not invalidated after plugin collection changes, causing the plugin interface to display old content
• Fixed the issue where plugin uninstallation failed due to no write permission to files during uninstallation, the plugin sidecar process is also reclaimed on shutdown
• Fixed the issue where Agent-type connections occasionally exited instantaneously on startup, causing connection open errors, now changed to automatic retry
• The Web version immediately completes shutdown and exits upon receiving Ctrl+C or SIGTERM, no longer hanging for a long time

---

<!-- dbx-cnb-mirror -->

Domestic download: If GitHub download is slow, you can download the desktop installation package from the CNB mirror, and pull the Docker image from docker.cnb.cool/dbxio.com/dbx:v0.6.32.